2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
7
SET @old_sql_mode= @@global.sql_mode;
8
SET @old_binlog_format=@@session.binlog_format;
9
SET SESSION sql_mode=8;
12
CREATE TABLE t1 (id INT);
13
CREATE PROCEDURE testProc() SELECT * FROM t1;
14
CREATE VIEW testView as SELECT * from t1;
15
CREATE FUNCTION testFunc()
20
CREATE TRIGGER testTrig BEFORE INSERT ON t1
22
UPDATE t1 SET id = id +1;
24
CREATE EVENT testEvent ON SCHEDULE
28
UPDATE t1 SET id = id +1;
32
(@a:=load_file("MYSQLTEST_VARDIR/tmp/mysqlbinlog_bug39526.binlog"))
34
(@a:=load_file("MYSQLTEST_VARDIR/tmp/mysqlbinlog_bug39526.binlog"))
37
*** String sql_mode=0 is found: 0 ***
39
DROP PROCEDURE testProc;
40
DROP FUNCTION testFunc;
41
DROP TRIGGER testTrig;
45
SET @@global.sql_mode= @old_sql_mode;
46
SET @@session.binlog_format=@old_binlog_format;