1 include/master-slave.inc
3 SET @old_log_bin_trust_function_creators= @@global.log_bin_trust_function_creators;
4 drop procedure if exists p1;
5 drop procedure if exists p2;
6 drop function if exists f1;
7 drop table if exists t1,t2;
8 drop view if exists v1;
9 create table t1 (a int);
10 SET GLOBAL log_bin_trust_function_creators = 1;
13 declare spv int default 0;
15 insert into t1 values(spv+1);
20 SELECT * FROM t1 ORDER BY a;
27 SELECT * FROM t1 ORDER BY a;
36 declare a int default 4;
37 create table t2 as select a;
40 SELECT * FROM t2 ORDER BY a;
43 SELECT * FROM t2 ORDER BY a;
49 create function f1(x int) returns int
51 insert into t1 values(x);
54 create procedure p1(a int, b int)
56 declare v int default f1(5);
62 select 'this cant be';
65 call p1(f1(1), f1(2));
68 SELECT * FROM t1 ORDER BY a;
81 create table t2(a int);
82 insert into t2 values (10),(11);
83 SELECT a,f1(a) FROM t2 ORDER BY a;
87 insert into t2 select f1(3);
88 SELECT 'master:',a FROM t1 ORDER BY a;
104 SELECT 'slave:',a FROM t1 ORDER BY a;
124 insert into t2 values(1),(2);
125 create view v1 as select f1(a) as f from t2;
126 select * from v1 order by f;
130 SELECT 'master:',a FROM t1 ORDER BY a;
134 SELECT 'slave:',a FROM t1 ORDER BY a;
140 prepare s1 from 'select f1(?)';
142 execute s1 using @xx;
145 SELECT 'master:',a FROM t1 ORDER BY a;
148 SELECT 'slave:',a FROM t1 ORDER BY a;
152 create procedure p1(spv int)
154 declare c cursor for select f1(spv) from t2;
163 SELECT 'master:',a FROM t1 ORDER BY a;
169 SELECT 'slave:',a FROM t1 ORDER BY a;
178 create table t1 (a int);
179 create procedure p1()
181 insert into t1 values(@x);
183 insert into t1 values(@x);
185 insert into t1 values(1243);
188 create function f2() returns int
190 insert into t1 values(@z);
192 insert into t1 values(@z);
195 create function f1() returns int
197 insert into t1 values(@y);
209 SELECT 'master', a FROM t1 ORDER BY a;
220 SELECT 'slave', a FROM t1 ORDER BY a;
235 create table t2 (b BIT(7));
236 create procedure sp_bug26199(bitvalue BIT(7))
238 insert into t2 set b = bitvalue;
240 create function sf_bug26199(b BIT(7)) returns int
242 insert into t2 values(b);
245 call sp_bug26199(b'1110');
246 call sp_bug26199('\0');
247 select sf_bug26199(b'1111111');
248 sf_bug26199(b'1111111')
250 select sf_bug26199(b'101111111');
251 sf_bug26199(b'101111111')
254 Warning 1264 Out of range value for column 'b' at row 1
255 select sf_bug26199('\'');
258 select hex(b) from t2;
265 select hex(b) from t2;
273 drop procedure sp_bug26199;
274 drop function sf_bug26199;
275 SET @@global.log_bin_trust_function_creators= @old_log_bin_trust_function_creators;