Debian Codegraph @

mysql-test/suite/binlog_nogtid/r/binlog_gtid_next_single_stmt_trx_rollback.result

raw
1 call mtr.add_suppression("Did not write failed 'GRANT ALL ON *.* TO user2' into binary log while granting/revoking privileges in databases.");
2 call mtr.add_suppression("Did not write failed 'REVOKE ALL PRIVILEGES ON *.* FROM user2' into binary log while granting/revoking privileges in databases.");
3 RESET MASTER;
4 SET GLOBAL GTID_MODE=OFF_PERMISSIVE;
5 CREATE TABLE t1(c1 INT PRIMARY KEY) ENGINE=InnoDB;
6 CREATE TABLE t1_c like t1;
7 CREATE INDEX t_index ON t1(c1);
8 CREATE TEMPORARY TABLE temp1(c1 INT) ENGINE=InnoDB;
9 ALTER TABLE temp1 ADD COLUMN other_column INT;
10 CREATE VIEW v1 as SELECT 1;
11 CREATE USER user1;
12 CREATE DATABASE db1;
13 INSERT INTO t1 VALUES (3), (4);
14 INSERT INTO t1_c VALUES (1), (2), (3);
15 SET SESSION GTID_NEXT='MASTER_UUID:1';
16 CREATE TABLE t1(c1 INT, c2 INT);
17 ERROR 42S01: Table 't1' already exists
18 include/assert.inc [rollback gtid MASTER_UUID:1]
19 SET SESSION GTID_NEXT='MASTER_UUID:2';
20 ALTER TABLE t2 ADD COLUMN other_column INT;
21 ERROR 42S02: Table 'test.t2' doesn't exist
22 include/assert.inc [rollback gtid MASTER_UUID:2]
23 SET SESSION GTID_NEXT='MASTER_UUID:3';
24 DROP TABLE t2;
25 ERROR 42S02: Unknown table 'test.t2'
26 include/assert.inc [rollback gtid MASTER_UUID:3]
27 SET SESSION GTID_NEXT='MASTER_UUID:4';
28 CREATE INDEX t_index ON t1(c1);
29 ERROR 42000: Duplicate key name 't_index'
30 include/assert.inc [rollback gtid MASTER_UUID:4]
31 SET SESSION GTID_NEXT='MASTER_UUID:5';
32 DROP INDEX t_index2 ON t1;
33 ERROR 42000: Can't DROP 't_index2'; check that column/key exists
34 include/assert.inc [rollback gtid MASTER_UUID:5]
35 SET SESSION GTID_NEXT='MASTER_UUID:6';
36 RENAME TABLE t3 TO t4;
37 ERROR 42S02: Table 'test.t3' doesn't exist
38 include/assert.inc [rollback gtid MASTER_UUID:6]
39 SET SESSION GTID_NEXT='MASTER_UUID:7';
40 CREATE TEMPORARY TABLE temp1(c1 INT);
41 ERROR 42S01: Table 'temp1' already exists
42 include/assert.inc [rollback gtid MASTER_UUID:7]
43 SET SESSION GTID_NEXT='MASTER_UUID:8';
44 ALTER TABLE temp1 ADD COLUMN other_column INT;
45 ERROR 42S21: Duplicate column name 'other_column'
46 include/assert.inc [rollback gtid MASTER_UUID:8]
47 SET SESSION GTID_NEXT='MASTER_UUID:9';
48 DROP TEMPORARY TABLE temp2;
49 ERROR 42S02: Unknown table 'test.temp2'
50 include/assert.inc [rollback gtid MASTER_UUID:9]
51 SET SESSION GTID_NEXT='MASTER_UUID:10';
52 CREATE DATABASE db1;
53 ERROR HY000: Can't create database 'db1'; database exists
54 include/assert.inc [rollback gtid MASTER_UUID:10]
55 SET SESSION GTID_NEXT='MASTER_UUID:12';
56 DROP DATABASE db2;
57 ERROR HY000: Can't drop database 'db2'; database doesn't exist
58 include/assert.inc [rollback gtid MASTER_UUID:12]
59 SET SESSION GTID_NEXT='MASTER_UUID:18';
60 DROP VIEW v2;
61 ERROR 42S02: Unknown table 'test.v2'
62 include/assert.inc [rollback gtid MASTER_UUID:18]
63 SET SESSION GTID_NEXT='MASTER_UUID:19';
64 CREATE VIEW v1 as SELECT 1;
65 ERROR 42S01: Table 'v1' already exists
66 include/assert.inc [rollback gtid MASTER_UUID:19]
67 SET SESSION GTID_NEXT='MASTER_UUID:20';
68 INSERT INTO t1 VALUES (3), (2);
69 ERROR 23000: Duplicate entry '3' for key 't1.PRIMARY'
70 include/assert.inc [rollback gtid MASTER_UUID:20]
71 SET SESSION GTID_NEXT='MASTER_UUID:21';
72 INSERT INTO t1 SELECT * FROM t1;
73 ERROR 23000: Duplicate entry '3' for key 't1.PRIMARY'
74 include/assert.inc [rollback gtid MASTER_UUID:21]
75 SET SESSION GTID_NEXT='MASTER_UUID:22';
76 INSERT INTO t1 VALUES (2), (3);
77 ERROR 23000: Duplicate entry '3' for key 't1.PRIMARY'
78 include/assert.inc [rollback gtid MASTER_UUID:22]
79 SET SESSION GTID_NEXT='MASTER_UUID:23';
80 INSERT INTO t1 SELECT * FROM t1_c;
81 ERROR 23000: Duplicate entry '3' for key 't1.PRIMARY'
82 include/assert.inc [rollback gtid MASTER_UUID:23]
83 SET SESSION GTID_NEXT='MASTER_UUID:24';
84 UPDATE t1 SET c1=3 WHERE c1=4;
85 ERROR 23000: Duplicate entry '3' for key 't1.PRIMARY'
86 include/assert.inc [rollback gtid MASTER_UUID:24]
87 SET SESSION GTID_NEXT='MASTER_UUID:25';
88 UPDATE t1_c, t1 SET t1_c.c1=6, t1.c1=3 WHERE t1_c.c1=1 AND t1.c1=4;
89 ERROR 23000: Duplicate entry '3' for key 't1.PRIMARY'
90 include/assert.inc [rollback gtid MASTER_UUID:25]
91 SET SESSION GTID_NEXT='MASTER_UUID:26';
92 UPDATE t1, t1_c SET t1.c1=3, t1_c.c1=6 WHERE t1.c1=4 OR t1_c.c1=1;
93 ERROR 23000: Duplicate entry '3' for key 't1.PRIMARY'
94 include/assert.inc [rollback gtid MASTER_UUID:26]
95 SET GTID_NEXT = 'AUTOMATIC';
96 DROP INDEX t_index ON t1;
97 DROP TABLE t1, t1_c;
98 DROP TEMPORARY TABLE temp1;
99 DROP VIEW v1;
100 DROP USER user1;
101 SET GLOBAL GTID_MODE=OFF;
102 DROP DATABASE db1;