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_log_bin_trust_function_creators= @@global.log_bin_trust_function_creators;
8
drop procedure if exists p1;
9
drop procedure if exists p2;
10
drop function if exists f1;
11
drop table if exists t1,t2;
12
drop view if exists v1;
13
create table t1 (a int);
14
SET GLOBAL log_bin_trust_function_creators = 1;
17
declare spv int default 0;
19
insert into t1 values(spv+1);
24
SELECT * FROM t1 ORDER BY a;
31
SELECT * FROM t1 ORDER BY a;
40
declare a int default 4;
41
create table t2 as select a;
44
SELECT * FROM t2 ORDER BY a;
47
SELECT * FROM t2 ORDER BY a;
53
create function f1(x int) returns int
55
insert into t1 values(x);
58
create procedure p1(a int, b int)
60
declare v int default f1(5);
66
select 'this cant be';
69
call p1(f1(1), f1(2));
72
SELECT * FROM t1 ORDER BY a;
85
create table t2(a int);
86
insert into t2 values (10),(11);
87
SELECT a,f1(a) FROM t2 ORDER BY a;
91
insert into t2 select f1(3);
92
SELECT 'master:',a FROM t1 ORDER BY a;
108
SELECT 'slave:',a FROM t1 ORDER BY a;
128
insert into t2 values(1),(2);
129
create view v1 as select f1(a) as f from t2;
130
select * from v1 order by f;
134
SELECT 'master:',a FROM t1 ORDER BY a;
138
SELECT 'slave:',a FROM t1 ORDER BY a;
144
prepare s1 from 'select f1(?)';
146
execute s1 using @xx;
149
SELECT 'master:',a FROM t1 ORDER BY a;
152
SELECT 'slave:',a FROM t1 ORDER BY a;
156
create procedure p1(spv int)
158
declare c cursor for select f1(spv) from t2;
167
SELECT 'master:',a FROM t1 ORDER BY a;
173
SELECT 'slave:',a FROM t1 ORDER BY a;
182
create table t1 (a int);
183
create procedure p1()
185
insert into t1 values(@x);
187
insert into t1 values(@x);
189
insert into t1 values(1243);
192
create function f2() returns int
194
insert into t1 values(@z);
196
insert into t1 values(@z);
199
create function f1() returns int
201
insert into t1 values(@y);
213
SELECT 'master', a FROM t1 ORDER BY a;
224
SELECT 'slave', a FROM t1 ORDER BY a;
239
create table t2 (b BIT(7));
240
create procedure sp_bug26199(bitvalue BIT(7))
242
insert into t2 set b = bitvalue;
244
create function sf_bug26199(b BIT(7)) returns int
246
insert into t2 values(b);
249
call sp_bug26199(b'1110');
250
call sp_bug26199('\0');
251
select sf_bug26199(b'1111111');
252
sf_bug26199(b'1111111')
254
select sf_bug26199(b'101111111');
255
sf_bug26199(b'101111111')
258
Warning 1264 Out of range value for column 'b' at row 1
259
select sf_bug26199('\'');
262
select hex(b) from t2;
269
select hex(b) from t2;
277
drop procedure sp_bug26199;
278
drop function sf_bug26199;
279
SET @@global.log_bin_trust_function_creators= @old_log_bin_trust_function_creators;