1 files changed, 24 insertions, 0 deletions
diff --git a/mysql-test/include/loaddata_autocom.inc b/mysql-test/include/loaddata_autocom.inc
new file mode 100644
index 00000000..8c38965f
--- /dev/null
+++ b/mysql-test/include/loaddata_autocom.inc
@@ -0,0 +1,24 @@
+# Test if the engine does autocommit in LOAD DATA INFILE, or not
+
+eval SET SESSION DEFAULT_STORAGE_ENGINE = $engine_type;
+
+--disable_warnings
+drop table if exists t1;
+--enable_warnings
+
+let $load_file= $MYSQLTEST_VARDIR/std_data/loaddata2.dat;
+
+create table t1 (id int unsigned not null auto_increment primary key, a text, b text);
+start transaction;
+--replace_result $load_file LOAD_FILE
+eval load data infile '$load_file' ignore into table t1 fields terminated by ',' enclosed by '''' (a, b);
+commit;
+select count(*) from t1;
+truncate table t1;
+start transaction;
+--replace_result $load_file LOAD_FILE
+eval load data infile '$load_file' ignore into table t1 fields terminated by ',' enclosed by '''' (a, b);
+rollback;
+select count(*) from t1;
+
+drop table t1;