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

INFORMATION_SCHEMA doesn't differentiate between column- and table-level CHECK constraints

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5
    • 10.5.10
    • Server
    • None

    Description

      perhaps an appropriate I_S.check_constraints table needs a column, like LEVEL ENUM('COLUMN','TABLE') or a column COLUMN with the column name of the constraint or NULL for table-level constraints.

      Attachments

        Issue Links

          Activity

            Hi wlad, serg can you please review patch 2784900c4b4cf6

            anel Anel Husakovic added a comment - Hi wlad , serg can you please review patch 2784900c4b4cf6

            Hi wlad, is the review finished, just to drop binlog results not related to change?
            Regarding realistic test case, I needed just to way to check for field/table constraints, and used ints for that purpose.

            anel Anel Husakovic added a comment - Hi wlad , is the review finished, just to drop binlog results not related to change? Regarding realistic test case, I needed just to way to check for field/table constraints, and used ints for that purpose.

            Hi wlad. I have updated the patch with 8189b706. Here is the buildbot, where single failure in ps-protocol I'm not sure about>
            ps-protocol-test-case-innodb.innodb_stats (locally it is working innodb.innodb_stats ).
            Can you please confirm this so I can push?

            anel Anel Husakovic added a comment - Hi wlad . I have updated the patch with 8189b706 . Here is the buildbot , where single failure in ps-protocol I'm not sure about> ps-protocol-test-case-innodb.innodb_stats (locally it is working innodb.innodb_stats ). Can you please confirm this so I can push?

            anel, this looks good to me. I guess you can push. Ignore innodb_stats failure, that single sporadic failure is not your fault.

            wlad Vladislav Vaintroub added a comment - anel , this looks good to me. I guess you can push. Ignore innodb_stats failure, that single sporadic failure is not your fault.

            Pushed to 10.5 with commit 825c0e2ab. Thanks wlad.

            anel Anel Husakovic added a comment - Pushed to 10.5 with commit 825c0e2ab . Thanks wlad .

            People

              anel Anel Husakovic
              serg Sergei Golubchik
              Votes:
              1 Vote for this issue
              Watchers:
              6 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.