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

            alice Alice Sherepa
            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.