• Dmitry Shulga's avatar
    MDEV-34551: Column list in the trigger definition · 9162fbe4
    Dmitry Shulga authored
    Added support of the clause `UPDATE OF <columns>` for
    BEFORE/AFTER UPDATE triggers. Triggers defined with this clause
    are fired and run actions only in case an UPDATE statement affects
    any of the listed columns. For columns not specified in the clause
    `UPDATE OF <columns>`, an UPDATE statement with such columns as
    targets don't result in running a trigger.
    
    Output of SHOW TRIGGERS isn't affected by this task. Output of
    the statement SHOW CREATE TRIGGER shows the clause `UPDATE OF <columns>`
    if it was specified on trigger creation.
    
    Tests accompany this task don't include tests that checking for cooperation of
    the statement LOAD DATA and the clause `UPDATE OF <columns>` for
    BEFORE/AFTER UPDATE triggers since the statement LOAD DATA is treated like
    the statement INSERT INTO and therefore doesn't fire BEFORE/AFTER UPDATE
    triggers.
    9162fbe4
sql_update.cc 97.2 KB