1
# This test demonstrates how the flag OPTION_STATUS_NO_TRANS_UPDATE is
2
# not correctly reset, and leads to an incorrect warning
7
drop table if exists t4|
10
a mediumint(8) unsigned not null auto_increment,
11
b smallint(5) unsigned not null,
14
) engine=myisam default charset=latin1|
15
insert into t4 values (1, 2, 'oneword')|
16
insert into t4 values (2, 2, 'anotherword')|
19
drop table if exists t3|
22
create table t3 ( x int unique ) engine=pbxt|
24
create procedure bug7049_1()
26
insert into t3 values (42);
27
insert into t3 values (42);
30
create procedure bug7049_2()
32
declare exit handler for sqlexception
33
select 'Caught it' as 'Result';
36
select 'Missed it' as 'Result';
39
create function bug7049_1()
42
insert into t3 values (42);
43
insert into t3 values (42);
47
create function bug7049_2()
50
declare x int default 0;
51
declare continue handler for sqlexception
58
# This cause the following warning:
59
# Warning 1196: Some non-transactional changed tables couldn't be rolled back
60
# which is not correct
61
# PMC - This bug was fixed in 5.1.12 (confirmed 2006-9-15).
64
drop procedure bug7049_1|
65
drop function bug7049_1|
66
drop procedure bug7049_2|
67
drop function bug7049_2|