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

duplicate CHECK constraint name

    XMLWordPrintable

Details

    Description

      CREATE TABLE t (
      		 
      path VARCHAR(100) NOT NULL COLLATE 'utf8_general_ci',
      		 
      json_c1 JSON NOT NULL DEFAULT '' COLLATE 'utf8mb4_bin',
      		 
      json_c2 JSON NOT NULL DEFAULT '' COLLATE 'utf8mb4_bin',
      		 
      comment VARCHAR(100) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
      		 
      UNIQUE INDEX path (path),
      		 
      CONSTRAINT json_c1 CHECK (path > 0)
      		 
      )
      		 
      ;
      		 
      select * from information_schema.check_constraints where table_name='t';

      another example

      create table t (a int check (a>2), constraint a check (a < 5));
      		 
      select * from information_schema.check_constraints where table_name='t';

      Attachments

        Issue Links

          blocks

          Bug - A problem which impairs or prevents the functions of the product. MDEV-30899 Fail to drop CHECK constraint

          • Major - Major loss of function.
          • In Review
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-16630 Ambiguous error message when check constraint matches table name

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24601 INFORMATION_SCHEMA doesn't differentiate between column- and table-level CHECK constraints

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24602 cannot specify a name for a column check constraint

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • In Review
          links to

          Web Link PR 2773

          Activity

            People

              serg Sergei Golubchik
              serg Sergei Golubchik
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.