optd-sqlplannertest 0.1.1

sqlplannertest for optd
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21

- sql: |
    create table t1(t1v1 int, t1v2 int);
    create table t2(t2v1 int, t2v3 int);
    insert into t1 values (0, 0), (1, 1), (2, 2);
    insert into t2 values (0, 200), (1, 201), (2, 202);
  tasks:
    - execute
- sql: |
    select 64 + 1;
    select 64 + 1 from t1;
  desc: Test whether the optimizer handles empty relation correctly.
  tasks:
    - explain:logical_optd,physical_optd
    - execute
- sql: |
    select * from t1 inner join t2 on false;
    select 64+1 from t1 inner join t2 on false;
  desc: Test whether the optimizer eliminates join to empty relation
  tasks:
    - explain:logical_optd,optimized_logical_optd,physical_optd
    - execute