Debian Codegraph @

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

raw
1 RESET MASTER;
2 CREATE TABLE employees (store_id INT NOT NULL) PARTITION BY RANGE (store_id)
3 ( PARTITION p0 VALUES LESS THAN (10), PARTITION p1 VALUES LESS THAN (20),
4 PARTITION p2 VALUES LESS THAN (30));
5 INSERT INTO employees VALUES (5);
6 CREATE TABLE t1 (m INT);
7 INSERT INTO t1 VALUES (9);
8 INSERT INTO employees SELECT 5 FROM t1 LIMIT 3;
9 include/show_binlog_events.inc
10 Log_name Pos Event_type Server_id End_log_pos Info
11 binlog.000001 # Query # # use `test`; CREATE TABLE employees (store_id INT NOT NULL) PARTITION BY RANGE (store_id)
12 ( PARTITION p0 VALUES LESS THAN (10), PARTITION p1 VALUES LESS THAN (20),
13 PARTITION p2 VALUES LESS THAN (30))
14 binlog.000001 # Query # # BEGIN
15 binlog.000001 # Query # # use `test`; INSERT INTO employees VALUES (5)
16 binlog.000001 # Xid # # COMMIT /* XID */
17 binlog.000001 # Query # # use `test`; CREATE TABLE t1 (m INT)
18 binlog.000001 # Query # # BEGIN
19 binlog.000001 # Query # # use `test`; INSERT INTO t1 VALUES (9)
20 binlog.000001 # Xid # # COMMIT /* XID */
21 binlog.000001 # Query # # BEGIN
22 binlog.000001 # Table_map # # table_id: # (test.employees)
23 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
24 binlog.000001 # Xid # # COMMIT /* XID */
25 DROP TABLE employees;
26 DROP TABLE t1;