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

          is part of

          Epic - Created by Jira Software - do not edit or delete. Issue type for a big user story that needs to be broken down. MDEV-10137 Providing compatibility to other databases

          • Major - Major loss of function.
          • Open
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-10915 Multiple triggers are not counted in Executed_triggers status variable

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-10916 In trigger's CREATED time microseconds are misinterpreted

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-10924 CREATE OR REPLACE TRIGGER which fails on PRECEDES/FOLLOWS drops the trigger, but isn't written to binlog; replication fails

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-10926 Extra dot (period) in the error text for ER_REFERENCED_TRG_DOES_NOT_EXIST

          • Trivial - Cosmetic problem like misspelt words or misaligned text.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-10930 FOLLOWS in lex.h is out of alphabetical order

          • Trivial - Cosmetic problem like misspelt words or misaligned text.
          • Closed

          Task - A task that needs to be done. MDEV-10911 Make SHOW TRIGGERS to show triggers' action order

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11033 "follows" does not show up in "show create trigger" output

          • Major - Major loss of function.
          • Closed

          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.