1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
|
connection node_2;
connection node_1;
connection node_1;
SET SESSION default_storage_engine=InnoDB;
CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
CREATE TABLE t2 (f1 INTEGER) ENGINE=InnoDB;
CREATE TABLE t1 AS SELECT * FROM t2;
ERROR 42S01: Table 't1' already exists
DROP TABLE t1,t2;
CREATE TABLE t1 AS SELECT * FROM t2;
ERROR 42S02: Table 'test.t2' doesn't exist
CREATE TABLE t1 AS SELECT 1 FROM DUAL;
connection node_2;
SELECT COUNT(*) = 1 FROM t1;
COUNT(*) = 1
1
connection node_1;
DROP TABLE t1;
connection node_1;
CREATE TABLE t2 (f1 INTEGER) ENGINE=InnoDB;
CREATE TABLE t1 AS SELECT * FROM t2;
connection node_2;
SELECT COUNT(*) = 0 FROM t1;
COUNT(*) = 0
1
connection node_1;
DROP TABLE t1,t2;
CREATE TABLE t2 (f1 INTEGER) ENGINE=MyISAM;
INSERT INTO t2 VALUES (1),(2),(3),(4),(5);
CREATE TABLE t1 AS SELECT * FROM t2;
SELECT COUNT(*) = 5 FROM t1;
COUNT(*) = 5
1
connection node_2;
SELECT COUNT(*) = 5 FROM t1;
COUNT(*) = 5
1
connection node_1;
DROP TABLE t1,t2;
connection node_1;
CREATE TABLE t2 (f1 INTEGER) ENGINE=InnoDB;
INSERT INTO t2 VALUES (1),(2),(3),(4),(5);
CREATE TABLE t1 AS SELECT MAX(f1) AS f1 FROM t2;
connection node_2;
SELECT COUNT(*) = 1 FROM t1;
COUNT(*) = 1
1
SELECT f1 = 5 FROM t1;
f1 = 5
1
connection node_1;
DROP TABLE t1,t2;
connection node_1;
CREATE PROCEDURE sp1 ()
BEGIN
CREATE TABLE t2 (f1 INTEGER) ENGINE=InnoDB;
INSERT INTO t2 VALUES (1),(2),(3),(4),(5);
CREATE TABLE t1 AS SELECT * FROM t2;
END|
CALL sp1();
SELECT COUNT(*) = 5 FROM t1;
COUNT(*) = 5
1
connection node_2;
SELECT COUNT(*) = 5 FROM t1;
COUNT(*) = 5
1
connection node_1;
DROP TABLE t1, t2;
DROP PROCEDURE sp1;
connection node_1;
CREATE TABLE t2 (f1 INTEGER) ENGINE=InnoDB;
INSERT INTO t2 VALUES (1),(2),(3),(4),(5);
PREPARE stmt FROM 'CREATE TABLE t1 AS SELECT * FROM t2';
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
DROP TABLE t1, t2;
connection node_1;
CREATE TABLE t2 (f1 INTEGER) ENGINE=InnoDB;
INSERT INTO t2 VALUES (1),(2),(3),(4),(5);
connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1;
LOCK TABLE t2 WRITE;
connection node_1;
CREATE TABLE t1 AS SELECT * FROM t2;;
connection node_2;
SELECT COUNT(*) = 5 FROM t2;
COUNT(*) = 5
1
CREATE TABLE t1 AS SELECT * FROM t2;
connection node_1a;
UNLOCK TABLES;
connection node_1;
Got one of the listed errors
DROP TABLE t1, t2;
CREATE TABLE t2 (f1 INTEGER) ENGINE=InnoDB;
INSERT INTO t2 VALUES (1),(2),(3),(4),(5);
CREATE TEMPORARY TABLE t1 AS SELECT * FROM t2;
connection node_2;
SELECT * FROM t1;
ERROR 42S02: Table 'test.t1' doesn't exist
CALL mtr.add_suppression("Slave SQL: Error 'Unknown table 'test.t1'' on query");
connection node_1;
DROP TABLE t1, t2;
|
