3 echo Multiple predicates Test Cases
- 1,2,3
4 echo select * from t1 where f1
=10 and f3
=20;
7 <ScanType
> TableScan
</ScanType
>
12 <FieldName1
> f1
</FieldName1
>
13 <CompOp
> Equals
</CompOp
>
14 <OperandPtr
> VALUE
</OperandPtr
>
19 <FieldName1
> f3
</FieldName1
>
20 <CompOp
> Equals
</CompOp
>
21 <OperandPtr
> VALUE
</OperandPtr
>
26 echo select * from t1 where f2
>10 and f3
=20;
29 <ScanType
> TableScan
</ScanType
>
34 <FieldName1
> f1
</FieldName1
>
35 <CompOp
> GreaterThan
</CompOp
>
36 <OperandPtr
> VALUE
</OperandPtr
>
41 <FieldName1
> f3
</FieldName1
>
42 <CompOp
> Equals
</CompOp
>
43 <OperandPtr
> VALUE
</OperandPtr
>
48 echo select * from t1 where f3
=20 and f1
>10;
51 <ScanType
> TableScan
</ScanType
>
56 <FieldName1
> f3
</FieldName1
>
57 <CompOp
> Equals
</CompOp
>
58 <OperandPtr
> VALUE
</OperandPtr
>
63 <FieldName1
> f1
</FieldName1
>
64 <CompOp
> GreaterThan
</CompOp
>
65 <OperandPtr
> VALUE
</OperandPtr
>
70 echo Disjunctive Queries Test
case - 4,5,6,7,8
71 echo select * from t1 where f1
!=10;
74 <ScanType
> TableScan
</ScanType
>
76 <FieldName1
> f1
</FieldName1
>
77 <CompOp
> NotEquals
</CompOp
>
78 <OperandPtr
> VALUE
</OperandPtr
>
81 echo select * from t1 where f2
!=10;
84 <ScanType
> TableScan
</ScanType
>
86 <FieldName1
> f2
</FieldName1
>
87 <CompOp
> NotEquals
</CompOp
>
88 <OperandPtr
> VALUE
</OperandPtr
>
91 echo select * from t1 where f1
=10 or f3
=20;
94 <ScanType
> TableScan
</ScanType
>
99 <FieldName1
> f1
</FieldName1
>
100 <CompOp
> Equals
</CompOp
>
101 <OperandPtr
> VALUE
</OperandPtr
>
106 <FieldName1
> f3
</FieldName1
>
107 <CompOp
> Equals
</CompOp
>
108 <OperandPtr
> VALUE
</OperandPtr
>
113 echo select * from t1 where f2
>10 or f3
=20;
116 <ScanType
> TableScan
</ScanType
>
121 <FieldName1
> f2
</FieldName1
>
122 <CompOp
> GreaterThan
</CompOp
>
123 <OperandPtr
> VALUE
</OperandPtr
>
128 <FieldName1
> f3
</FieldName1
>
129 <CompOp
> Equals
</CompOp
>
130 <OperandPtr
> VALUE
</OperandPtr
>
135 echo select * from t1 where f3
=20 or f2
>10;
138 <ScanType
> TableScan
</ScanType
>
143 <FieldName1
> f3
</FieldName1
>
144 <CompOp
> Equals
</CompOp
>
145 <OperandPtr
> VALUE
</OperandPtr
>
150 <FieldName1
> f2
</FieldName1
>
151 <CompOp
> GreaterThan
</CompOp
>
152 <OperandPtr
> VALUE
</OperandPtr
>