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

            Transition Time In Source Status Execution Times
            Alice Sherepa made transition -
            Open Confirmed
            		4h 30m 1
            Dmitry Shulga made transition -
            Confirmed In Progress
            		21d 20h 45m 1
            Dmitry Shulga made transition -
            In Progress In Review
            		3d 56m 1
            Oleksandr Byelkin made transition -
            In Review Stalled
            		19h 17m 1
            Dmitry Shulga made transition -
            Stalled Closed
            		6m 43s 1

            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.