Bug #67508 LOAD DATA INFILE automatically commits transaction in 5.5.28 of Innodb
Submitted: 7 Nov 2012 18:07 Modified: 7 Nov 2012 18:26
Reporter: David Ni Email Updates:
Status: Not a Bug Impact on me:
Category:MySQL Server: InnoDB storage engine Severity:S1 (Critical)
Version:5.5.28 OS:Windows
Assigned to: CPU Architecture:Any
Tags: commit transaction, innodb, LOAD DATA INFILE

[7 Nov 2012 18:07] David Ni
my database in 5.5.28,the table is in Innodb,I did this:

set autocommit=0;
start transaction;
load data local infile 'D:/work/eHealth/Clinic trial/Load Data/prot_study_data.csv'
into table prot_study 
character set utf8
fields terminated by ',';
select * from prot_study;

those rows are loaded to the table,I have read the manual,it says that load data infile only automatically commit in NDB engine,but my table is Innodb,why does this still happen?

How to repeat:
see the description.
[7 Nov 2012 18:19] David Ni
please discard this report,it works.