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

            Activity

              People

              Assignee:
              anel Anel Husakovic
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.