diff options
Diffstat (limited to 'mysql-test/suite/rpl/t/rpl_temp_table_mix_row.test')
-rw-r--r-- | mysql-test/suite/rpl/t/rpl_temp_table_mix_row.test | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/suite/rpl/t/rpl_temp_table_mix_row.test b/mysql-test/suite/rpl/t/rpl_temp_table_mix_row.test index 63f0b6c2234..4b94dae3de9 100644 --- a/mysql-test/suite/rpl/t/rpl_temp_table_mix_row.test +++ b/mysql-test/suite/rpl/t/rpl_temp_table_mix_row.test @@ -97,7 +97,7 @@ sync_slave_with_master; -- connection master # action: setup environment -CREATE TABLE t1 (a int); +CREATE TABLE t1 (a int) engine=innodb; CREATE TABLE t2 ( i1 INT NOT NULL AUTO_INCREMENT, PRIMARY KEY (i1) ); CREATE TABLE t3 ( i1 INT NOT NULL AUTO_INCREMENT, PRIMARY KEY (i1) ); CREATE TRIGGER tr1 AFTER DELETE ON t2 FOR EACH ROW INSERT INTO t3 () VALUES (); @@ -193,7 +193,7 @@ DROP TEMPORARY TABLE t1; --echo # The rows event will binlogged before 'DROP TEMPORARY TABLE t1', --echo # as t1 is non-transactional table -INSERT INTO t1 VALUES(Rand()); +INSERT INTO t1 SELECT Rand(); COMMIT; source include/show_binlog_events.inc; |