MySQL Bugs: #119245: Select into fix breaks queries with 'into' in them

Bug #119245	Select into fix breaks queries with 'into' in them
Submitted:	27 Oct 14:02	Modified:	30 Oct 18:30
Reporter:	Kees Hoekzema	Email Updates:
Status:	Verified	Impact on me:	None
Category:	Connector / J	Severity:	S3 (Non-critical)
Version:	9.5.0	OS:	Any
Assigned to:	Filipe Silva	CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
In the commit "Fix for Bug#107543 (Bug#34464351), Cannot execute a SELECT statement that writes to an OUTFILE." you probably fixed 'select into' queries.

However, you broke queries that have 'into' *somewhere* in the query.

How to repeat:
For example 'select columnA, Mintopics ...' results in a java.sql.SQLException: Statement.executeQuery() cannot issue statements that do not produce result sets.

Escaping the columnname works as workaround: 'select columnA, `Mintopics` ..'

Thank you for your interest in MySQL Connector/J and for taking the time to report this issue.

Verified as described.