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

SHOW FULL TABLE vs information_schema.tables

Details

    Description

      Why a different table_type there ?

      MariaDB [pmacontrol]> SHOW FULL TABLES like 'mysql_server';
      +-------------------------------------+------------+
      | Tables_in_pmacontrol (mysql_server) | Table_type |
      +-------------------------------------+------------+
      | mysql_server                        | BASE TABLE |
      +-------------------------------------+------------+
      1 row in set (0,000 sec)
       
      MariaDB [pmacontrol]> select TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE from information_schema.tables where table_name ='mysql_server';
      +--------------+--------------+------------------+
      | TABLE_SCHEMA | TABLE_NAME   | TABLE_TYPE       |
      +--------------+--------------+------------------+
      | pmacontrol   | mysql_server | SYSTEM VERSIONED |
      +--------------+--------------+------------------+
      1 row in set (0,001 sec)
       
      MariaDB [pmacontrol]> select version();
      +---------------------------------------------+
      | version()                                   |
      +---------------------------------------------+
      | 10.11.7-MariaDB-1:10.11.7+maria~ubu2204-log |
      +---------------------------------------------+
      1 row in set (0,000 sec)
      

      Attachments

        Activity

          Looks like an omission, indeed. I'd expect values to be the same.

          But now, when it was done six years ago in 10.0.1, shall we fix it? Or shall we say "it's a non-standard command, it doesn't have to show standard values, so we keep it the old way for backward compatibility"?

          Do you have a preference?

          serg Sergei Golubchik added a comment - Looks like an omission, indeed. I'd expect values to be the same. But now, when it was done six years ago in 10.0.1, shall we fix it? Or shall we say "it's a non-standard command, it doesn't have to show standard values, so we keep it the old way for backward compatibility"? Do you have a preference?

          Yeah not so many people use system versionING and less who make a show full table on it.

          In fact it's make my tool of monitoring failed in a special particular case that why. (and first time i got it in several year with versioned table)

          Aurelien_LEQUOY Aurélien LEQUOY added a comment - Yeah not so many people use system versionING and less who make a show full table on it. In fact it's make my tool of monitoring failed in a special particular case that why. (and first time i got it in several year with versioned table)

          I think, it's come from 10.5 (2021) not so old . By the way on documentation you should add from witch version this feature happen it's really usefull.

          Aurelien_LEQUOY Aurélien LEQUOY added a comment - I think, it's come from 10.5 (2021) not so old . By the way on documentation you should add from witch version this feature happen it's really usefull.

          People

            serg Sergei Golubchik
            Aurelien_LEQUOY Aurélien LEQUOY
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.