Bug #81468 MySQL server fails to rewrite batch insert when column name contains word select

Description:
When testing for whether a statement is rewriteable or not, the Prepared Statement canRewrite method will return false if any of the columns contain the substring "select".

This leads to statements that should be rewritten and batchable to being inserted one by one.

How to repeat:
Create a Prepared Statement with a query that includes a column with substring "select" in one of the columns.

Suggested fix:
Changing the parsing strategy not to simply check for the existence of 'select' but parse more carefully to, possibly by ignoring strings between parentheses.

Having looked at the Connector/J source, it appears that the bug is on line 5077 in PreparedStatement source for release 5.1.

Link is: https://github.com/mysql/mysql-connector-j/blob/release/5.1/src/com/mysql/jdbc/PreparedSta...

Hello Xander Garbett,

Thank you for the bug report.
Verified based on internal discussion with dev's.

Thanks,
Chiranjeevi.

Bug#88105 is marked as duplicate of this one. Please look there for possible workaround.

Posted by developer:
 
Added the following entry to the Connector/J 8.0.29 changelog:

"A PreparedStatement could not be rewritten for batch insert if any table column involved contained "select" as a substring in the column name."