summaryrefslogtreecommitdiff
path: root/mysql-test/include/loaddata_autocom.inc
diff options
context:
space:
mode:
authortsmith/tim@siva.hindu.god <>2006-09-13 15:37:35 -0600
committertsmith/tim@siva.hindu.god <>2006-09-13 15:37:35 -0600
commit52c01e88d48760c3329390eda96ff1afee7a68f5 (patch)
treec6594a96f1dfc64d3662cde3c604ecbe39245554 /mysql-test/include/loaddata_autocom.inc
parent6a31ec2cadb56ca70acffc30a706fbcae614181f (diff)
downloadmariadb-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.inc8
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;