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

              Assignee:
              Unassigned Unassigned
              Reporter:
              mokraemer Marc
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration