1
-- source include/not_embedded.inc
2
-- source include/have_innodb.inc
5
drop table if exists t1;
8
SET @old_log_bin_trust_function_creators= @@global.log_bin_trust_function_creators;
10
connect (a,localhost,root,,);
11
connect (b,localhost,root,,);
15
# BUG#11238 - in prelocking mode SELECT .. FOR UPDATE is changed to
18
SET GLOBAL log_bin_trust_function_creators = 1;
19
create table t1 (col1 integer primary key, col2 integer) engine=innodb;
20
insert t1 values (1,100);
22
create function f1 () returns integer begin
24
select col2 into var1 from t1 where col1=1 for update;
31
send update t1 set col2=0 where col1=1;
43
--source include/wait_until_disconnected.inc
46
--source include/wait_until_disconnected.inc
50
SET @@global.log_bin_trust_function_creators= @old_log_bin_trust_function_creators;