Debian Codegraph @

mysql-test/suite/rpl_gtid/t/rpl_tablespace.test

raw
1 --echo #########################################################################
2 --echo #
3 --echo # REPLICATION TABLESPACE RELATED TESTS.
4 --echo #
5 --echo #########################################################################
6 --echo #
7 --echo # Bug#21081898 INNODB: TABLESPACE RELATED DDLS ARE NOT COMMITTING ONGOING
8 --echo # TRANSACTION
9 --echo #
10 --echo # Patch for this bug also fixes Bug#21082728: ASSERT
11 --echo # `THD->VARIABLES.GTID_NEXT.TYPE != UNDEFINED_GROUP'
12 --echo # FOR DML+TABLESPACE DDL
13 --echo #
14 --echo # #######################################################################
15
16 --source include/master-slave.inc
17
18 --connection master
19 --echo [On MASTER]
20
21 --echo # TEST Bug#21082728: Execute CREATE TABLESPACE inside active transaction
22 --echo # with GTID_NEXT set. Check for proper error code and transaction state
23 --echo # by verifying table content after issuing a ROLLBACK.
24 CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=INNODB;
25 SET @saved_gtid_next= @@session.gtid_next;
26 SET GTID_NEXT='aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1';
27 BEGIN;
28 INSERT INTO t1 VALUES (1);
29 --error ER_CANT_DO_IMPLICIT_COMMIT_IN_TRX_WHEN_GTID_NEXT_IS_SET
30 CREATE TABLESPACE ts1 ADD DATAFILE './ts1.ibd' ENGINE=INNODB;
31 ROLLBACK;
32 SET GTID_NEXT='aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2';
33 --echo # Select should return Empty result
34 SELECT * FROM t1;
35 --echo # Issue ROLLBACK to release GTID
36 ROLLBACK;
37
38 --echo # TEST Bug#21081898: Execute CREATE TABLESPACE inside active transaction
39 --echo # with GTID_NEXT=automatic. Check table content for impliciti commit.
40 SET GTID_NEXT = 'AUTOMATIC';
41 BEGIN;
42 INSERT INTO t1 VALUES (1);
43 CREATE TABLESPACE ts1 ADD DATAFILE './ts1.ibd' ENGINE=INNODB;
44 ROLLBACK;
45 --echo # Select should return one row inserted above
46 SELECT * FROM t1;
47
48 --echo # Cleanup
49 DROP TABLE t1;
50 DROP TABLESPACE ts1;
51 SET GTID_NEXT= @saved_gtid_next;
52 --echo # "STOP SLAVE" and verify that the SQL thread was properly stopped and
53 --echo # left no gaps.
54 --source include/rpl_end.inc