diff options
| author | unknown <monty@narttu.mysql.fi> | 2003-05-26 11:47:03 +0300 |
|---|---|---|
| committer | unknown <monty@narttu.mysql.fi> | 2003-05-26 11:47:03 +0300 |
| commit | e864f2592de68f04891d9611b0debfb123e8fd88 (patch) | |
| tree | 4c6d13878730cb0bb3e583c3b14063320c0e8bdb /mysql-test/r/loaddata.result | |
| parent | 68aa31f268660db07b634f021716ecb872e19679 (diff) | |
| download | mariadb-git-e864f2592de68f04891d9611b0debfb123e8fd88.tar.gz | |
Added testing of LOAD DATA ... STARTING BY
Added read_only variable
mysql-test/r/loaddata.result:
Added testing of STARTING BY
mysql-test/t/loaddata.test:
Added testing of STARTING BY
sql/log_event.cc:
Code cleanup
sql/set_var.cc:
Added read_only variable
sql/sql_update.cc:
Remove not used variable
Diffstat (limited to 'mysql-test/r/loaddata.result')
| -rw-r--r-- | mysql-test/r/loaddata.result | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/r/loaddata.result b/mysql-test/r/loaddata.result index d121a4e6c40..59153f3353a 100644 --- a/mysql-test/r/loaddata.result +++ b/mysql-test/r/loaddata.result @@ -8,4 +8,11 @@ a b c d 0000-00-00 0000-00-00 0000-00-00 0000-00-00 2003-03-03 2003-03-03 2003-03-03 NULL 2003-03-03 2003-03-03 2003-03-03 NULL +truncate table t1; +load data infile '../../std_data/loaddata1.dat' into table t1 fields terminated by ',' LINES STARTING BY ',' (b,c,d); +SELECT * from t1; +a b c d +NULL NULL 0000-00-00 0000-00-00 +NULL 0000-00-00 0000-00-00 0000-00-00 +NULL 2003-03-03 2003-03-03 NULL drop table t1; |