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
• Status: Not a Bug
• Category: MySQL Server: InnoDB storage engine
• Severity: S1 (Critical)
• Version: 5.5.28
• OS: Windows
• CPU Architecture: Any
• Tags: commit transaction, innodb, LOAD DATA INFILE

[7 Nov 2012 18:07] David Ni

Description:
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 ',';
rollback;
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.