Bug #17158 load data infile does not completely load the data

• Submitted: 6 Feb 2006 14:57
• Modified: 6 Feb 2006 22:44
• Reporter: Jonathan Miller
• Status: Duplicate
• Category: MySQL Cluster: Cluster (NDB) storage engine
• Severity: S2 (Serious)
• Version: 4.1->
• OS: Linux (Linux 32 Bit OS)
• Assigned to: Assigned Account
• CPU Architecture: Any

[6 Feb 2006 14: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 22:33] Tomas Ulin

see 17081

[6 Feb 2006 22:44] Tomas Ulin

same as 17081