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

UPDATE ... ON DUPLICATE KEY

    XMLWordPrintable

Details

    Description

      SQL defines an mechanism to handle inserts if a key is duplicate on insert.

      In my opinon it is missing to do the same in case of updates. If you define unique keys, it could happen you have a manipulation which results in a duplicate key.
      There is no (good) way to handle this case. Using ignore would ignore all errors not just duplicate keys (constraints, data to long, ...)

      Attachments

        Activity

          People

            Unassigned Unassigned
            mokraemer Marc
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.