diff options
author | tsmith/tim@siva.hindu.god <> | 2006-09-13 15:37:35 -0600 |
---|---|---|
committer | tsmith/tim@siva.hindu.god <> | 2006-09-13 15:37:35 -0600 |
commit | 52c01e88d48760c3329390eda96ff1afee7a68f5 (patch) | |
tree | c6594a96f1dfc64d3662cde3c604ecbe39245554 /mysql-test/include/loaddata_autocom.inc | |
parent | 6a31ec2cadb56ca70acffc30a706fbcae614181f (diff) | |
download | mariadb-git-52c01e88d48760c3329390eda96ff1afee7a68f5.tar.gz |
Post-merge fixes:
- Remove extra EXTRA_DIST from several Makefile.ams
- Add dummy primary key to test table in loaddata_autocom.inc
Diffstat (limited to 'mysql-test/include/loaddata_autocom.inc')
-rw-r--r-- | mysql-test/include/loaddata_autocom.inc | 8 |
1 files changed, 5 insertions, 3 deletions
diff --git a/mysql-test/include/loaddata_autocom.inc b/mysql-test/include/loaddata_autocom.inc index e5071c73c49..cca56709331 100644 --- a/mysql-test/include/loaddata_autocom.inc +++ b/mysql-test/include/loaddata_autocom.inc @@ -7,14 +7,16 @@ eval SET SESSION STORAGE_ENGINE = $engine_type; drop table if exists t1; --enable_warnings -create table t1 (a text, b text); +# NDB does not support the create option 'Binlog of table with BLOB attribute and no PK' +# So use a dummy PK here. +create table t1 (id int unsigned not null auto_increment primary key, a text, b text); start transaction; -load data infile '../std_data_ln/loaddata2.dat' into table t1 fields terminated by ',' enclosed by ''''; +load data infile '../std_data_ln/loaddata2.dat' into table t1 fields terminated by ',' enclosed by '''' (a, b); commit; select count(*) from t1; truncate table t1; start transaction; -load data infile '../std_data_ln/loaddata2.dat' into table t1 fields terminated by ',' enclosed by ''''; +load data infile '../std_data_ln/loaddata2.dat' into table t1 fields terminated by ',' enclosed by '''' (a, b); rollback; select count(*) from t1; |