- sql: |
    create table t1(t1v1 int, t1v2 int);
    create table t2(t2v1 int, t2v3 int);
    create table t3(t3v2 int, t3v4 int);
  tasks:
    - execute[use_df_logical]
# - sql: |
#     select * from t1 where t1v1 in (select t2v1 from t2);
#   desc: Test whether the optimizer can unnest "in" subqueries. -- failing with unsupported expression
#   tasks:
#     - explain_logical
- sql: |
    select * from t1 where (select sum(t2v3) from t2 where t2v1 = t1v1) > 100;
  desc: Test whether the optimizer can unnest correlated subqueries.
  tasks:
    - explain[verbose]:logical_optd,optimized_logical_optd,physical_optd
- sql: |
    select * from t1 where (select sum(t2v3) from (select * from t2, t3 where t2v1 = t1v1 and t2v3 = t3v2)) > 100;
  desc: Test whether the optimizer can unnest correlated subqueries.
  tasks:
    - explain[verbose]:logical_optd,optimized_logical_optd,physical_optd