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

CHECK constraints are not shown in I_S.TABLE_CONSTRAINTS

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.2
    • Fix Version/s: 10.2.5
    • Component/s: OTHER
    • Labels:
    • Sprint:
      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

              • Assignee:
                jacob-mathew Jacob Mathew (Inactive)
                Reporter:
                elenst Elena Stepanova
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: