|
1143.2.20
by Jay Pipes
* Fixes bug in replication where inserts, updates, and |
1 |
#
|
2 |
# Simple test of the behaviour of the transaction log |
|
3 |
# when temporary tables are involved in certain events. |
|
4 |
#
|
|
5 |
||
6 |
--disable_warnings |
|
7 |
DROP TABLE IF EXISTS t1, t2; |
|
8 |
--enable_warnings |
|
9 |
||
10 |
CREATE TEMPORARY TABLE t1 ( |
|
11 |
id INT NOT NULL |
|
12 |
, padding VARCHAR(200) NOT NULL |
|
13 |
);
|
|
14 |
||
15 |
INSERT INTO t1 VALUES (1, "I love testing."); |
|
16 |
INSERT INTO t1 VALUES (2, "I hate testing."); |
|
17 |
||
18 |
CREATE TABLE t2 LIKE t1; |
|
19 |
||
20 |
INSERT INTO t2 SELECT * FROM t1; |
|
21 |
||
22 |
DROP TABLE t1; |
|
23 |
DROP TABLE t2; |