[MDEV-4603] mysql_stmt_reset returns "commands out of sync" error Created: 2013-05-31  Updated: 2014-03-06  Resolved: 2014-03-06

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.0.3
Fix Version/s: 10.0.9

Type: Bug Priority: Critical
Reporter: Georg Richter Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: None
Environment:

all

Attachments: File mdev4603.patch     File test.c    

 Description   

When executing a stored procedure via prepared statement API it's not possible to reset the statement via mysql_stmt_reset function.

mysql_stmt_reset returns error 2014 instead of clearing pending result sets.

test case attached.

 Comments   
Comment by Georg Richter [ 2013-05-31 ]

Suggested fix

Comment by Vladislav Vaintroub [ 2013-06-07 ]

1. applied patch.
2. got error running mysql_client_test, in the test code
Hmm.
Georg, an idea?

Comment by Georg Richter [ 2013-06-09 ]

Wlad,

as mentioned in the header of the test, the test requires the one liner fix for MDEV-4604.

If we want to support server versions without fix for mdev-4604 bug, we need to add additional checks in mysql_next_result and mysql_stmt_store_result (which is already implemented in mariadb-native-client).

Generated at Thu Feb 08 06:57:40 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.