Debian Codegraph @

mysql-test/suite/galera/r/galera_truncate_temporary.result

raw
1 connection node_2;
2 connection node_1;
3 CREATE TEMPORARY TABLE t1 (f1 INTEGER PRIMARY KEY) Engine=InnoDB;
4 INSERT INTO t1 VALUES (1);
5 TRUNCATE TABLE t1;
6 SELECT COUNT(*) = 0 FROM t1;
7 COUNT(*) = 0
8 1
9 connection node_2;
10 SELECT * FROM t1;
11 ERROR 42S02: Table 'test.t1' doesn't exist
12 connection node_1;
13 DROP TABLE t1;
14 CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
15 INSERT INTO t1 VALUES (1);
16 CREATE TEMPORARY TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
17 INSERT INTO t1 VALUES (2);
18 SELECT f1 = 2 FROM t1;
19 f1 = 2
20 1
21 SELECT COUNT(*) = 1 FROM t1;
22 COUNT(*) = 1
23 1
24 TRUNCATE TABLE t1;
25 SELECT COUNT(*) = 0 FROM t1;
26 COUNT(*) = 0
27 1
28 connection node_2;
29 SELECT COUNT(*) = 1 FROM t1;
30 COUNT(*) = 1
31 1
32 SELECT f1 = 1 FROM t1;
33 f1 = 1
34 1
35 connection node_1;
36 DROP TABLE t1;
37 SELECT COUNT(*) = 1 FROM t1;
38 COUNT(*) = 1
39 1
40 SELECT f1 = 1 FROM t1;
41 f1 = 1
42 1
43 TRUNCATE TABLE t1;
44 SELECT COUNT(*) = 0 FROM t1;
45 COUNT(*) = 0
46 1
47 connection node_2;
48 SELECT COUNT(*) = 0 FROM t1;
49 COUNT(*) = 0
50 1
51 connection node_1;
52 DROP TABLE t1;
53 connection node_1;
54 CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
55 INSERT INTO t1 VALUES (1);
56 CREATE TEMPORARY TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
57 INSERT INTO t1 VALUES (2);
58 connection node_2;
59 TRUNCATE TABLE t1;
60 SELECT COUNT(*) = 0 FROM t1;
61 COUNT(*) = 0
62 1
63 connection node_1;
64 SELECT f1 = 2 FROM t1;
65 f1 = 2
66 1
67 SELECT COUNT(*) = 1 FROM t1;
68 COUNT(*) = 1
69 1
70 DROP TABLE t1;
71 SELECT COUNT(*) = 0 FROM t1;
72 COUNT(*) = 0
73 1
74 DROP TABLE t1;