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

SHOW TABLES LIKE shows temporary tables with non-matching names

Details

    Description

      In MariaDB 11.2.2, SHOW TABLES LIKE '...' can show temporary tables with names that do not match the pattern. (I haven't fully figured out yet whether it always shows all temporary tables regardless of name and pattern, or whether they are sometimes not shown after all. But it seems to show them a lot of the time.)

      To reproduce on a fresh install:

      CREATE DATABASE db; USE db;
      		 
      CREATE TABLE realtable (a INT); CREATE TEMPORARY TABLE temptable (a INT);
      		 
      SHOW TABLES LIKE 'faketable';

      Expected result: 0 rows; actual result: 1 row, "temptable".

      Can be tested using the official Docker images; an interactive shell can be obtained with commands like the following:

      docker run --rm --env MARIADB_ROOT_PASSWORD=root --name=T352695 mariadb:11.2.2
      		 
      docker exec -it T352695 mariadb -uroot -proot

      For the record, we're tracking this at Wikimedia as T352695, though I don't think there's any information useful for MariaDB devs over there.

      MDEV-28334 is the closest-feeling existing issue I'm aware of (but probably not the same).

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28334 SHOW TABLE STATUS shows all temporary tables ignoring database and conditions

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28453 SHOW commands are inconsistent for temporary tables

          • Major - Major loss of function.
          • Closed
          links to

          Web Link PR 2911

          Activity

            Ascending order - Click to sort in descending order
            lucaswerkmeister Lucas Werkmeister added a comment -

            (I left the priority at the default value – no idea if this should actually be Major or not. Component/s is just a best guess too.)

            lucaswerkmeister Lucas Werkmeister added a comment - (I left the priority at the default value – no idea if this should actually be Major or not. Component/s is just a best guess too.)
            sergeiku Sergei Kulakov added a comment - - edited

            I confirm the bug on Windows 8.1, version 11.3.2.
            Both
            Show Tables Like ...
            and
            Show Table Status Like ...
            have the problem. They just add all existing at the moment temporary tables to the resulting list without checking conditions.

            sergeiku Sergei Kulakov added a comment - - edited I confirm the bug on Windows 8.1, version 11.3.2. Both Show Tables Like ... and Show Table Status Like ... have the problem. They just add all existing at the moment temporary tables to the resulting list without checking conditions.
            sergeiku Sergei Kulakov added a comment -

            So, in order to get the fixed version, I should wait for a next release?

            sergeiku Sergei Kulakov added a comment - So, in order to get the fixed version, I should wait for a next release?
            serg Sergei Golubchik added a comment -

            Yes. It should happen soon, see the release road map at https://jira.mariadb.org
            (but it's only a plan, whether we'll actually release on that date or will be late by a few days depends on many factors, some of them are beyond our control)

            serg Sergei Golubchik added a comment - Yes. It should happen soon, see the release road map at https://jira.mariadb.org (but it's only a plan, whether we'll actually release on that date or will be late by a few days depends on many factors, some of them are beyond our control)
            sergeiku Sergei Kulakov added a comment -

            Thank you. Strangely, 11.3 is not on the list : )

            sergeiku Sergei Kulakov added a comment - Thank you. Strangely, 11.3 is not on the list : )
            serg Sergei Golubchik added a comment -

            See https://mariadb.org/adjusting-release-model/ — there will be no 11.3.3, the upgrade path is 11.3.2→11.4.2

            serg Sergei Golubchik added a comment - See https://mariadb.org/adjusting-release-model/ — there will be no 11.3.3, the upgrade path is 11.3.2→11.4.2
            lucaswerkmeister Lucas Werkmeister added a comment -

            Can confirm the issue seems fixed on MariaDB 11.4.2. 🎉

            lucaswerkmeister Lucas Werkmeister added a comment - Can confirm the issue seems fixed on MariaDB 11.4.2. 🎉
            sergeiku Sergei Kulakov added a comment - - edited

            Looks like Maria doesn't support Windows 8.1 any more (can't test).

            sergeiku Sergei Kulakov added a comment - - edited Looks like Maria doesn't support Windows 8.1 any more (can't test).

            People

              serg Sergei Golubchik
              lucaswerkmeister Lucas Werkmeister
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.