• Staale Smedseng's avatar
    Bug#39953 Triggers are not working properly with multi table · fce11a8b
    Staale Smedseng authored
    updates
    
    Attempt to execute trigger or stored function with multi-UPDATE
    which used - but didn't update - a table that was also used by
    the calling statement led to an error. Read-only reference to
    tables used in the calling statement should be allowed.
     
    This problem was caused by the fact that check for conflicting
    use of tables in SP/triggers was performed in open_tables(),
    and in case of multi-UPDATE we didn't know exact lock type at
    this stage.
    
    We solve the problem by moving this check to lock_tables(), so
    it can be performed after exact lock types for tables used by
    multi-UPDATE are determined.
    fce11a8b
sql_base.cc 198 KB