Debian Codegraph @

mysql-test/suite/binlog/r/binlog_sql_mode.result

raw
1 SET @old_sql_mode= @@global.sql_mode;
2 SET @old_binlog_format=@@session.binlog_format;
3 SET SESSION sql_mode=8;
4 Initialization
5 RESET MASTER;
6 CREATE TABLE t1 (id INT);
7 CREATE PROCEDURE testProc() SELECT * FROM t1;
8 CREATE VIEW testView as SELECT * from t1;
9 CREATE FUNCTION testFunc()
10 RETURNS INT
11 BEGIN
12 return 1;
13 END;|
14 CREATE TRIGGER testTrig BEFORE INSERT ON t1
15 FOR EACH ROW BEGIN
16 UPDATE t1 SET id = id +1;
17 END;|
18 CREATE EVENT testEvent ON SCHEDULE
19 EVERY 1 DAY
20 DO
21 BEGIN
22 UPDATE t1 SET id = id +1;
23 END;|
24 Warnings:
25 Warning 1105 Event scheduler is switched off, use SET GLOBAL event_scheduler=ON to enable it.
26 Check Result
27 select
28 (@a:=load_file("MYSQLTEST_VARDIR/tmp/mysqlbinlog_bug39526.binlog"))
29 is not null;
30 (@a:=load_file("MYSQLTEST_VARDIR/tmp/mysqlbinlog_bug39526.binlog"))
31 is not null
32 1
33 *** String sql_mode=0 is found: 0 ***
34 Clean Up
35 DROP PROCEDURE testProc;
36 DROP FUNCTION testFunc;
37 DROP TRIGGER testTrig;
38 DROP EVENT testEvent;
39 DROP VIEW testView;
40 DROP TABLE t1;
41 SET @@global.sql_mode= @old_sql_mode;
42 SET @@session.binlog_format=@old_binlog_format;
43
44 #
45 # Test for Bug#12601974 - STORED PROCEDURE SQL_MODE=NO_BACKSLASH_ESCAPES
46 # IGNORED AND BREAKS REPLICATION
47 #
48 DROP DATABASE IF EXISTS mysqltest_db;
49 DROP TABLE IF EXISTS test_table;
50 CREATE DATABASE mysqltest_db;
51 USE mysqltest_db;
52 CREATE TABLE test_table (c1 CHAR(50));
53 SET @org_mode=@@sql_mode;
54 SET @@sql_mode='';
55 CREATE PROCEDURE proc_without_sql_mode (IN param1 CHAR(50), IN param2 CHAR(50))
56 BEGIN
57 DECLARE var1 CHAR(50) DEFAULT param1;
58 DECLARE var2 CHAR(50) DEFAULT param2;
59 DECLARE var3 CHAR(50) DEFAULT 'abcd\bef';
60 DECLARE var4 CHAR(50) DEFAULT 'abcd\nef';
61 DECLARE var5 CHAR(50) DEFAULT 'abcd\ref';
62 DECLARE var6 CHAR(50) DEFAULT 'abcd\tef';
63 DECLARE var7 CHAR(50) DEFAULT 'abcd\\ef';
64 DECLARE var8 CHAR(50) DEFAULT 'abcd\%ef';
65 DECLARE var9 CHAR(50) DEFAULT 'abcd\_ef';
66 INSERT INTO test_table VALUES (var1);
67 INSERT INTO test_table VALUES (var2);
68 INSERT INTO test_table VALUES (var3);
69 INSERT INTO test_table VALUES (var4);
70 INSERT INTO test_table VALUES (var5);
71 INSERT INTO test_table VALUES (var6);
72 INSERT INTO test_table VALUES (var7);
73 INSERT INTO test_table VALUES (var8);
74 INSERT INTO test_table VALUES (var9);
75 END
76 $
77 SET @@sql_mode='NO_BACKSLASH_ESCAPES'$
78 CREATE PROCEDURE proc_with_sql_mode (IN param1 CHAR(50), IN param2 CHAR(50))
79 BEGIN
80 DECLARE var1 CHAR(50) DEFAULT param1;
81 DECLARE var2 CHAR(50) DEFAULT param2;
82 DECLARE var3 CHAR(50) DEFAULT 'wxyz\bef';
83 DECLARE var4 CHAR(50) DEFAULT 'wxyz\nef';
84 DECLARE var5 CHAR(50) DEFAULT 'wxyz\ref';
85 DECLARE var6 CHAR(50) DEFAULT 'wxyz\tef';
86 DECLARE var7 CHAR(50) DEFAULT 'wxyz\\ef';
87 DECLARE var8 CHAR(50) DEFAULT 'wxyz\%ef';
88 DECLARE var9 CHAR(50) DEFAULT 'wxyz\_ef';
89 INSERT INTO test_table VALUES (var1);
90 INSERT INTO test_table VALUES (var2);
91 INSERT INTO test_table VALUES (var3);
92 INSERT INTO test_table VALUES (var4);
93 INSERT INTO test_table VALUES (var5);
94 INSERT INTO test_table VALUES (var6);
95 INSERT INTO test_table VALUES (var7);
96 INSERT INTO test_table VALUES (var8);
97 INSERT INTO test_table VALUES (var9);
98 END
99 $
100 SET @@sql_mode='';
101 CALL proc_without_sql_mode('abcd\'ef', 'abcd\"ef');
102 CALL proc_with_sql_mode('wxyz\'ef', 'wxyz\"ef');
103 SELECT * FROM test_table;
104 c1
105 abcd'ef
106 abcd"ef
107 abcdef
108 abcd
109 ef
110 abcd ef
111 abcd ef
112 abcd\ef
113 abcd\%ef
114 abcd\_ef
115 wxyz'ef
116 wxyz"ef
117 wxyz\bef
118 wxyz\nef
119 wxyz\ref
120 wxyz\tef
121 wxyz\\ef
122 wxyz\%ef
123 wxyz\_ef
124 "Dropping table test_table"
125 DROP TABLE test_table;
126 #"test_table" content after replaying the binlog
127 SELECT * FROM test_table;
128 c1
129 abcd'ef
130 abcd"ef
131 abcdef
132 abcd
133 ef
134 abcd ef
135 abcd ef
136 abcd\ef
137 abcd\%ef
138 abcd\_ef
139 wxyz'ef
140 wxyz"ef
141 wxyz\bef
142 wxyz\nef
143 wxyz\ref
144 wxyz\tef
145 wxyz\\ef
146 wxyz\%ef
147 wxyz\_ef
148 #Clean up
149 DROP DATABASE mysqltest_db;
150 SET @@sql_mode= @org_mode;
151 use test;
152
153 #End of Test for Bug#12601974