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

Recreate/reuse temporary table

    XMLWordPrintable

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.

      This repeatedly calls works fine on 11.1.2, but not works 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

            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.