diff options
Diffstat (limited to 'mysql-test/suite/atomic/drop_table.result')
| -rw-r--r-- | mysql-test/suite/atomic/drop_table.result | 274 |
1 files changed, 274 insertions, 0 deletions
diff --git a/mysql-test/suite/atomic/drop_table.result b/mysql-test/suite/atomic/drop_table.result new file mode 100644 index 00000000000..61ca91b2aa2 --- /dev/null +++ b/mysql-test/suite/atomic/drop_table.result @@ -0,0 +1,274 @@ +call mtr.add_suppression("InnoDB: .* does not exist in the InnoDB internal"); +RESET MASTER; +"engine: myisam crash point: ddl_log_drop_before_delete_table position: 1" +t2.MYD +t2.MYI +t2.TRG +t2.frm +t2_trg.TRN +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */ +"engine: myisam crash point: ddl_log_drop_before_delete_table position: 2" +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */ +"engine: myisam crash point: ddl_log_drop_after_delete_table position: 1" +t2.MYD +t2.MYI +t2.TRG +t2.frm +t2_trg.TRN +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */ +"engine: myisam crash point: ddl_log_drop_after_delete_table position: 2" +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */ +"engine: myisam crash point: ddl_log_drop_before_drop_trigger position: 1" +t2.MYD +t2.MYI +t2.TRG +t2.frm +t2_trg.TRN +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */ +"engine: myisam crash point: ddl_log_drop_before_drop_trigger position: 2" +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */ +"engine: myisam crash point: ddl_log_drop_before_drop_trigger2 position: 1" +t2.MYD +t2.MYI +t2.TRG +t2.frm +t2_trg.TRN +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */ +"engine: myisam crash point: ddl_log_drop_before_drop_trigger2 position: 2" +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */ +"engine: myisam crash point: ddl_log_drop_after_drop_trigger position: 1" +t2.MYD +t2.MYI +t2.TRG +t2.frm +t2_trg.TRN +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */ +"engine: myisam crash point: ddl_log_drop_after_drop_trigger position: 2" +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */ +"engine: myisam crash point: ddl_log_drop_before_binlog position: 1" +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */ +"engine: myisam crash point: ddl_log_drop_before_binlog position: 2" +"No crash!" +master-bin.000001 # Query # # use `test`; DROP TABLE `t1`,`t2` /* generated by server */ +"engine: myisam crash point: ddl_log_drop_after_binlog position: 1" +master-bin.000001 # Query # # use `test`; DROP TABLE `t1`,`t2` /* generated by server */ +"engine: myisam crash point: ddl_log_drop_after_binlog position: 2" +"No crash!" +master-bin.000001 # Query # # use `test`; DROP TABLE `t1`,`t2` /* generated by server */ +"engine: aria crash point: ddl_log_drop_before_delete_table position: 1" +t2.MAD +t2.MAI +t2.TRG +t2.frm +t2_trg.TRN +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */ +"engine: aria crash point: ddl_log_drop_before_delete_table position: 2" +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */ +"engine: aria crash point: ddl_log_drop_after_delete_table position: 1" +t2.MAD +t2.MAI +t2.TRG +t2.frm +t2_trg.TRN +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */ +"engine: aria crash point: ddl_log_drop_after_delete_table position: 2" +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */ +"engine: aria crash point: ddl_log_drop_before_drop_trigger position: 1" +t2.MAD +t2.MAI +t2.TRG +t2.frm +t2_trg.TRN +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */ +"engine: aria crash point: ddl_log_drop_before_drop_trigger position: 2" +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */ +"engine: aria crash point: ddl_log_drop_before_drop_trigger2 position: 1" +t2.MAD +t2.MAI +t2.TRG +t2.frm +t2_trg.TRN +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */ +"engine: aria crash point: ddl_log_drop_before_drop_trigger2 position: 2" +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */ +"engine: aria crash point: ddl_log_drop_after_drop_trigger position: 1" +t2.MAD +t2.MAI +t2.TRG +t2.frm +t2_trg.TRN +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */ +"engine: aria crash point: ddl_log_drop_after_drop_trigger position: 2" +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */ +"engine: aria crash point: ddl_log_drop_before_binlog position: 1" +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */ +"engine: aria crash point: ddl_log_drop_before_binlog position: 2" +"No crash!" +master-bin.000001 # Query # # use `test`; DROP TABLE `t1`,`t2` /* generated by server */ +"engine: aria crash point: ddl_log_drop_after_binlog position: 1" +master-bin.000001 # Query # # use `test`; DROP TABLE `t1`,`t2` /* generated by server */ +"engine: aria crash point: ddl_log_drop_after_binlog position: 2" +"No crash!" +master-bin.000001 # Query # # use `test`; DROP TABLE `t1`,`t2` /* generated by server */ +"engine: aria_notrans crash point: ddl_log_drop_before_delete_table position: 1" +t2.MAD +t2.MAI +t2.TRG +t2.frm +t2_trg.TRN +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */ +"engine: aria_notrans crash point: ddl_log_drop_before_delete_table position: 2" +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */ +"engine: aria_notrans crash point: ddl_log_drop_after_delete_table position: 1" +t2.MAD +t2.MAI +t2.TRG +t2.frm +t2_trg.TRN +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */ +"engine: aria_notrans crash point: ddl_log_drop_after_delete_table position: 2" +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */ +"engine: aria_notrans crash point: ddl_log_drop_before_drop_trigger position: 1" +t2.MAD +t2.MAI +t2.TRG +t2.frm +t2_trg.TRN +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */ +"engine: aria_notrans crash point: ddl_log_drop_before_drop_trigger position: 2" +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */ +"engine: aria_notrans crash point: ddl_log_drop_before_drop_trigger2 position: 1" +t2.MAD +t2.MAI +t2.TRG +t2.frm +t2_trg.TRN +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */ +"engine: aria_notrans crash point: ddl_log_drop_before_drop_trigger2 position: 2" +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */ +"engine: aria_notrans crash point: ddl_log_drop_after_drop_trigger position: 1" +t2.MAD +t2.MAI +t2.TRG +t2.frm +t2_trg.TRN +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */ +"engine: aria_notrans crash point: ddl_log_drop_after_drop_trigger position: 2" +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */ +"engine: aria_notrans crash point: ddl_log_drop_before_binlog position: 1" +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */ +"engine: aria_notrans crash point: ddl_log_drop_before_binlog position: 2" +"No crash!" +master-bin.000001 # Query # # use `test`; DROP TABLE `t1`,`t2` /* generated by server */ +"engine: aria_notrans crash point: ddl_log_drop_after_binlog position: 1" +master-bin.000001 # Query # # use `test`; DROP TABLE `t1`,`t2` /* generated by server */ +"engine: aria_notrans crash point: ddl_log_drop_after_binlog position: 2" +"No crash!" +master-bin.000001 # Query # # use `test`; DROP TABLE `t1`,`t2` /* generated by server */ +"engine: innodb crash point: ddl_log_drop_before_delete_table position: 1" +t2.TRG +t2.frm +t2.ibd +t2_trg.TRN +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */ +"engine: innodb crash point: ddl_log_drop_before_delete_table position: 2" +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */ +"engine: innodb crash point: ddl_log_drop_after_delete_table position: 1" +t2.TRG +t2.frm +t2.ibd +t2_trg.TRN +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */ +"engine: innodb crash point: ddl_log_drop_after_delete_table position: 2" +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */ +"engine: innodb crash point: ddl_log_drop_before_drop_trigger position: 1" +t2.TRG +t2.frm +t2.ibd +t2_trg.TRN +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */ +"engine: innodb crash point: ddl_log_drop_before_drop_trigger position: 2" +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */ +"engine: innodb crash point: ddl_log_drop_before_drop_trigger2 position: 1" +t2.TRG +t2.frm +t2.ibd +t2_trg.TRN +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */ +"engine: innodb crash point: ddl_log_drop_before_drop_trigger2 position: 2" +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */ +"engine: innodb crash point: ddl_log_drop_after_drop_trigger position: 1" +t2.TRG +t2.frm +t2.ibd +t2_trg.TRN +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */ +"engine: innodb crash point: ddl_log_drop_after_drop_trigger position: 2" +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */ +"engine: innodb crash point: ddl_log_drop_before_binlog position: 1" +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */ +"engine: innodb crash point: ddl_log_drop_before_binlog position: 2" +"No crash!" +master-bin.000001 # Query # # use `test`; DROP TABLE `t1`,`t2` /* generated by server */ +"engine: innodb crash point: ddl_log_drop_after_binlog position: 1" +master-bin.000001 # Query # # use `test`; DROP TABLE `t1`,`t2` /* generated by server */ +"engine: innodb crash point: ddl_log_drop_after_binlog position: 2" +"No crash!" +master-bin.000001 # Query # # use `test`; DROP TABLE `t1`,`t2` /* generated by server */ +"engine: csv crash point: ddl_log_drop_before_delete_table position: 1" +t2.CSM +t2.CSV +t2.TRG +t2.frm +t2_trg.TRN +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */ +"engine: csv crash point: ddl_log_drop_before_delete_table position: 2" +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */ +"engine: csv crash point: ddl_log_drop_after_delete_table position: 1" +t2.CSM +t2.CSV +t2.TRG +t2.frm +t2_trg.TRN +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */ +"engine: csv crash point: ddl_log_drop_after_delete_table position: 2" +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */ +"engine: csv crash point: ddl_log_drop_before_drop_trigger position: 1" +t2.CSM +t2.CSV +t2.TRG +t2.frm +t2_trg.TRN +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */ +"engine: csv crash point: ddl_log_drop_before_drop_trigger position: 2" +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */ +"engine: csv crash point: ddl_log_drop_before_drop_trigger2 position: 1" +t2.CSM +t2.CSV +t2.TRG +t2.frm +t2_trg.TRN +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */ +"engine: csv crash point: ddl_log_drop_before_drop_trigger2 position: 2" +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */ +"engine: csv crash point: ddl_log_drop_after_drop_trigger position: 1" +t2.CSM +t2.CSV +t2.TRG +t2.frm +t2_trg.TRN +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by ddl recovery */ +"engine: csv crash point: ddl_log_drop_after_drop_trigger position: 2" +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */ +"engine: csv crash point: ddl_log_drop_before_binlog position: 1" +master-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1`,`t2` /* generated by ddl recovery */ +"engine: csv crash point: ddl_log_drop_before_binlog position: 2" +"No crash!" +master-bin.000001 # Query # # use `test`; DROP TABLE `t1`,`t2` /* generated by server */ +"engine: csv crash point: ddl_log_drop_after_binlog position: 1" +master-bin.000001 # Query # # use `test`; DROP TABLE `t1`,`t2` /* generated by server */ +"engine: csv crash point: ddl_log_drop_after_binlog position: 2" +"No crash!" +master-bin.000001 # Query # # use `test`; DROP TABLE `t1`,`t2` /* generated by server */ +Warnings: +Note 1051 Unknown table 'test.t1,test.t2' |