Debian Codegraph @

mysql-test/suite/binlog/t/load_data_stm_view.test

raw
1 #
2 # MDEV-3940 Server crash or assertion `item->type() == Item::STRING_ITEM' failure on LOAD DATA through a view with statement binary logging
3 #
4
5 --source include/have_binlog_format_statement.inc
6
7 --write_file $MYSQLTEST_VARDIR/3940.data
8 1
9 EOF
10
11 reset master;
12
13 create table t1 (i int, j int);
14 create view v1 as select i from t1;
15 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
16 --eval LOAD DATA LOCAL INFILE '$MYSQLTEST_VARDIR/3940.data' INTO TABLE v1 (i)
17 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
18 --eval LOAD DATA LOCAL INFILE '$MYSQLTEST_VARDIR/3940.data' INTO TABLE v1
19 select * from v1;
20 --let $binlog_file = LAST
21 --source include/show_binlog_events.inc
22 drop view v1;
23 drop table t1;
24 --remove_file $MYSQLTEST_VARDIR/3940.data