Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 #
4 # MDEV-6924 : Server crashed on CREATE TABLE ... SELECT
5 #
6 SET @wsrep_forced_binlog_format_saved=@@GLOBAL.wsrep_forced_binlog_format;
7 SET @@GLOBAL.wsrep_forced_binlog_format=STATEMENT;
8 SHOW VARIABLES LIKE '%log%bin%';
9 Variable_name Value
10 log_bin OFF
11 log_bin_basename
12 log_bin_compress OFF
13 log_bin_compress_min_len 256
14 log_bin_index
15 log_bin_trust_function_creators ON
16 sql_log_bin ON
17 USE test;
18 CREATE TABLE t1(i INT) ENGINE=INNODB;
19 INSERT INTO t1 VALUES(1);
20 CREATE TEMPORARY TABLE `t1_temp` AS SELECT * FROM `t1` WHERE i = 1;
21 Warnings:
22 Warning 1105 Galera does not support wsrep_forced_binlog_format = STMT in CREATE TABLE AS SELECT
23 SELECT * FROM t1;
24 i
25 1
26 SELECT * FROM t1_temp;
27 i
28 1
29 DROP TABLE t1;
30 SET @@GLOBAL.wsrep_forced_binlog_format=@wsrep_forced_binlog_format_saved;
31 #
32 # MDEV-7673: CREATE TABLE SELECT fails on Galera cluster
33 #
34 connection node_1;
35 CREATE TABLE t1 (i INT) ENGINE=INNODB DEFAULT CHARSET=utf8 SELECT 1 as i;
36 SELECT * FROM t1;
37 i
38 1
39 connection node_2;
40 SELECT * FROM t1;
41 i
42 1
43 DROP TABLE t1;
44 #
45 # MDEV-8166 : Adding index on new table from select crashes Galera
46 # cluster
47 #
48 connection node_1;
49 CREATE TABLE t1(i int(11) NOT NULL DEFAULT '0') ENGINE=InnoDB DEFAULT CHARSET=utf8;
50 INSERT INTO t1(i) VALUES (1), (2), (3);
51 CREATE TABLE t2 (i INT) SELECT i FROM t1;
52 ALTER TABLE t2 ADD INDEX idx(i);
53 SELECT * FROM t2;
54 i
55 1
56 2
57 3
58 connection node_2;
59 SELECT * FROM t2;
60 i
61 1
62 2
63 3
64 SHOW CREATE TABLE t2;
65 Table Create Table
66 t2 CREATE TABLE `t2` (
67 `i` int(11) DEFAULT NULL,
68 KEY `idx` (`i`)
69 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
70 DROP TABLE t1, t2;
71 #
72 # MDEV-9853: WSREP says it cannot get fake InnoDB transaction ID
73 # followed by segmentation fault
74 #
75 CREATE TABLE `t1`(`c1` INT) ENGINE=INNODB;
76 SET autocommit=0;
77 CREATE TABLE `t2` (`c1` INT) ENGINE=INNODB SELECT * FROM t1;
78 COMMIT;
79 SET autocommit=1;
80 DROP TABLE t1, t2;
81 #
82 # MDEV-10235: Deadlock in CREATE TABLE ... AS SELECT .. if result set
83 # is empty in Galera
84 #
85 connection node_1;
86 CREATE TABLE t1(c1 INT) ENGINE=INNODB;
87 INSERT INTO t1 VALUES(1);
88 CREATE TABLE t2 AS SELECT * FROM t1 WHERE c1=2;
89 connection node_2;
90 SELECT * FROM t1;
91 c1
92 1
93 SELECT * FROM t2;
94 c1
95 DROP TABLE t1, t2;
96 disconnect node_2;
97 disconnect node_1;
98 # End of tests