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

Wrong warning on duplicate keys

    XMLWordPrintable

Details

    Description

      See the attached simple table.
      Adding a primary index on the table via

      ALTER TABLE `test` ADD PRIMARY KEY(`ID`);
      

      results in
      ERROR 1062 (23000): Duplicate entry '34843' for key 'PRIMARY'

      which is totally wrong - the key which is duplicate is 16564 and 16741

      This is totally misleading.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              mokraemer Marc
              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.