Debian Codegraph @

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

raw
1 #
2 # A simple test for PREPARE / EXECUTE -style prepared statements with Galera
3 #
4 # C-API-level prepared-statements can not be triggered from inside mysqltest, however
5 # can be exercised when running an MTR test suite with the --ps-protocol switch.
6 #
7
8 --source include/galera_cluster.inc
9 --source include/have_innodb.inc
10
11 CREATE TABLE t1 (f1 CHAR(5)) ENGINE=InnoDB;
12 CREATE TABLE t2 (f1 CHAR(5)) ENGINE=InnoDB;
13 CREATE TABLE t3 (f1 CHAR(5)) ENGINE=InnoDB;
14 CREATE TABLE t4 (f1 CHAR(5)) ENGINE=InnoDB;
15
16 SET SESSION sql_mode='STRICT_ALL_TABLES';
17
18 PREPARE st1 FROM 'INSERT INTO t1 VALUES ("abc")';
19 PREPARE st2 FROM 'INSERT INTO t2 VALUES ("abc")';
20 PREPARE st3 FROM 'INSERT INTO t3 VALUES ("abc")';
21 PREPARE st4 FROM 'INSERT INTO t4 VALUES ("abc")';
22
23 EXECUTE st1;
24 EXECUTE st2;
25 EXECUTE st3;
26 EXECUTE st4;
27
28 --connection node_2
29 SELECT COUNT(*) = 1 FROM t1;
30 SELECT COUNT(*) = 1 FROM t2;
31 SELECT COUNT(*) = 1 FROM t3;
32 SELECT COUNT(*) = 1 FROM t4;
33
34 ALTER TABLE t1 ADD COLUMN f2 INTEGER;
35 ALTER TABLE t1 DROP COLUMN f1;
36
37 --connection node_1
38 --error ER_TRUNCATED_WRONG_VALUE_FOR_FIELD
39 EXECUTE st1;
40
41 --connection node_1
42 DROP TABLE t1;
43 DROP TABLE t2;
44 DROP TABLE t3;
45 DROP TABLE t4;