Uploaded image for project: 'MariaDB Connector/C'
  1. MariaDB Connector/C
  2. CONC-424

mysql_stmt_store_result returns empty error

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 3.0.10
    • 3.0.11, 3.1.3
    • None
    • None

    Description

      The mysql_stmt_store_result function can return an error, even though mysql_stmt_errno(), mysql_stmt_sqlstate(), and mysql_stmt_error() do not actually contain information about an error. This may be related to running stored procedures that contain a cursor.

      To reproduce, load the attached schema:

      sudo mysql -u root db1 < cursortest.sql

      And then build the attached program:

      g++ -ggdb -c $(mariadb_config --cflags) cursortest.cpp
      		 
      g++ -o cursortest cursortest.o $(mariadb_config --libs)

      And then run the program.

      At that point, you should see an empty error:

      $ ./cursortest
      		 
      Query: CALL testCursor()
      		 
      Failed to store result. Error 0 (00000):
      		 
      Result set #1 had 0 rows
      		 
      Received 1 result sets
      		 
      Query: CALL testNoCursor()
      		 
      Segmentation fault

      See CONC-425 about the segmentation fault.

      Attachments

        1. cursortest.cpp
          5 kB
          Geoff Montee
        2. cursortest.sql
          0.8 kB
          Geoff Montee

        Issue Links

          is caused by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-17252 mysql_stmt_fetch error during fetch of stored procedure (with cursor) results

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Stalled

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19321 Cursor flag set incorrectly in COM_STMT_EXECUTE response

          • Major - Major loss of function.
          • Open
          relates to

          Bug - A problem which impairs or prevents the functions of the product. CONC-425 Segmentation fault in ma_alloc_root

          • Major - Major loss of function.
          • Closed

          Activity

            People

              georg Georg Richter
              GeoffMontee Geoff Montee (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.