Debian Codegraph @

mysql-test/suite/ndb/r/loaddata_autocom_ndb.result

raw
1 SET SESSION DEFAULT_STORAGE_ENGINE = ndbcluster;
2 drop table if exists t1;
3 create table t1 (id int unsigned not null auto_increment primary key, a text, b text);
4 start transaction;
5 load data infile 'LOAD_FILE' ignore into table t1 fields terminated by ',' enclosed by '''' (a, b);
6 Warnings:
7 Warning 1261 Row 3 doesn't contain data for all columns
8 commit;
9 select count(*) from t1;
10 count(*)
11 4
12 truncate table t1;
13 start transaction;
14 load data infile 'LOAD_FILE' ignore into table t1 fields terminated by ',' enclosed by '''' (a, b);
15 Warnings:
16 Warning 1261 Row 3 doesn't contain data for all columns
17 rollback;
18 Warnings:
19 Warning 1196 Some non-transactional changed tables couldn't be rolled back
20 select count(*) from t1;
21 count(*)
22 4
23 drop table t1;