- sql: |
    create table t1(a int, b int);
    create table t2(c int, d int);
    create table t3(e int, f int);
    create table t4(g int, h int);
  tasks:
    - execute
- sql: |
    select * from t1, t2, t3 where a = c AND d = e;
  desc: test 3-way join
  tasks:
    - explain:logical_optd,physical_optd
- sql: |
    select * from t1, t2, t3 where a = c AND b = e;
  desc: test 3-way join
  tasks:
    - explain:logical_optd,physical_optd
- sql: |
    select * from t1, t2, t3, t4 where a = c AND b = e AND f = g;
  desc: test 4-way join
  tasks:
    - explain:logical_optd,physical_optd