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/t/loaddata.test | |
| 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/t/loaddata.test')
| -rw-r--r-- | mysql-test/t/loaddata.test | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/loaddata.test b/mysql-test/t/loaddata.test index ceb5c47af11..e63f0780e3e 100644 --- a/mysql-test/t/loaddata.test +++ b/mysql-test/t/loaddata.test @@ -8,4 +8,12 @@ create table t1 (a date, b date, c date not null, d date); load data infile '../../std_data/loaddata1.dat' into table t1 fields terminated by ','; load data infile '../../std_data/loaddata1.dat' into table t1 fields terminated by ',' IGNORE 2 LINES; SELECT * from t1; +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; drop table t1; + + + + |