2
# Simple test of the behaviour of the transaction log
3
# when temporary tables are involved in certain events.
7
DROP TABLE IF EXISTS t1, t2;
10
CREATE TEMPORARY TABLE t1 (
12
, padding VARCHAR(200) NOT NULL
15
INSERT INTO t1 VALUES (1, "I love testing.");
16
INSERT INTO t1 VALUES (2, "I hate testing.");
18
CREATE TABLE t2 LIKE t1;
20
INSERT INTO t2 SELECT * FROM t1;