fix for bug#16407 (Events: Changes in sql_mode won't be taken into account)

WL#1032
sql_mode setting was disregarded during create/alter event and wasn't set during
event execution.
(post-review small fixes)


sql/event.cc:
  store the sql_mode when the body is stored
  - always on create event
  - during alter event if the user changes the body
sql/event.h:
  add sql_mode as member variable
sql/event_timed.cc:
  - exchange thd->variables.sql_mode before and after execution
  - set the sql_mode of the anonymous SP -> event_timed::sphead
sql/sql_show.cc:
  - show real content in I_S.EVENTS.SQL_MODE , disallow NULL

1 files changed, 1 insertions, 1 deletions

diff --git a/sql/event.h b/sql/event.h
index 1fe5c8e5713..1092e4b85d8 100644
--- a/sql/event.h
+++ b/sql/event.h
@@ -109,7 +109,7 @@ public:
   enum enum_event_on_completion on_completion;
   enum enum_event_status status;
   sp_head *sphead;
-
+  ulong sql_mode;
   const uchar *body_begin;
   
   bool dropped;