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

CHECK constraints are not shown in I_S.TABLE_CONSTRAINTS

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.2(EOL)
    • 10.2.5
    • OTHER
    • 10.2.6-2, 10.2.6-3

    Description

      MySQL documentation mentions that CHECK constraints should be shown in I_S.TABLE_CONSTRAINTS when they are supported:
      http://dev.mysql.com/doc/refman/5.5/en/table-constraints-table.html

      I suppose it should be so in MariaDB, too.
      However, MariaDB documentation does not say that (https://mariadb.com/kb/en/mariadb/information-schema-table_constraints-table/), and the constraints are not returned by the I_S table:

      MariaDB [test]> create table t1 (a int, check(a>0));
      Query OK, 0 rows affected (0.49 sec)
       
      MariaDB [test]> select * from information_schema.table_constraints where table_name = 't1';
      Empty set (0.00 sec)
      

      Attachments

        Issue Links

          Activity

            People

              jacob-mathew Jacob Mathew (Inactive)
              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.