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

duplicate CHECK CONSTRAINTs

Details

    • 10.2.2-3, 10.2.2-1, 10.2.2-2

    Description

      ALTER ... ADD CONSTRAINT IF NOT EXISTS does not work. Also it seems that one can create multiple constraints with the same name, both using ALTER TABLE and even CREATE TABLE.

      Attachments

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-10473 Duplicate constraint names

          • Major - Major loss of function.
          • Closed
          is part of

          Epic - Created by Jira Software - do not edit or delete. Issue type for a big user story that needs to be broken down. MDEV-10137 Providing compatibility to other databases

          • Major - Major loss of function.
          • Open

          Activity

            Ascending order - Click to sort in descending order
            serg Sergei Golubchik created issue -
            ratzpo Rasmus Johansson (Inactive) made changes -
            Field Original Value New Value
            Sprint 10.2.2-3 [ 83 ]
            holyfoot Alexey Botchkov made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            holyfoot Alexey Botchkov added a comment -

            http://lists.askmonty.org/pipermail/commits/2016-July/009580.html

            holyfoot Alexey Botchkov added a comment - http://lists.askmonty.org/pipermail/commits/2016-July/009580.html
            holyfoot Alexey Botchkov made changes -
            Assignee Alexey Botchkov [ holyfoot ] Sergei Golubchik [ serg ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ] Alexey Botchkov [ holyfoot ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.2-3 [ 83 ] 10.2.2-3, 10.2.2-1 [ 83, 89 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked higher
            holyfoot Alexey Botchkov made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            holyfoot Alexey Botchkov added a comment -

            http://lists.askmonty.org/pipermail/commits/2016-August/009713.html

            holyfoot Alexey Botchkov added a comment - http://lists.askmonty.org/pipermail/commits/2016-August/009713.html
            holyfoot Alexey Botchkov made changes -
            Assignee Alexey Botchkov [ holyfoot ] Sergei Golubchik [ serg ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.2-3, 10.2.2-1 [ 83, 89 ] 10.2.2-3, 10.2.2-1, 10.2.2-2 [ 83, 89, 92 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked lower
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ] Alexey Botchkov [ holyfoot ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            alvinr Alvin Richards (Inactive) made changes -
            Labels Compatibility
            monty Michael Widenius made changes -
            holyfoot Alexey Botchkov made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            holyfoot Alexey Botchkov made changes -
            issue.field.resolutiondate 2016-09-06 10:58:26.0 2016-09-06 10:58:26.016
            holyfoot Alexey Botchkov made changes -
            Component/s Parser [ 10201 ]
            Fix Version/s 10.2.4 [ 22116 ]
            Fix Version/s 10.2 [ 14601 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            holyfoot Alexey Botchkov made changes -
            Fix Version/s 10.2.2 [ 22013 ]
            Fix Version/s 10.2.4 [ 22116 ]
            alvinr Alvin Richards (Inactive) made changes -
            Sprint 10.2.2-3, 10.2.2-1, 10.2.2-2 [ 83, 89, 92 ] 10.2.2-1, 10.2.2-2 [ 89, 92 ]
            alvinr Alvin Richards (Inactive) made changes -
            Sprint 10.2.2-1, 10.2.2-2 [ 89, 92 ] 10.2.2-3, 10.2.2-1, 10.2.2-2 [ 83, 89, 92 ]
            alvinr Alvin Richards (Inactive) made changes -
            Labels Compatibility Compatibility NRE-307517
            alvinr Alvin Richards (Inactive) made changes -
            NRE Projects NRE-307517
            alvinr Alvin Richards (Inactive) made changes -
            Labels Compatibility NRE-307517 Compatibility
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 76474 ] MariaDB v4 [ 150656 ]

            People

              holyfoot Alexey Botchkov
              serg Sergei Golubchik
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.