1reset master; 2create table t1 (i int, j int); 3create view v1 as select i from t1; 4LOAD DATA LOCAL INFILE 'MYSQLTEST_VARDIR/3940.data' INTO TABLE v1 (i); 5LOAD DATA LOCAL INFILE 'MYSQLTEST_VARDIR/3940.data' INTO TABLE v1; 6select * from v1; 7i 81 91 10include/show_binlog_events.inc 11Log_name Pos Event_type Server_id End_log_pos Info 12master-bin.000001 # Gtid # # GTID #-#-# 13master-bin.000001 # Query # # use `test`; create table t1 (i int, j int) 14master-bin.000001 # Gtid # # GTID #-#-# 15master-bin.000001 # Query # # use `test`; CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select i from t1 16master-bin.000001 # Gtid # # BEGIN GTID #-#-# 17master-bin.000001 # Begin_load_query # # ;file_id=#;block_len=# 18master-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=# 19master-bin.000001 # Query # # COMMIT 20master-bin.000001 # Gtid # # BEGIN GTID #-#-# 21master-bin.000001 # Begin_load_query # # ;file_id=#;block_len=# 22master-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=# 23master-bin.000001 # Query # # COMMIT 24drop view v1; 25drop table t1; 26