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
drop procedure if exists p1;
8
drop procedure if exists p2;
9
drop function if exists f1;
10
drop table if exists t1,t2;
11
drop view if exists v1;
12
create table t1 (a int);
13
SET GLOBAL log_bin_trust_function_creators = 1;
16
declare spv int default 0;
18
insert into t1 values(spv+1);
23
SELECT * FROM t1 ORDER BY a;
30
SELECT * FROM t1 ORDER BY a;
39
declare a int default 4;
40
create table t2 as select a;
43
SELECT * FROM t2 ORDER BY a;
46
SELECT * FROM t2 ORDER BY a;
52
create function f1(x int) returns int
54
insert into t1 values(x);
57
create procedure p1(a int, b int)
59
declare v int default f1(5);
65
select 'this cant be';
68
call p1(f1(1), f1(2));
71
SELECT * FROM t1 ORDER BY a;
84
create table t2(a int);
85
insert into t2 values (10),(11);
86
SELECT a,f1(a) FROM t2 ORDER BY a;
90
insert into t2 select f1(3);
91
SELECT 'master:',a FROM t1 ORDER BY a;
107
SELECT 'slave:',a FROM t1 ORDER BY a;
127
insert into t2 values(1),(2);
128
create view v1 as select f1(a) as f from t2;
129
select * from v1 order by f;
133
SELECT 'master:',a FROM t1 ORDER BY a;
137
SELECT 'slave:',a FROM t1 ORDER BY a;
143
prepare s1 from 'select f1(?)';
145
execute s1 using @xx;
148
SELECT 'master:',a FROM t1 ORDER BY a;
151
SELECT 'slave:',a FROM t1 ORDER BY a;
155
create procedure p1(spv int)
157
declare c cursor for select f1(spv) from t2;
166
SELECT 'master:',a FROM t1 ORDER BY a;
172
SELECT 'slave:',a FROM t1 ORDER BY a;
181
create table t1 (a int);
182
create procedure p1()
184
insert into t1 values(@x);
186
insert into t1 values(@x);
188
insert into t1 values(1243);
191
create function f2() returns int
193
insert into t1 values(@z);
195
insert into t1 values(@z);
198
create function f1() returns int
200
insert into t1 values(@y);
212
SELECT 'master', a FROM t1 ORDER BY a;
223
SELECT 'slave', a FROM t1 ORDER BY a;