Debian Codegraph @

mysql-test/suite/rpl/r/rpl_savepoint.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 #
7 # Bug#50124 Rpl failure on DROP table with concurrent txn/non-txn
8 # DML flow and SAVEPOINT
9 #
10 # Connection master
11 DROP TABLE IF EXISTS tt, nt;
12 CREATE TABLE tt (i INT) ENGINE = InnoDB;
13 CREATE TABLE nt (i INT) ENGINE = MyISAM;
14 FLUSH LOGS;
15 START TRANSACTION;
16 INSERT INTO nt VALUES (1);
17 SAVEPOINT insert_statement;
18 INSERT INTO tt VALUES (1);
19 # Connection master1
20 # Sending:
21 DROP TABLE tt;
22 # Connection master
23 ROLLBACK TO SAVEPOINT insert_statement;
24 Warnings:
25 Warning 1196 Some non-transactional changed tables couldn't be rolled back
26 COMMIT;
27 # Connection master1
28 # Reaping: DROP TABLE tt
29 FLUSH LOGS;
30 # Connection master
31 DROP TABLE nt;
32 include/rpl_end.inc