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

DROP TABLE on GTT table succeeds in MariaDB only

    XMLWordPrintable

Details

    • Not for Release Notes
    • Q4/2025 Server Maintenance

    Description

      # CLI Session 1
      		 
      CREATE GLOBAL TEMPORARY TABLE t (c INT);
      		 
      INSERT INTO t VALUES (1);

      Followed by:

      # CLI Session 2
      		 
      INSERT INTO t VALUES (1);
      		 
      DROP TABLE t;

      On MariaDB leads to:

      MDEV-35915-5 CS 12.2.0 5a344faeb0bab8520ad5c92be6fc1fc0a9c56d52 (Optimized, Clang 21.1.0-20250811) Build 16/09/2025

      		 
      12.2.0-opt>DROP TABLE t;
      		 
      Query OK, 0 rows affected (0.008 sec)

      But on oracle the same leads to:

      oracle

      		 
      SQL> DROP TABLE t;
      		 
      DROP TABLE t
      		 
                 *
      		 
      ERROR at line 1:
      		 
      ORA-14452: attempt to create, alter or drop an index on temporary table already in use

      Attachments

        Issue Links

          is caused by

          New Feature - A new feature of the product, which has yet to be developed. MDEV-35915 Implement Global temporary tables

          • Critical - Crashes, loss of data, severe memory leak.
          • In Testing
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-37660 Make Global Temporary Tables DDL errors more specific

          • Major - Major loss of function.
          • Confirmed

          Activity

            People

              nikitamalyavin Nikita Malyavin
              Roel Roel Van de Paar
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.