* Alexander Nozdrin <alexander.nozdrin@stripped> [10/10/06 23:44]:
> 3097 Alexander Nozdrin 2010-10-06
> Preliminary patch for Bug#55850 (Trigger warnings not cleared).
>
> The problem was that the warnings risen by a trigger were not cleared.
> The warnings should be cleared if the trigger completes successfully.
>
> The fix is to remove "trigger warnings" after executing the trigger
> in Table_triggers_list::process_triggers().
Could you try instead to patch sp_head::execute() to not copy over
warnings to the caller's diagnostics area if we deal with a
trigger execution?
You can do it with a base class, a flag, a helper class -- your
preference.
Thank you.
--