Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-4603

mysql_stmt_reset returns "commands out of sync" error

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 10.0.3
    • 10.0.9
    • None
    • None
    • all

    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.

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          georg Georg Richter added a comment -

          Suggested fix

          georg Georg Richter added a comment - Suggested fix
          wlad Vladislav Vaintroub added a comment -

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

          wlad Vladislav Vaintroub added a comment - 1. applied patch. 2. got error running mysql_client_test, in the test code Hmm. Georg, an idea?
          georg Georg Richter added a comment -

          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).

          georg Georg Richter added a comment - 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).

          People

            serg Sergei Golubchik
            georg Georg Richter
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.