assert   
    1000
    select c1.cust_no
    from customer c1
    where exists (
    select 1 from sales s1 where s1.cust_no = c1.cust_no and s1.qty_ordered > 10
    )
    Check unnesting of single EXISTS
    Select Expression
    ....-> Filter
    ........-> Hash Join (semi)
    ............-> Table "CUSTOMER" as "C1" Full Scan
    ............-> Record Buffer (record length: NN)
    ................-> Filter
    ....................-> Table "SALES" as "S1" Full Scan
    2000
    select c2.cust_no
    from customer c2
    where c2.cust_no = any (
    select s2.cust_no
    from sales s2
    where s2.qty_ordered > 10
    )
    Check unnesting of ANY
    Select Expression
    ....-> Filter
    ........-> Hash Join (semi)
    ............-> Table "CUSTOMER" as "C2" Full Scan
    ............-> Record Buffer (record length: NN)
    ................-> Filter
    ....................-> Table "SALES" as "S2" Full Scan
    3000
    select c3.cust_no
    from customer c3
    where exists (
    select  s3.cus

[...SKIPPED...]

D
2026-03-25 08:38:52.422 E           ................-> Bitmap
2026-03-25 08:38:52.431 E           ....................-> Index "EMPLOYEE_PK" Unique Scan
2026-03-25 08:38:52.438 E           Select Expression
2026-03-25 08:38:52.446 E           ....-> Filter
2026-03-25 08:38:52.454 E           ........-> Hash Join (semi)
2026-03-25 08:38:52.467 E           ............-> Table "CUSTOMER" as "C4" Full Scan
2026-03-25 08:38:52.479 E           ............-> Record Buffer (record length: NN)
2026-03-25 08:38:52.488 E           ................-> Filter
2026-03-25 08:38:52.497 E           ....................-> Table "SALES" as "S4" Full Scan
2026-03-25 08:38:52.505
2026-03-25 08:38:52.513 tests/bugs/gh_8061_test.py:306: AssertionError
2026-03-25 08:38:52.521 ---------------------------- Captured stdout setup -----------------------------
2026-03-25 08:38:52.531 Creating db: localhost:/var/tmp/qa_2024/test_11651/test.fdb [page_size=None, sql_dialect=None, charset='NONE', user=SYSDBA, password=masterkey]