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

"AFTER UPDATE" trigger does not fire when duplicate inserted with "ON DUPLICATE KEY UPDATE"

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.6.16, 11.0.4
    • 10.5, 10.6, 10.11
    • None
    • None

    Description

      According to https://mariadb.com/kb/en/trigger-overview/ - the following triggers should fire when an ON DUPLICATE KEY insert is used and a duplicate is detected:

      BEFORE INSERT;
      BEFORE UPDATE;
      AFTER UPDATE.

      We're seeing that the AFTER UPDATE trigger never fires when a duplicate row is inserted. See attached test case and output.

      Tested on 10.6.16 and 11.0.4

      Attachments

        Activity

          People

            wlad Vladislav Vaintroub
            psumner Phil Sumner
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.