Save and clear run context before executing a stored function or trigger and restore it afterwards.

This allows us to use statement replication with functions and triggers
The following things are fixed with this patch:
- NOW() and automatic timestamps takes the value from the main event for functions and triggers (which allows these to replicate with statement level logging)
- No side effects for triggers or functions with auto-increment values(), last_insert_id(), rand() or found_rows()
- Triggers can't return result sets

Fixes bugs:
#12480: NOW() is not constant in a trigger
#12481: Using NOW() in a stored function breaks statement based replication
#12482: Triggers has side effects with auto_increment values
#11587: trigger causes lost connection error

1 files changed, 3 insertions, 3 deletions

diff --git a/mysql-test/t/sp-error.test b/mysql-test/t/sp-error.test
index 349bd148814..85b81f72f40 100644
--- a/mysql-test/t/sp-error.test
+++ b/mysql-test/t/sp-error.test
@@ -811,19 +811,19 @@ end|
 #
 
 # Some things are caught when parsing
---error ER_SP_NO_RETSET_IN_FUNC
+--error ER_SP_NO_RETSET
 create function bug8408() returns int
 begin
   select * from t1;
   return 0;
 end|
---error ER_SP_NO_RETSET_IN_FUNC
+--error ER_SP_NO_RETSET
 create function bug8408() returns int
 begin
   show warnings;
   return 0;
 end|
---error ER_SP_NO_RETSET_IN_FUNC
+--error ER_SP_NO_RETSET
 create function bug8408(a int) returns int
 begin
   declare b int;