schema s1(x:int, ya:int);
schema s2(yb:int, yc: int); -- define schema s2
table a(s1); -- define table a using schema s1
table b(s2); -- define table b using schema s1
query q1 -- define query q1 on tables a and b
`select distinct A.x as ax from a A
where NOT EXISTS (select * from b B
where (B.yb < A.ya) or (B.yb>A.ya) )`;
query q2 -- define query q2 likewise
`select distinct A.x as ax from a A
where
((select count(B.yb) from b B where B.yb=A.ya) =
(select count(B.yb) from b B))`;
verify q1 q2; -- does q1 equal to q2?
This currently returns a racket error: