|
The following fails when client multi-statements are enabled and all lines are executed as a single command. The START TRANSACTION fails with a Commands out of sync; you can't run this command now error.
CREATE OR REPLACE TABLE test.t1(id INT);
|
LOAD DATA LOCAL INFILE './data.csv' INTO TABLE test.t1;LOAD DATA LOCAL INFILE './data.csv' INTO TABLE test.t1; -- Note: this line executed as a single mysql_query
|
START TRANSACTION; -- this starts to fail with 02e7d5654dd83600f3c1e27b7c61ab1f4ea59138
|
SELECT COUNT(*) FROM test.t1; -- should return double the rows that data.csv contains
|
COMMIT;
|
This works before commit 02e7d5654dd83600f3c1e27b7c61ab1f4ea59138 and fails after it.
|