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
22
23
24
25
26
27
28
29

- sql: |
    create table t1(v1 int, v2 int);
    insert into t1 values (0, 0), (1, 1), (5, 2), (2, 4), (0, 2);
  tasks:
    - execute
- sql: |
    select * from t1;
  desc: Test without sorts/aggs.
  tasks:
    - explain:logical_optd,physical_optd
    - execute
- sql: |
    select * from t1 order by v1, v2, v1 desc, v2 desc, v1 asc;
  desc: Test whether the optimizer handles duplicate sort expressions correctly.
  tasks:
    - explain:logical_optd,physical_optd
    - execute
- sql: |
    select * from t1 group by v1, v2, v1;
  desc: Test whether the optimizer handles duplicate agg expressions correctly.
  tasks:
    - explain:logical_optd,physical_optd
    - execute
- sql: |
    select * from t1 group by v1, v2, v1, v2, v2 order by v1, v2, v1 desc, v2 desc, v1 asc;
  desc: Test whether the optimizer handles duplicate sort and agg expressions correctly.
  tasks:
    - explain:logical_optd,physical_optd
    - execute