Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 CREATE TABLE t1 (f1 CHAR(5)) ENGINE=InnoDB;
4 CREATE TABLE t2 (f1 CHAR(5)) ENGINE=InnoDB;
5 CREATE TABLE t3 (f1 CHAR(5)) ENGINE=InnoDB;
6 CREATE TABLE t4 (f1 CHAR(5)) ENGINE=InnoDB;
7 SET SESSION sql_mode='STRICT_ALL_TABLES';
8 PREPARE st1 FROM 'INSERT INTO t1 VALUES ("abc")';
9 PREPARE st2 FROM 'INSERT INTO t2 VALUES ("abc")';
10 PREPARE st3 FROM 'INSERT INTO t3 VALUES ("abc")';
11 PREPARE st4 FROM 'INSERT INTO t4 VALUES ("abc")';
12 EXECUTE st1;
13 EXECUTE st2;
14 EXECUTE st3;
15 EXECUTE st4;
16 connection node_2;
17 SELECT COUNT(*) = 1 FROM t1;
18 COUNT(*) = 1
19 1
20 SELECT COUNT(*) = 1 FROM t2;
21 COUNT(*) = 1
22 1
23 SELECT COUNT(*) = 1 FROM t3;
24 COUNT(*) = 1
25 1
26 SELECT COUNT(*) = 1 FROM t4;
27 COUNT(*) = 1
28 1
29 ALTER TABLE t1 ADD COLUMN f2 INTEGER;
30 ALTER TABLE t1 DROP COLUMN f1;
31 connection node_1;
32 EXECUTE st1;
33 ERROR 22007: Incorrect integer value: 'abc' for column `test`.`t1`.`f2` at row 1
34 connection node_1;
35 DROP TABLE t1;
36 DROP TABLE t2;
37 DROP TABLE t3;
38 DROP TABLE t4;