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

              • Assignee:
                monty Michael Widenius
                Reporter:
                serg Sergei Golubchik
              • Votes:
                2 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: