• dlenev@mysql.com's avatar
    Proposed fix for bug #17764 "Trigger crashes MyISAM table" · 17785d16
    dlenev@mysql.com authored
    A table with an on insert trigger was reported as crashed when the insert
    was processed with bulk insert mode on (handler::start_bulk_insert).
    The trigger was also selecting from the same table, and that caused
    the "crash".
    The same problem was present when an insert statement, which was processed
    in bulk mode, also used a stored function that was reading the same table.
    
    This fix disables bulk inserts if a statement uses functions or invokes
    triggers. Implementing more granular checks will require much more code and
    therefore can hardly be done in 5.0
    17785d16
trigger.result 27.7 KB