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

I_S.CHECK_CONSTRAINTS, COLUMNS etc. do not show temporary tables

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Won't Fix
    • Affects Version/s: N/A
    • Fix Version/s: N/A
    • Component/s: Information Schema
    • Labels:
      None

      Description

      create temporary table ttemp (a int check(a>=0), check(a>0));
      create table tbase (b int check(b>=0), check(b>0));
       
      select table_name, table_type, temporary from information_schema.tables where table_name in ('ttemp','tbase');
      select table_name, constraint_name, level, check_clause from information_schema.check_constraints where table_name in ('ttemp','tbase');
       
      # Cleanup
      drop table tbase;
      

      preview-10.9-MDEV-20119-misc e62a2a06

      create temporary table ttemp (a int check(a>=0), check(a>0));
      create table tbase (b int check(b>=0), check(b>0));
      select table_name, table_type, temporary from information_schema.tables where table_name in ('ttemp','tbase');
      table_name	table_type	temporary
      ttemp	TEMPORARY	Y
      tbase	BASE TABLE	N
      select table_name, constraint_name, level, check_clause from information_schema.check_constraints where table_name in ('ttemp','tbase');
      table_name	constraint_name	level	check_clause
      tbase	b	Column	`b` >= 0
      tbase	CONSTRAINT_1	Table	`b` > 0
      drop table tbase;
      

      Same for I_S.COLUMNS etc.
      I'm not sure what it means given that the description in MDEV-12459 explicitly says it should work:

      2. list them in I_S.COLUMNS and other I_S tables (3) if they don't shadow non-temp tables (4)

      Maybe the concept changed later, then the description needs to be updated.

        Attachments

          Issue Links

            Activity

              People

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