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

multiple triggers per table

    XMLWordPrintable

Details

    Description

      Many triggers for the same event per table (e.g. many BEFORE DELETE triggerts).
      This can be ported from 5.7

      Looked at the MySQL 5.7 implementation. Too complex and too many not needed changed and moving of things to different files that make it very hard to follow code changes over time.

      Will do this with new code, but will take test cases from MySQL 5.7

      New functionality:

      • "Any" amount of same events
      • New syntax with { FOLLOWS | PRECEDES } trigger_name

        CREATE [OR REPLACE]
        [DEFINER = { user | CURRENT_USER }]
        TRIGGER [IF NOT EXISTS] trigger_name trigger_time trigger_event
        ON tbl_name FOR EACH ROW
        [{ FOLLOWS | PRECEDES }

        other_trigger_name ]
        trigger_stmt

      Attachments

        Issue Links

          Activity

            People

              monty Michael Widenius
              serg Sergei Golubchik
              Votes:
              2 Vote for this issue
              Watchers:
              4 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.