Debian Codegraph @

mysql-test/suite/galera/t/galera_truncate_temporary.test

raw
1 #
2 # Test TRUNCATE on TEMPORARY tables. It should not be replicated
3 #
4
5 --source include/galera_cluster.inc
6 --source include/have_innodb.inc
7
8 CREATE TEMPORARY TABLE t1 (f1 INTEGER PRIMARY KEY) Engine=InnoDB;
9
10 INSERT INTO t1 VALUES (1);
11
12 TRUNCATE TABLE t1;
13 SELECT COUNT(*) = 0 FROM t1;
14
15 --connection node_2
16 --error ER_NO_SUCH_TABLE
17 SELECT * FROM t1;
18
19 --connection node_1
20 DROP TABLE t1;
21
22 #
23 # Test the case where a TEMPORARY table is masking an existing one
24 #
25
26 CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
27 INSERT INTO t1 VALUES (1);
28
29 CREATE TEMPORARY TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
30 INSERT INTO t1 VALUES (2);
31
32 SELECT f1 = 2 FROM t1;
33 SELECT COUNT(*) = 1 FROM t1;
34
35 TRUNCATE TABLE t1;
36
37 SELECT COUNT(*) = 0 FROM t1;
38
39 --connection node_2
40 SELECT COUNT(*) = 1 FROM t1;
41 SELECT f1 = 1 FROM t1;
42
43 --connection node_1
44
45 DROP TABLE t1;
46 SELECT COUNT(*) = 1 FROM t1;
47 SELECT f1 = 1 FROM t1;
48
49 TRUNCATE TABLE t1;
50 SELECT COUNT(*) = 0 FROM t1;
51
52 --connection node_2
53 SELECT COUNT(*) = 0 FROM t1;
54
55 --connection node_1
56 DROP TABLE t1;
57
58 #
59 # Test the case where one node has a TEMPORARY table but the TRUNCATE arrives from another node
60 #
61
62 --connection node_1
63 CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
64 INSERT INTO t1 VALUES (1);
65
66 CREATE TEMPORARY TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
67 INSERT INTO t1 VALUES (2);
68
69 --connection node_2
70 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE 'test/t1';
71 --source include/wait_condition.inc
72
73 TRUNCATE TABLE t1;
74
75 SELECT COUNT(*) = 0 FROM t1;
76
77 --connection node_1
78 SELECT f1 = 2 FROM t1;
79 SELECT COUNT(*) = 1 FROM t1;
80
81 DROP TABLE t1;
82
83 SELECT COUNT(*) = 0 FROM t1;
84
85 DROP TABLE t1;