Bug #83091 mysql_more_results returns true after bad SQL query using the embedded server
Submitted: 22 Sep 2016 2:17 Modified: 22 Sep 2016 6:12
Reporter: Daniel Beer Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Embedded Library ( libmysqld ) Severity:S3 (Non-critical)
Version:5.6.33 OS:Linux (RHEL 6.6)
Assigned to: CPU Architecture:Any

[22 Sep 2016 2:17] Daniel Beer 
Description:
The mysql_client_test_embedded application fails on mysql 5.6.33. The issue seems to be that a badly formed multi-statement SQL query does not properly reset the SERVER_MORE_RESULTS_EXISTS flag in the embedded server, so mysql_more_results returns true even after a query failure.

How to repeat:
Build and run mysql_client_test_embedded using mysql 5.6.33:

$ mysql_client_test_embedded

#####################################
57 of (1/1): test_multi_statements  
#####################################
./mysql-client/tests/mysql_client_test.c:5454: check failed: 'rc == 0'
[22 Sep 2016 6:12] MySQL Verification Team 
Hello Daniel Beer,

Thank you for the report.

Thanks,
Umesh
[22 Sep 2016 6:12] MySQL Verification Team 
test results

Attachment: 83091_5.6.33.result (application/octet-stream, text), 2.00 KiB.