diff options
| author | unknown <monty@narttu.mysql.fi> | 2003-05-05 14:58:33 +0300 |
|---|---|---|
| committer | unknown <monty@narttu.mysql.fi> | 2003-05-05 14:58:33 +0300 |
| commit | 3ed1a9a1882533a47baf6049a5fae414a539ed1e (patch) | |
| tree | 9d4924143a5461c2b577cb392b29861c4050eee0 /mysql-test | |
| parent | 00fd88c9451008237395d93a73d2d78152ea369c (diff) | |
| parent | afe9738efb8d9704b66f6b7cea57ccb011d79a1a (diff) | |
| download | mariadb-git-3ed1a9a1882533a47baf6049a5fae414a539ed1e.tar.gz | |
Merge bk-internal.mysql.com:/home/bk/mysql-4.0
into narttu.mysql.fi:/my/mysql-4.0
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/loaddata.result | 11 | ||||
| -rw-r--r-- | mysql-test/std_data/loaddata1.dat | 3 | ||||
| -rw-r--r-- | mysql-test/t/loaddata.test | 11 |
3 files changed, 25 insertions, 0 deletions
diff --git a/mysql-test/r/loaddata.result b/mysql-test/r/loaddata.result new file mode 100644 index 00000000000..d121a4e6c40 --- /dev/null +++ b/mysql-test/r/loaddata.result @@ -0,0 +1,11 @@ +drop table if exists t1; +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; +a b c d +0000-00-00 NULL 0000-00-00 0000-00-00 +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 +drop table t1; diff --git a/mysql-test/std_data/loaddata1.dat b/mysql-test/std_data/loaddata1.dat new file mode 100644 index 00000000000..c9e8549b211 --- /dev/null +++ b/mysql-test/std_data/loaddata1.dat @@ -0,0 +1,3 @@ +,\N,NULL,, +00,0,000000,, +2003-03-03, 20030303,030303,\N diff --git a/mysql-test/t/loaddata.test b/mysql-test/t/loaddata.test new file mode 100644 index 00000000000..ceb5c47af11 --- /dev/null +++ b/mysql-test/t/loaddata.test @@ -0,0 +1,11 @@ +# +# Some simple test of load data +# + +drop table if exists t1; + +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; +drop table t1; |