1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
|
# name: test/sql/subquery/exists/test_issue_9308.test
# description: Issue #9308: wrong result: NOT EXISTS predicate with correlated non-equality comparison
# group: [exists]
statement ok
PRAGMA enable_verification
statement ok
create or replace table t1(c1 int64);
statement ok
insert into t1 values (1);
statement ok
create or replace table t2(c1 int64);
query II
select c1, not exists (select 1 from t2 where t1.c1 <= t2.c1) from t1;
----
1 true
query I
select c1 from t1 where not exists (select 1 from t2 where t1.c1 <= t2.c1);
----
1
query I
select c1 from t1 anti join t2 on (t1.c1 <= t2.c1)
----
1
|
