diff options
| author | Alexander Barkov <bar@mariadb.com> | 2018-03-20 13:02:44 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.com> | 2018-03-20 13:02:44 +0400 |
| commit | e263530bea641e610a2cb6dac20da369272551b1 (patch) | |
| tree | 49f4f10ea7710af1da81e653eea0fa8b872cf7e7 /mysql-test/r/loaddata.result | |
| parent | 85ddd9e8ce11bef089ccc6c86745142d09639c14 (diff) | |
| download | mariadb-git-e263530bea641e610a2cb6dac20da369272551b1.tar.gz | |
MDEV-15597 Add class Load_data_outvar and avoid using Item::STRING_ITEM for Item_user_var_as_out_param detection
Diffstat (limited to 'mysql-test/r/loaddata.result')
| -rw-r--r-- | mysql-test/r/loaddata.result | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/mysql-test/r/loaddata.result b/mysql-test/r/loaddata.result index 7a189f36cc6..98b8f2de4a5 100644 --- a/mysql-test/r/loaddata.result +++ b/mysql-test/r/loaddata.result @@ -614,3 +614,24 @@ SELECT * FROM t1; a b 1 DROP TABLE t1; +# +# MDEV-15597 Add class Load_data_outvar and avoid using Item::STRING_ITEM for Item_user_var_as_out_param detection +# +SET sql_mode=NO_AUTO_VALUE_ON_ZERO; +CREATE TABLE t1 (id integer not null auto_increment primary key); +LOAD DATA INFILE '../../std_data/loaddata/nl.txt' INTO TABLE t1 FIELDS TERMINATED BY ''; +Warnings: +Warning 1261 Row 1 doesn't contain data for all columns +SELECT * FROM t1; +id +0 +DROP TABLE t1; +SET sql_mode=''; +CREATE TABLE t1 (id integer not null auto_increment primary key); +LOAD DATA INFILE '../../std_data/loaddata/nl.txt' INTO TABLE t1 FIELDS TERMINATED BY ''; +Warnings: +Warning 1261 Row 1 doesn't contain data for all columns +SELECT * FROM t1; +id +1 +DROP TABLE t1; |