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

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-23507 Wrong duplicate key value printed in ER_DUP_ENTRY

          • Major - Major loss of function.
          • Open

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              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.