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

mysql_stmt_reset returns "commands out of sync" error

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Critical
        • Resolution: Fixed
        • Affects Version/s: 10.0.3
        • Fix Version/s: 10.0.9
        • Component/s: None
        • Labels:
          None
        • Environment:
          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.

            Gliffy Diagrams

              Attachments

                Activity

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

                Suggested fix

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

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

                Show
                wlad Vladislav Vaintroub added a comment - 1. applied patch. 2. got error running mysql_client_test, in the test code Hmm. Georg, an idea?
                Hide
                Permalink
                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).

                Show
                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

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

                    Dates

                    • Created:
                      Updated:
                      Resolved: