Debian Codegraph @

mysql-test/suite/binlog/r/binlog_mdev22915.result

raw
1 RESET MASTER;
2 connect con1,localhost,root,,;
3 CREATE TABLE t1 (a INT) ENGINE=InnoDB;
4 CREATE TRIGGER tr BEFORE UPDATE ON t1 FOR EACH ROW BEGIN END;
5 LOCK TABLES t1 WRITE;
6 LOAD DATA INFILE 'x' INTO TABLE x;
7 ERROR HY000: Table 'x' was not locked with LOCK TABLES
8 SET AUTOCOMMIT= OFF;
9 INSERT INTO t1 VALUES (1);
10 SAVEPOINT A;
11 COMMIT;
12 disconnect con1;
13 connect con2,localhost,root,,;
14 SELECT 1;
15 1
16 1
17 disconnect con2;
18 connection default;
19 include/show_binlog_events.inc
20 Log_name Pos Event_type Server_id End_log_pos Info
21 master-bin.000001 # Gtid # # GTID #-#-#
22 master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT) ENGINE=InnoDB
23 master-bin.000001 # Gtid # # GTID #-#-#
24 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` TRIGGER tr BEFORE UPDATE ON t1 FOR EACH ROW BEGIN END
25 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
26 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (1)
27 master-bin.000001 # Table_map # # table_id: # (test.t1)
28 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
29 master-bin.000001 # Query # # SAVEPOINT `A`
30 master-bin.000001 # Xid # # COMMIT /* XID */
31 DROP TABLE t1;