blob: 8c62d673674daf12c81d06fca470baf581a62f07 [file] [log] [blame]
-- scalar aggregate in not exists returns NULL value
-- with correlation to outer table
select
*
from
t1
where
not exists
(
select
max(a2)+100
from
t2
where
a2 > 10000
)
order by
1
;