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

Recreate/reuse temporary table

Details

    Description

      I'm using a temporary table in stored function. It works fine on first call, but if I repeatedly call this stored function, the second call hangs at the open cursor statement whit "no such table" error.

      Sample attached.

      Repeated calls works fine on 11.1.2, but not on 11.2.3, 11.3.2.

      Attachments

        Issue Links

          is caused by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-31799 Unexpected ER_TRG_NO_SUCH_ROW_IN_TRG and server crash after ALTER TABLE

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-5816 MySQL WL#4179 - Stored programs: validation of stored program statements

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            szolex Szolex Kft. created issue -
            szolex Szolex Kft. made changes -
            Field Original Value New Value
            Summary Reuse temporary table Recreate/reuse temporary table
            szolex Szolex Kft. made changes -
            Affects Version/s 11.2.3 [ 29521 ]
            szolex Szolex Kft. made changes -
            Description I'm using a temporary table in stored function. It works fine on first call, but if I repeatedly call this stored function, the second call hangs at the open cursor statement whit "no such table" error.

            Sample attached.

            This repeatedly calls works fine on 11.1.2, bur not works on 11.2.3, 11.3.2.             		I'm using a temporary table in stored function. It works fine on first call, but if I repeatedly call this stored function, the second call hangs at the open cursor statement whit "no such table" error.

            Sample attached.

            This repeatedly calls works fine on 11.1.2, but not works on 11.2.3, 11.3.2.
            szolex Szolex Kft. made changes -
            Attachment temptable.sql [ 73188 ]
            szolex Szolex Kft. made changes -
            Attachment temptable.sql [ 73189 ]
            alice Alice Sherepa made changes -
            Fix Version/s 11.2 [ 28603 ]
            Fix Version/s 11.3 [ 28565 ]
            alice Alice Sherepa added a comment -

            Thank you for the report! I repeated as described on 11.2-11.3
            Regression after f329fe1c235ae0f29f465b464360d6c19c181959 commit ( MDEV-31799 Unexpected ER_TRG_NO_SUCH_ROW_IN_TRG and server crash after ALTER TABLE )

            alice Alice Sherepa added a comment - Thank you for the report! I repeated as described on 11.2-11.3 Regression after f329fe1c235ae0f29f465b464360d6c19c181959 commit ( MDEV-31799 Unexpected ER_TRG_NO_SUCH_ROW_IN_TRG and server crash after ALTER TABLE )
            alice Alice Sherepa made changes -
            alice Alice Sherepa made changes -
            alice Alice Sherepa made changes -
            Status Open [ 1 ] Confirmed [ 10101 ]
            alice Alice Sherepa made changes -
            Assignee Dmitry Shulga [ JIRAUSER47315 ]
            shulga Dmitry Shulga made changes -
            Status Confirmed [ 10101 ] In Progress [ 3 ]
            shulga Dmitry Shulga added a comment -

            The branch for review is bb-11.2-MDEV-33525

            shulga Dmitry Shulga added a comment - The branch for review is bb-11.2- MDEV-33525
            shulga Dmitry Shulga made changes -
            Assignee Dmitry Shulga [ JIRAUSER47315 ] Oleksandr Byelkin [ sanja ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            sanja Oleksandr Byelkin added a comment -

            OK to push

            sanja Oleksandr Byelkin added a comment - OK to push
            sanja Oleksandr Byelkin made changes -
            Assignee Oleksandr Byelkin [ sanja ] Dmitry Shulga [ JIRAUSER47315 ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            shulga Dmitry Shulga made changes -
            Component/s Stored routines [ 13905 ]
            Fix Version/s 11.2.4 [ 29631 ]
            Fix Version/s 11.4.2 [ 29633 ]
            Fix Version/s 11.5.1 [ 29634 ]
            Fix Version/s 11.3 [ 28565 ]
            Fix Version/s 11.2 [ 28603 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            Roel Roel Van de Paar made changes -
            Description I'm using a temporary table in stored function. It works fine on first call, but if I repeatedly call this stored function, the second call hangs at the open cursor statement whit "no such table" error.

            Sample attached.

            This repeatedly calls works fine on 11.1.2, but not works on 11.2.3, 11.3.2.             		I'm using a temporary table in stored function. It works fine on first call, but if I repeatedly call this stored function, the second call hangs at the open cursor statement whit "no such table" error.

            Sample attached.

            Repeated calls works fine on 11.1.2, but not on 11.2.3, 11.3.2.

            People

              shulga Dmitry Shulga
              szolex Szolex Kft.
              Votes:
              0 Vote for this issue
              Watchers:
              7 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.