diff options
Diffstat (limited to 'mysql-test/t/gemini.test')
| -rw-r--r-- | mysql-test/t/gemini.test | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/t/gemini.test b/mysql-test/t/gemini.test index 3bbd4d4f23d..9d4451c3551 100644 --- a/mysql-test/t/gemini.test +++ b/mysql-test/t/gemini.test @@ -338,3 +338,18 @@ SELECT * FROM t1; SELECT _userid FROM t1 WHERE _userid='marc@anyware.co.uk'; drop table t1; set autocommit=1; + +# +# Test of load data infile +# + +CREATE TABLE if not exists `t1` ( + `f1` int(11) unsigned NOT NULL default '0', + `f2` tinyint(3) unsigned NOT NULL default '0', + `f3` tinyint(3) unsigned NOT NULL default '0', + PRIMARY KEY (`f1`) +) TYPE=Gemini; +lock table t1 write; +load data infile ''../../std_data/gemini.dat' ignore into table t1 fields terminated by ','; +select f1 from t1; +drop table t1; |