Debian Codegraph @

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

raw
1 reset master;
2 create table t1 (i int, j int);
3 create view v1 as select i from t1;
4 LOAD DATA LOCAL INFILE 'MYSQLTEST_VARDIR/3940.data' INTO TABLE v1 (i);
5 LOAD DATA LOCAL INFILE 'MYSQLTEST_VARDIR/3940.data' INTO TABLE v1;
6 select * from v1;
7 i
8 1
9 1
10 include/show_binlog_events.inc
11 Log_name Pos Event_type Server_id End_log_pos Info
12 master-bin.000001 # Gtid # # GTID #-#-#
13 master-bin.000001 # Query # # use `test`; create table t1 (i int, j int)
14 master-bin.000001 # Gtid # # GTID #-#-#
15 master-bin.000001 # Query # # use `test`; CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select i from t1
16 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
17 master-bin.000001 # Begin_load_query # # ;file_id=#;block_len=#
18 master-bin.000001 # Execute_load_query # # use `test`; LOAD DATA LOCAL INFILE 'MYSQLTEST_VARDIR/3940.data' IGNORE INTO TABLE `v1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`i`) ;file_id=#
19 master-bin.000001 # Query # # COMMIT
20 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
21 master-bin.000001 # Begin_load_query # # ;file_id=#;block_len=#
22 master-bin.000001 # Execute_load_query # # use `test`; LOAD DATA LOCAL INFILE 'MYSQLTEST_VARDIR/3940.data' IGNORE INTO TABLE `v1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`i`) ;file_id=#
23 master-bin.000001 # Query # # COMMIT
24 drop view v1;
25 drop table t1;