Bug #115144 Execute batch queries with allowMultiQueries=false
Submitted: 28 May 2024 0:17 Modified: 28 May 2024 13:06
Reporter: li binglong Email Updates:
Status: Duplicate Impact on me:
None 
Category:Connector / J Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: CPU Architecture:Any

[28 May 2024 0:17] li binglong 
Description:
When I execute batch queries, if allowMultiQueries=false, the error should not be a syntax error. Instead, it should provide more detailed information, because generally, nobody considers the semicolon (;) to be unsupported syntax. I spent an entire day troubleshooting this issue, and even professional DBAs thought there was nothing wrong with the syntax.

I look forward to your response. Any response would be greatly appreciated.

How to repeat:
With allowMultiQueries=false in jdbcurl.

You can reproduce the issue by using a semicolon (;) to separate and execute multiple queryin a single statement.

Suggested fix:
Change the error message more helpful!
[28 May 2024 13:06] MySQL Verification Team 
Hello!

Thank you for the bug report.
Imho this is duplicate of Bug #110323, please see Bug #110323.

Regards,
Ashwini Patil