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

CHECK_CLAUSE field in INFORMATION_SCHEMA.CHECK_CONSTRAINTS truncate check constraints expressions

    XMLWordPrintable

    Details

      Description

      Hello.
      To get information from the database about the check constraints available in the tables, in DBeaver} we use this expression:
      SELECT cc.CONSTRAINT_NAME, cc.CHECK_CLAUSE FROM INFORMATION_SCHEMA.CHECK_CONSTRAINTS cc

      And it seems the number of characters in the CHECK_CLAUSE field is limited (64?).
      Therefore, long expressions (like start_date IS NULL OR end_date IS NULL OR start_date<end_date)) are truncated.

      This creates some inconvenience when working with data for our users.

      We use SHOW CREATE TABLE to get tables DDL, but pulling the constraint expression out of there is difficult.

      Are there any other alternative solutions for this problem?

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              anel Anel Husakovic
              Reporter:
              anvolka Anastasiya Volkova
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration