bzr commit into mysql-5.1-bugteam branch (zhou.li:2793) Bug#39526

[Leonard Zhou]

#At file:///home/zhl/mysql/rep/5.1/bug39526/

 2793 Leonard Zhou	2009-02-12
      Bug#39526 Correct sql_mode in binary log for CREATE PROCEDURE
      
      sql_mode can't correctly write into binary log when creating a procedure.
      
      restore sql_mode before write events into log file when creating a procedure.
modified:
  sql/sp.cc

per-file messages:
  sql/sp.cc
    restore sql_mode before write events into log file
=== modified file 'sql/sp.cc'
--- a/sql/sp.cc	2008-07-15 01:43:12 +0000
+++ b/sql/sp.cc	2009-02-12 10:00:21 +0000
@@ -937,6 +937,7 @@ sp_create_routine(THD *thd, int type, sp
         goto done;
       }
 
+      thd->variables.sql_mode= saved_mode;
       /* Such a statement can always go directly to binlog, no trans cache */
       thd->binlog_query(THD::MYSQL_QUERY_TYPE,
                         log_query.c_ptr(), log_query.length(), FALSE, FALSE);