00001 # 00002 # Simple test of the behaviour of the transaction log 00003 # when temporary tables are involved in certain events. 00004 # 00005 00006 --disable_warnings 00007 DROP TABLE IF EXISTS t1, t2; 00008 --enable_warnings 00009 00010 CREATE TEMPORARY TABLE t1 ( 00011 id INT NOT NULL PRIMARY KEY 00012 , padding VARCHAR(200) NOT NULL 00013 ); 00014 00015 INSERT INTO t1 VALUES (1, "I love testing."); 00016 INSERT INTO t1 VALUES (2, "I hate testing."); 00017 00018 CREATE TABLE t2 LIKE t1; 00019 00020 INSERT INTO t2 SELECT * FROM t1; 00021 00022 DROP TABLE t1; 00023 DROP TABLE t2;