Bug #119641 Statement.executeQuery does not execute valid statements
Submitted: 7 Jan 17:34 Modified: 12 Jan 19:17
Reporter: Tino Schöllhorn Email Updates:
Status: Duplicate Impact on me:
None 
Category:Connector / J Severity:S2 (Serious)
Version:9.5.0 OS:Any
Assigned to: CPU Architecture:Any

[7 Jan 17:34] Tino Schöllhorn 
Description:
This seems to be introduced in 9.5.0: When using certain SELECT-Statements the method StatementImpl.executeQuery throws a Exception in the case when a Statement does not produce a result set. 

Yet, there are valid SELECT-Statement, which produce a result set - and yet QueryInfo.getQueryReturnType() returns QueryReturnType.DOES_NOT_PRODUCE_RESULT_SET.

How to repeat:
I created a small test case which may be used to reproduce the issue. It is attached.
[7 Jan 17:35] Tino Schöllhorn 
JUnit-TestCase

Attachment: MySQLDriverTest.java (application/octet-stream, text), 665 bytes.
[12 Jan 19:17] Filipe Silva 
Thank you for your interest in MySQL Connector/J and for reporting this bug. This issue is a duplicate of Bug#119245.