diff options
Diffstat (limited to 'mysql-test/suite/atomic/create_replace.result')
| -rw-r--r-- | mysql-test/suite/atomic/create_replace.result | 696 |
1 files changed, 0 insertions, 696 deletions
diff --git a/mysql-test/suite/atomic/create_replace.result b/mysql-test/suite/atomic/create_replace.result deleted file mode 100644 index 2c82dbce03e..00000000000 --- a/mysql-test/suite/atomic/create_replace.result +++ /dev/null @@ -1,696 +0,0 @@ -# Crash recovery -Table Create Table -const_table CREATE TABLE `const_table` ( - `new` int(11) DEFAULT NULL, - `b` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -insert into const_table values (1, 1), (2, 2); -flush tables; -# QUERY: CREATE OR REPLACE TABLE t1 (new int) -# CRASH POINT: ddl_log_create_before_install_new -t1.DATA1 -t1.DATA2 -t1.TRG -t1.frm -Table Create Table -t1 CREATE TABLE `t1` ( - `old` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -a INSERT t1 set @s= 1 BEFORE -# CRASH POINT: ddl_log_create_after_log_drop_backup -t1.DATA1 -t1.DATA2 -t1.TRG -t1.frm -Table Create Table -t1 CREATE TABLE `t1` ( - `old` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -a INSERT t1 set @s= 1 BEFORE -# CRASH POINT: ddl_log_create_after_log_rename_backup -t1.DATA1 -t1.DATA2 -t1.TRG -t1.frm -Table Create Table -t1 CREATE TABLE `t1` ( - `old` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -a INSERT t1 set @s= 1 BEFORE -# CRASH POINT: ddl_log_create_before_create_frm -t1.DATA1 -t1.DATA2 -t1.TRG -t1.frm -Table Create Table -t1 CREATE TABLE `t1` ( - `old` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -a INSERT t1 set @s= 1 BEFORE -# CRASH POINT: ddl_log_create_before_create_table -t1.DATA1 -t1.DATA2 -t1.TRG -t1.frm -Table Create Table -t1 CREATE TABLE `t1` ( - `old` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -a INSERT t1 set @s= 1 BEFORE -# CRASH POINT: ddl_log_create_after_create_table -t1.DATA1 -t1.DATA2 -t1.TRG -t1.frm -Table Create Table -t1 CREATE TABLE `t1` ( - `old` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -a INSERT t1 set @s= 1 BEFORE -# CRASH POINT: ddl_log_create_after_drop -# No crash! -t1.DATA1 -t1.DATA2 -t1.frm -master-bin.000001 # Query # # use `test`; CREATE OR REPLACE TABLE t1 (new int) -Table Create Table -t1 CREATE TABLE `t1` ( - `new` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -# CRASH POINT: ddl_log_create_after_send_data -# No crash! -t1.DATA1 -t1.DATA2 -t1.frm -master-bin.000001 # Query # # use `test`; CREATE OR REPLACE TABLE t1 (new int) -Table Create Table -t1 CREATE TABLE `t1` ( - `new` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -# CRASH POINT: ddl_log_create_after_save_backup -t1.DATA1 -t1.DATA2 -t1.TRG -t1.frm -Table Create Table -t1 CREATE TABLE `t1` ( - `old` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -a INSERT t1 set @s= 1 BEFORE -# CRASH POINT: ddl_log_create_after_install_new -t1.DATA1 -t1.DATA2 -t1.TRG -t1.frm -Table Create Table -t1 CREATE TABLE `t1` ( - `old` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -a INSERT t1 set @s= 1 BEFORE -# CRASH POINT: ddl_log_create_before_binlog -t1.DATA1 -t1.DATA2 -t1.TRG -t1.frm -Table Create Table -t1 CREATE TABLE `t1` ( - `old` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -a INSERT t1 set @s= 1 BEFORE -# CRASH POINT: ddl_log_create_after_prepare_eof -# No crash! -t1.DATA1 -t1.DATA2 -t1.frm -master-bin.000001 # Query # # use `test`; CREATE OR REPLACE TABLE t1 (new int) -Table Create Table -t1 CREATE TABLE `t1` ( - `new` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -# CRASH POINT: ddl_log_create_after_binlog -t1.DATA1 -t1.DATA2 -t1.frm -master-bin.000001 # Query # # use `test`; CREATE OR REPLACE TABLE t1 (new int) -Table Create Table -t1 CREATE TABLE `t1` ( - `new` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -# CRASH POINT: ddl_log_create_fk_fail -t1.TRG -t1.frm -t1.ibd -t2.frm -t2.ibd -Table Create Table -t1 CREATE TABLE `t1` ( - `old` int(11) NOT NULL, - `y` int(11) DEFAULT NULL, - PRIMARY KEY (`old`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -a INSERT t1 set @s= 1 BEFORE -# CRASH POINT: ddl_log_create_fk_fail2 -t1.TRG -t1.frm -t1.ibd -t2.frm -t2.ibd -Table Create Table -t1 CREATE TABLE `t1` ( - `old` int(11) NOT NULL, - `y` int(11) DEFAULT NULL, - PRIMARY KEY (`old`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -a INSERT t1 set @s= 1 BEFORE -# CRASH POINT: ddl_log_create_fk_fail3 -t1.TRG -t1.frm -t1.ibd -t2.frm -t2.ibd -Table Create Table -t1 CREATE TABLE `t1` ( - `old` int(11) NOT NULL, - `y` int(11) DEFAULT NULL, - PRIMARY KEY (`old`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -a INSERT t1 set @s= 1 BEFORE -# CRASH POINT: ddl_log_create_log_complete -t1.DATA1 -t1.DATA2 -t1.frm -master-bin.000001 # Query # # use `test`; CREATE OR REPLACE TABLE t1 (new int) -Table Create Table -t1 CREATE TABLE `t1` ( - `new` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -# CRASH POINT: ddl_log_create_log_complete2 -t1.DATA1 -t1.DATA2 -t1.frm -master-bin.000001 # Query # # use `test`; CREATE OR REPLACE TABLE t1 (new int) -Table Create Table -t1 CREATE TABLE `t1` ( - `new` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -# CRASH POINT: ddl_log_create_log_complete3 -t1.DATA1 -t1.DATA2 -t1.frm -master-bin.000001 # Query # # use `test`; CREATE OR REPLACE TABLE t1 (new int) -Table Create Table -t1 CREATE TABLE `t1` ( - `new` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -# QUERY: CREATE OR REPLACE TABLE t1 LIKE const_table -# CRASH POINT: ddl_log_create_before_install_new -t1.DATA1 -t1.DATA2 -t1.TRG -t1.frm -Table Create Table -t1 CREATE TABLE `t1` ( - `old` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -a INSERT t1 set @s= 1 BEFORE -# CRASH POINT: ddl_log_create_after_log_drop_backup -t1.DATA1 -t1.DATA2 -t1.TRG -t1.frm -Table Create Table -t1 CREATE TABLE `t1` ( - `old` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -a INSERT t1 set @s= 1 BEFORE -# CRASH POINT: ddl_log_create_after_log_rename_backup -t1.DATA1 -t1.DATA2 -t1.TRG -t1.frm -Table Create Table -t1 CREATE TABLE `t1` ( - `old` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -a INSERT t1 set @s= 1 BEFORE -# CRASH POINT: ddl_log_create_before_create_frm -t1.DATA1 -t1.DATA2 -t1.TRG -t1.frm -Table Create Table -t1 CREATE TABLE `t1` ( - `old` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -a INSERT t1 set @s= 1 BEFORE -# CRASH POINT: ddl_log_create_before_create_table -t1.DATA1 -t1.DATA2 -t1.TRG -t1.frm -Table Create Table -t1 CREATE TABLE `t1` ( - `old` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -a INSERT t1 set @s= 1 BEFORE -# CRASH POINT: ddl_log_create_after_create_table -t1.DATA1 -t1.DATA2 -t1.TRG -t1.frm -Table Create Table -t1 CREATE TABLE `t1` ( - `old` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -a INSERT t1 set @s= 1 BEFORE -# CRASH POINT: ddl_log_create_after_drop -# No crash! -t1.DATA1 -t1.DATA2 -t1.frm -master-bin.000001 # Query # # use `test`; CREATE OR REPLACE TABLE t1 LIKE const_table -Table Create Table -t1 CREATE TABLE `t1` ( - `new` int(11) DEFAULT NULL, - `b` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -# CRASH POINT: ddl_log_create_after_send_data -# No crash! -t1.DATA1 -t1.DATA2 -t1.frm -master-bin.000001 # Query # # use `test`; CREATE OR REPLACE TABLE t1 LIKE const_table -Table Create Table -t1 CREATE TABLE `t1` ( - `new` int(11) DEFAULT NULL, - `b` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -# CRASH POINT: ddl_log_create_after_save_backup -t1.DATA1 -t1.DATA2 -t1.TRG -t1.frm -Table Create Table -t1 CREATE TABLE `t1` ( - `old` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -a INSERT t1 set @s= 1 BEFORE -# CRASH POINT: ddl_log_create_after_install_new -t1.DATA1 -t1.DATA2 -t1.TRG -t1.frm -Table Create Table -t1 CREATE TABLE `t1` ( - `old` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -a INSERT t1 set @s= 1 BEFORE -# CRASH POINT: ddl_log_create_before_binlog -t1.DATA1 -t1.DATA2 -t1.TRG -t1.frm -Table Create Table -t1 CREATE TABLE `t1` ( - `old` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -a INSERT t1 set @s= 1 BEFORE -# CRASH POINT: ddl_log_create_after_prepare_eof -# No crash! -t1.DATA1 -t1.DATA2 -t1.frm -master-bin.000001 # Query # # use `test`; CREATE OR REPLACE TABLE t1 LIKE const_table -Table Create Table -t1 CREATE TABLE `t1` ( - `new` int(11) DEFAULT NULL, - `b` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -# CRASH POINT: ddl_log_create_after_binlog -t1.DATA1 -t1.DATA2 -t1.frm -master-bin.000001 # Query # # use `test`; CREATE OR REPLACE TABLE t1 LIKE const_table -Table Create Table -t1 CREATE TABLE `t1` ( - `new` int(11) DEFAULT NULL, - `b` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -# CRASH POINT: ddl_log_create_fk_fail -t1.TRG -t1.frm -t1.ibd -t2.frm -t2.ibd -Table Create Table -t1 CREATE TABLE `t1` ( - `old` int(11) NOT NULL, - `y` int(11) DEFAULT NULL, - PRIMARY KEY (`old`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -a INSERT t1 set @s= 1 BEFORE -# CRASH POINT: ddl_log_create_fk_fail2 -t1.TRG -t1.frm -t1.ibd -t2.frm -t2.ibd -Table Create Table -t1 CREATE TABLE `t1` ( - `old` int(11) NOT NULL, - `y` int(11) DEFAULT NULL, - PRIMARY KEY (`old`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -a INSERT t1 set @s= 1 BEFORE -# CRASH POINT: ddl_log_create_fk_fail3 -t1.TRG -t1.frm -t1.ibd -t2.frm -t2.ibd -Table Create Table -t1 CREATE TABLE `t1` ( - `old` int(11) NOT NULL, - `y` int(11) DEFAULT NULL, - PRIMARY KEY (`old`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -a INSERT t1 set @s= 1 BEFORE -# CRASH POINT: ddl_log_create_log_complete -t1.DATA1 -t1.DATA2 -t1.frm -master-bin.000001 # Query # # use `test`; CREATE OR REPLACE TABLE t1 LIKE const_table -Table Create Table -t1 CREATE TABLE `t1` ( - `new` int(11) DEFAULT NULL, - `b` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -# CRASH POINT: ddl_log_create_log_complete2 -t1.DATA1 -t1.DATA2 -t1.frm -master-bin.000001 # Query # # use `test`; CREATE OR REPLACE TABLE t1 LIKE const_table -Table Create Table -t1 CREATE TABLE `t1` ( - `new` int(11) DEFAULT NULL, - `b` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -# CRASH POINT: ddl_log_create_log_complete3 -t1.DATA1 -t1.DATA2 -t1.frm -master-bin.000001 # Query # # use `test`; CREATE OR REPLACE TABLE t1 LIKE const_table -Table Create Table -t1 CREATE TABLE `t1` ( - `new` int(11) DEFAULT NULL, - `b` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -# QUERY: CREATE OR REPLACE TABLE t1 SELECT * from const_table -# CRASH POINT: ddl_log_create_before_install_new -t1.DATA1 -t1.DATA2 -t1.TRG -t1.frm -Table Create Table -t1 CREATE TABLE `t1` ( - `old` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -old -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -a INSERT t1 set @s= 1 BEFORE -# CRASH POINT: ddl_log_create_after_log_drop_backup -t1.DATA1 -t1.DATA2 -t1.TRG -t1.frm -Table Create Table -t1 CREATE TABLE `t1` ( - `old` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -old -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -a INSERT t1 set @s= 1 BEFORE -# CRASH POINT: ddl_log_create_after_log_rename_backup -t1.DATA1 -t1.DATA2 -t1.TRG -t1.frm -Table Create Table -t1 CREATE TABLE `t1` ( - `old` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -old -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -a INSERT t1 set @s= 1 BEFORE -# CRASH POINT: ddl_log_create_before_create_frm -t1.DATA1 -t1.DATA2 -t1.TRG -t1.frm -Table Create Table -t1 CREATE TABLE `t1` ( - `old` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -old -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -a INSERT t1 set @s= 1 BEFORE -# CRASH POINT: ddl_log_create_before_create_table -t1.DATA1 -t1.DATA2 -t1.TRG -t1.frm -Table Create Table -t1 CREATE TABLE `t1` ( - `old` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -old -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -a INSERT t1 set @s= 1 BEFORE -# CRASH POINT: ddl_log_create_after_create_table -t1.DATA1 -t1.DATA2 -t1.TRG -t1.frm -Table Create Table -t1 CREATE TABLE `t1` ( - `old` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -old -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -a INSERT t1 set @s= 1 BEFORE -# CRASH POINT: ddl_log_create_after_drop -# No crash! -t1.DATA1 -t1.DATA2 -t1.frm -master-bin.000001 # Query # # use `test`; CREATE OR REPLACE TABLE t1 SELECT * from const_table -Table Create Table -t1 CREATE TABLE `t1` ( - `new` int(11) DEFAULT NULL, - `b` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -new b -1 1 -2 2 -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -# CRASH POINT: ddl_log_create_after_send_data -t1.DATA1 -t1.DATA2 -t1.TRG -t1.frm -Table Create Table -t1 CREATE TABLE `t1` ( - `old` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -old -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -a INSERT t1 set @s= 1 BEFORE -# CRASH POINT: ddl_log_create_after_save_backup -t1.DATA1 -t1.DATA2 -t1.TRG -t1.frm -Table Create Table -t1 CREATE TABLE `t1` ( - `old` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -old -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -a INSERT t1 set @s= 1 BEFORE -# CRASH POINT: ddl_log_create_after_install_new -t1.DATA1 -t1.DATA2 -t1.TRG -t1.frm -Table Create Table -t1 CREATE TABLE `t1` ( - `old` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -old -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -a INSERT t1 set @s= 1 BEFORE -# CRASH POINT: ddl_log_create_before_binlog -t1.DATA1 -t1.DATA2 -t1.TRG -t1.frm -Table Create Table -t1 CREATE TABLE `t1` ( - `old` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -old -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -a INSERT t1 set @s= 1 BEFORE -# CRASH POINT: ddl_log_create_after_prepare_eof -t1.DATA1 -t1.DATA2 -t1.TRG -t1.frm -Table Create Table -t1 CREATE TABLE `t1` ( - `old` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -old -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -a INSERT t1 set @s= 1 BEFORE -# CRASH POINT: ddl_log_create_after_binlog -t1.DATA1 -t1.DATA2 -t1.frm -master-bin.000001 # Query # # use `test`; CREATE OR REPLACE TABLE t1 SELECT * from const_table -Table Create Table -t1 CREATE TABLE `t1` ( - `new` int(11) DEFAULT NULL, - `b` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -new b -1 1 -2 2 -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -# CRASH POINT: ddl_log_create_fk_fail -t1.TRG -t1.frm -t1.ibd -t2.frm -t2.ibd -Table Create Table -t1 CREATE TABLE `t1` ( - `old` int(11) NOT NULL, - `y` int(11) DEFAULT NULL, - PRIMARY KEY (`old`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -old y -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -a INSERT t1 set @s= 1 BEFORE -# CRASH POINT: ddl_log_create_fk_fail2 -t1.TRG -t1.frm -t1.ibd -t2.frm -t2.ibd -Table Create Table -t1 CREATE TABLE `t1` ( - `old` int(11) NOT NULL, - `y` int(11) DEFAULT NULL, - PRIMARY KEY (`old`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -old y -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -a INSERT t1 set @s= 1 BEFORE -# CRASH POINT: ddl_log_create_fk_fail3 -t1.TRG -t1.frm -t1.ibd -t2.frm -t2.ibd -Table Create Table -t1 CREATE TABLE `t1` ( - `old` int(11) NOT NULL, - `y` int(11) DEFAULT NULL, - PRIMARY KEY (`old`) -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -old y -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -a INSERT t1 set @s= 1 BEFORE -# CRASH POINT: ddl_log_create_log_complete -t1.DATA1 -t1.DATA2 -t1.frm -master-bin.000001 # Query # # use `test`; CREATE OR REPLACE TABLE t1 SELECT * from const_table -Table Create Table -t1 CREATE TABLE `t1` ( - `new` int(11) DEFAULT NULL, - `b` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -new b -1 1 -2 2 -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -# CRASH POINT: ddl_log_create_log_complete2 -t1.DATA1 -t1.DATA2 -t1.frm -master-bin.000001 # Query # # use `test`; CREATE OR REPLACE TABLE t1 SELECT * from const_table -Table Create Table -t1 CREATE TABLE `t1` ( - `new` int(11) DEFAULT NULL, - `b` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -new b -1 1 -2 2 -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -# CRASH POINT: ddl_log_create_log_complete3 -t1.DATA1 -t1.DATA2 -t1.frm -master-bin.000001 # Query # # use `test`; CREATE OR REPLACE TABLE t1 SELECT * from const_table -Table Create Table -t1 CREATE TABLE `t1` ( - `new` int(11) DEFAULT NULL, - `b` int(11) DEFAULT NULL -) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci -new b -1 1 -2 2 -Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation -Warnings: -Note 1051 Unknown table 'test.t1' |