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

TABLE_TYPE for temporary sequences is the same as for permanent ones

    XMLWordPrintable

Details

    Description

      MDEV-12459 introduced table_type TEMPORARY for temporary tables. However, for temporary sequences I_S.TABLES shows the generic SEQUENCE, same as for normal sequences.
      They are still distinguishable via TEMPORARY column in I_S.TABLES, but it appears inconsistent, and besides there is a discussion in MDEV-12459 about removing the column.

      create sequence s;
      		 
      create temporary sequence s;
      		 
      select table_name, table_type, temporary from information_schema.tables where table_name = 's';
      		 
       
      		 
      # Cleanup
      		 
      drop sequence s;
      		 
      drop sequence s;

      preview-10.9-MDEV-20119-misc c906db30

      		 
      select table_name, table_type, temporary from information_schema.tables where table_name = 's';
      		 
      table_name	table_type	temporary
      		 
      s	SEQUENCE	Y
      		 
      s	SEQUENCE	N

      Attachments

        Issue Links

          is caused by

          Task - A task that needs to be done. MDEV-12459 The information_schema tables for getting temporary tables info is missing, at least for innodb there is no INNODB_TEMP_TABLE_INFO

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

          Activity

            People

              anel Anel Husakovic
              elenst Elena Stepanova
              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.