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
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79

- 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 * from t1 where false;
  desc: Test EliminateFilterRule (false filter to empty relation)
  tasks:
    - explain:logical_optd,physical_optd
    - execute
- sql: |
    select * from t1 where true;
  desc: Test EliminateFilterRule (replace true filter with child)
  tasks:
    - explain:logical_optd,physical_optd
    - execute
- sql: |
    select * from t1, t2 where t1v1 = t2v1 and false;
  desc: Test SimplifyFilterRule and EliminateFilterRule (false filter to empty relation)
  tasks:
    - explain:logical_optd,physical_optd
    - execute
- sql: |
    select * from t1, t2 where t1v1 = t2v1 and t1v1 = t2v3 and true;
  desc: Test SimplifyFilterRule (skip true filter for and)
  tasks:
    - explain:logical_optd,physical_optd
    - execute
- sql: |
    select * from t1, t2 where t1v1 = t2v1 or t1v1 = t2v3 and true;
  desc: Test SimplifyFilterRule (skip true filter for and)
  tasks:
    - explain:logical_optd,physical_optd
    - execute
- sql: |
    select * from t1, t2 where t1v1 = t2v1 or t1v1 = t2v3 or true;
  desc: Test SimplifyFilterRule, EliminateFilter (repace true filter for or)
  tasks:
    - explain:logical_optd,physical_optd
    - execute
- sql: |
    select * from t1, t2 where t1v1 = t2v1 or t1v1 = t2v1 and t1v1 = t2v1;
  desc: Test SimplifyFilterRule (remove duplicates)
  tasks:
    - explain:logical_optd,physical_optd
    - execute
- sql: |
    select * from t1 inner join t2 on t1v1 = t2v1 and false;
  desc: Test SimplifyJoinCondRule and EliminateJoinRule (false filter to empty relation)
  tasks:
    - explain:logical_optd,physical_optd
    - execute
- sql: |
    select * from t1 inner join t2 on t1v1 = t2v1 and t1v1 = t2v3 and true;
  desc: Test SimplifyJoinCondRule (skip true filter for and)
  tasks:
    - explain:logical_optd,physical_optd
    - execute
- sql: |
    select * from t1 inner join t2 on t1v1 = t2v1 or t1v1 = t2v3 and true;
  desc: Test SimplifyJoinCondRule (skip true filter for and)
  tasks:
    - explain:logical_optd,physical_optd
    - execute
- sql: |
    select * from t1 inner join t2 on t1v1 = t2v1 or t1v1 = t2v3 or true;
  desc: Test SimplifyJoinCondRule, EliminateFilter (repace true filter for or)
  tasks:
    - explain:logical_optd,physical_optd
    - execute
- sql: |
    select * from t1 inner join t2 on t1v1 = t2v1 or t1v1 = t2v1 and t1v1 = t2v1;
  desc: Test SimplifyJoinCondRule (remove duplicates)
  tasks:
    - explain:logical_optd,physical_optd
    - execute