drop if exists table t1;
create table t1 (
    a int,
    b int,
    c int);

insert into t1 values ( 1, 1, 10 );
insert into t1 values ( 1, 2, 20 );
insert into t1 values ( 2, 1, 5 );
insert into t1 values ( 2, 2, 42 );
insert into t1 values ( 2, 3, 42 );
insert into t1 values ( 3, 1, 1 );
insert into t1 values ( 3, 2, 65 );
insert into t1 values ( 3, 2, 12 );

drop if exists view v1;
create view v1 as
select
    a as a,
    b as b,
    sum ( c) as csum
from t1 group by a, b;

select a, b, csum from v1 where a = 3 and b = 2;

-- csum cannot not be evaluated in the view condition
-- cursor must perform a dedicated evaluation
select a, b, csum from v1 where a = 3 and b = 2 and csum = 77;

drop if exists table t1;
create table t1 (a  int, b string(10));

start transaction;
insert into t1 values ( 1, 'XXX'); 
insert into t1 values ( 1, 'XXX'); 
insert into t1 values ( 1, 'XXX'); 
-- here a double delete may occur
delete from t1;
commit;
insert into t1 values ( 1, 'XXX'); 
select * from t1;