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

update trigger don't fire on "replace"

    XMLWordPrintable

    Details

      Description

      This maybe is by design, but it is conceptually a bug.
      A "replace" can be an insert or an update, and all update trigger must fire, but they are ignored. This problem makes it more cumbersome to write logic that catches what to do when existing data is there.
      Please consider extending update triggers to the statement "replace" when the primary key is there already.

        Attachments

          Activity

            People

            Assignee:
            alice Alice Sherepa
            Reporter:
            philip_38 Philip orleans
            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.