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

CHECK_CLAUSE field in INFORMATION_SCHEMA.CHECK_CONSTRAINTS truncate check constraints expressions

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

            Transition Time In Source Status Execution Times
            Vicențiu Ciorbaru made transition -
            Open In Progress
            17d 23h 28m 1
            Vicențiu Ciorbaru made transition -
            In Progress In Review
            10s 1
            Anel Husakovic made transition -
            Stalled In Review
            6d 17h 41m 1
            Daniel Black made transition -
            In Review Stalled
            2d 4h 23m 2
            Anel Husakovic made transition -
            Stalled Closed
            5d 1h 15m 1

            People

              anel Anel Husakovic
              anvolka Anastasiya Volkova
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.