Bug #17158 load data infile does not completely load the data
Submitted: 6 Feb 2006 15:57 Modified: 6 Feb 2006 23:44
Reporter: Jonathan Miller
Status: Duplicate
Category:Server: Cluster Severity:S2 (Serious)
Version:4.1-> OS:Linux (Linux 32 Bit OS)
Assigned to: Tomas Ulin Target Version:

[6 Feb 2006 15:57] Jonathan Miller 
Description:
With this bug there are no errors or warnings returned. It goes along as if the data was
loaded, but when you select a count from the table, the table is empty.

This works for both MyISAM and InnoDB engines.

+ DROP TABLE IF EXISTS t1;
+ create table t1 (word char(20) not null)ENGINE=NDB;
+ load data infile '../../std_data/words.dat' into table t1 ;
+ SHOW WARNINGS;
+ Level Code    Message
+ select count(*) from t1;
+ count(*)
+ 0
+ DROP TABLE t1;

How to repeat:
--disable_warnings
DROP TABLE IF EXISTS t1;
--enable_warnings
create table t1 (word char(20) not null)ENGINE=NDB;
load data infile '../../std_data/words.dat' into table t1 ;
SHOW WARNINGS;
sleep 20;
select count(*) from t1;
DROP TABLE t1;
[6 Feb 2006 23:33] Tomas Ulin 
see 17081
[6 Feb 2006 23:44] Tomas Ulin 
same as 17081