Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) Engine=InnoDB;
4 INSERT INTO t1 VALUES (1);
5 connection node_2;
6 TRUNCATE TABLE t1;
7 SELECT COUNT(*) = 0 FROM t1;
8 COUNT(*) = 0
9 1
10 connection node_1;
11 SELECT COUNT(*) = 0 FROM t1;
12 COUNT(*) = 0
13 1
14 connection node_2;
15 CREATE TABLE t2 (f1 VARCHAR(255)) Engine=InnoDB;
16 INSERT INTO t2 VALUES ('abc');
17 connection node_1;
18 TRUNCATE TABLE t2;
19 connection node_2;
20 SELECT COUNT(*) = 0 FROM t2;
21 COUNT(*) = 0
22 1
23 connection node_1;
24 CREATE TABLE t3 (f1 INTEGER AUTO_INCREMENT PRIMARY KEY) Engine=InnoDB;
25 INSERT INTO t3 VALUES (DEFAULT),(DEFAULT),(DEFAULT),(DEFAULT),(DEFAULT);
26 CREATE TABLE t4 (f1 INTEGER AUTO_INCREMENT PRIMARY KEY) Engine=InnoDB AUTO_INCREMENT=1234;
27 INSERT INTO t4 VALUES (DEFAULT),(DEFAULT),(DEFAULT),(DEFAULT),(DEFAULT);
28 TRUNCATE TABLE t3;
29 TRUNCATE TABLE t4;
30 connection node_2;
31 SELECT AUTO_INCREMENT = 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME IN ('t3', 't4');
32 AUTO_INCREMENT = 1
33 1
34 1
35 connection node_1;
36 TRUNCATE TABLE mysql.user;
37 ERROR 42S02: Table 'mysql.user' doesn't exist
38 TRUNCATE TABLE performance_schema.threads;
39 ERROR HY000: Invalid performance_schema usage
40 TRUNCATE TABLE information_schema.tables;
41 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
42 TRUNCATE TABLE mysql.innodb_index_stats;
43 TRUNCATE TABLE foo.bar;
44 ERROR 42S02: Table 'foo.bar' doesn't exist
45 TRUNCATE TABLE t1;
46 DROP TABLE t1;
47 DROP TABLE t2;
48 DROP TABLE t3;
49 DROP TABLE t4;