• Michael Widenius's avatar
    Fixes for CREATE_OR_REPLACE · 43f6e118
    Michael Widenius authored
    - MDEV-5587 Server crashes in Locked_tables_list::restore_lock on CREATE OR REPLACE .. SELECT under LOCK
    - MDEV-5586 Assertion `share->tdc.all_tables.is_empty() || remove_type != TDC_RT_REMOVE_ALL' fails in tdc_remove_table
    - MDEV-5588 Strange error on CREATE OR REPLACE table over an existing view
    
    mysql-test/r/create_or_replace.result:
      Added test cases
    mysql-test/r/lowercase_view.result:
      New error message
    mysql-test/r/merge.result:
      New error message
    mysql-test/r/multi_update.result:
      New error message
    mysql-test/r/subselect.result:
      New error message
    mysql-test/r/subselect_exists_to_in.result:
      New error message
    mysql-test/r/subselect_no_mat.result:
      New error message
    mysql-test/r/subselect_no_opts.result:
      New error message
    mysql-test/r/subselect_no_scache.result:
      New error message
    mysql-test/r/subselect_no_semijoin.result:
      New error message
    mysql-test/r/view.result:
      New error message
    mysql-test/suite/funcs_1/r/myisam_views-big.result:
      New error message
    mysql-test/t/create_or_replace.test:
      New tests
    mysql-test/t/view.test:
      New error message
    sql/share/errmsg-utf8.txt:
      Added new error message
    sql/sql_base.cc:
      Updated error message
      Do an automatic UNLOCK TABLES if we don't have any locked tables (safety fix)
    sql/sql_db.cc:
      Updated arguments
    sql/sql_load.cc:
      New error message
    sql/sql_parse.cc:
      Check that we are not using a table we are dropping and re-creating
    sql/sql_table.cc:
      Added parameter to mysql_rm_table_no_locks() to not automaticly do UNLOCK TABLES
      Added better error message if trying to drop a view with DROP TABLE
      Don't try to create something we select from
    sql/sql_table.h:
      Updated prototypes
    43f6e118
lowercase_view.result 10.7 KB