Regression in reset sequence for MySQL

[Gusted]

Hi,

For the Forgejo project, an automatic dependency update PR was opened for testfixtures to version v3.12.0 from v3.11.0 and the CI caught an error that was related to the update:

LoadFixtures failed after retries: Error 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE `issue` AUTO_INCREMENT = 10000;ALTER TABLE `issue_label` AUTO_INCREM' at line 1

This looks like to be a regression from #208. It seems like MySQL doesn't allow multiple ALTER statements in one go.

[andreynering]

Hi @Gusted,

Can you add the multiStatements parameters like this?:

testfixtures/.sample.env

Line 2 in 98baced

MYSQL_CONN_STRING="root:@/testfixtures_test?multiStatements=true"

That parameter is required, and we have that documented on the README.

[nannany]

I was also getting the following error, but by putting the multiStatements=true option, it worked. Thank you very much.

Error 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE ~~~

[andreynering]

I'm closing for now, but if anyone has any thoughts, feel free to add.