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 created issue -
          georg Georg Richter added a comment -

          Suggested fix

          georg Georg Richter added a comment - Suggested fix
          georg Georg Richter made changes -
          Field Original Value New Value
          Attachment mdev4603.patch [ 22315 ]
          serg Sergei Golubchik made changes -
          Affects Version/s 10.0.4 [ 12900 ]
          Affects Version/s 10.0.3 [ 13200 ]
          elenst Elena Stepanova made changes -
          Assignee Vladislav Vaintroub [ wlad ]
          elenst Elena Stepanova made changes -
          Fix Version/s 10.0.4 [ 13101 ]
          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?
          wlad Vladislav Vaintroub made changes -
          Assignee Vladislav Vaintroub [ wlad ] Georg Richter [ georg ]
          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).
          serg Sergei Golubchik made changes -
          Fix Version/s 10.0.5 [ 13201 ]
          Fix Version/s 10.0.4 [ 13101 ]
          serg Sergei Golubchik made changes -
          Fix Version/s 10.0.6 [ 13202 ]
          Fix Version/s 10.0.5 [ 13201 ]
          serg Sergei Golubchik made changes -
          Fix Version/s 10.0.7 [ 14100 ]
          Fix Version/s 10.0.6 [ 13202 ]
          elenst Elena Stepanova made changes -
          Fix Version/s 10.0.8 [ 14200 ]
          Fix Version/s 10.0.7 [ 14100 ]
          serg Sergei Golubchik made changes -
          Fix Version/s 10.0.9 [ 14400 ]
          Fix Version/s 10.0.8 [ 14200 ]
          serg Sergei Golubchik made changes -
          Assignee Georg Richter [ georg ] Sergei Golubchik [ serg ]
          serg Sergei Golubchik made changes -
          Resolution Fixed [ 1 ]
          Status Open [ 1 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow defaullt [ 27618 ] MariaDB v2 [ 42830 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Workflow MariaDB v2 [ 42830 ] MariaDB v3 [ 61853 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 61853 ] MariaDB v4 [ 146746 ]

          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.