2
SELECT distinct select_item FROM lineitem index_hint WHERE where order_by |
3
SELECT aggregate key_field ) FROM lineitem WHERE where ;
6
| | ORDER BY key_field , l_orderkey , l_linenumber ;
12
where_list and_or where_list |
13
( where_list ) and_or ( where_list ) ;
16
( where_item ) and_or ( where_list ) |
17
( where_item ) and_or ( where_item ) |
18
where_item and_or where_list |
19
where_item and_or where_item |
20
where_item and_or where_item and_or where_item |
25
key_clause or_and key_clause ;
38
MIN( | MAX( | COUNT( | COUNT( ;
41
AND | AND | AND | AND | OR ;
44
OR | OR | OR | OR | AND ;
47
= | = | = | = | = | = |
48
!= | > | >= | < | <= | <> ;
51
| | | | | | | | | NOT ;
54
l_shipdate comp_op any_date |
55
l_shipdate not IN ( date_list ) |
56
l_shipdate date_between ;
59
date_item , date_item |
60
date_list , date_item ;
63
any_date | any_date | any_date | any_date | any_date |
64
any_date | any_date | any_date | any_date | any_date |
65
any_date | any_date | any_date | any_date | any_date |
66
any_date | any_date | any_date | any_date | any_date |
67
'1992-01-08' | '1998-11-27' ;
70
BETWEEN date_item AND date_item |
71
between_two_dates_in_a_year |
72
between_two_dates_in_a_month |
79
{ sprintf("'%04d-%02d-%02d'", $prng->uint16(1992,1998), $prng->uint16(1,12), $prng->uint16(1,28)) } ;
81
between_two_dates_in_a_year:
82
{ my $year = $prng->uint16(1992,1998); return sprintf("BETWEEN '%04d-%02d-%02d' AND '%04d-%02d-%02d'", $year, $prng->uint16(1,12), $prng->uint16(1,28), $year, $prng->uint16(1,12), $prng->uint16(1,28)) } ;
84
between_two_dates_in_a_month:
85
{ my $year = $prng->uint16(1992,1998); my $month = $prng->uint16(1,12); return sprintf("BETWEEN '%04d-%02d-%02d' AND '%04d-%02d-%02d'", $year, $month, $prng->uint16(1,28), $year, $month, $prng->uint16(1,28)) } ;
88
{ my $year = $prng->uint16(1992,1998); my $month = $prng->uint16(1,12); return sprintf("BETWEEN '%04d-%02d-01' AND '%04d-%02d-29'", $year, $month, $year, $month) } ;
93
l_linenumber comp_op linenumber_item |
94
l_linenumber not IN ( linenumber_list ) |
95
l_linenumber BETWEEN linenumber_item AND linenumber_item + linenumber_range ;
98
linenumber_item , linenumber_item |
99
linenumber_item , linenumber_list ;
110
l_partkey comp_op partkey_item |
111
l_partkey not IN ( partkey_list ) |
112
l_partkey BETWEEN partkey_item AND partkey_item + partkey_range ;
115
partkey_item , partkey_item |
116
partkey_item , partkey_list ;
119
_digit | _tinyint_unsigned;
122
_tinyint_unsigned | _tinyint_unsigned | _tinyint_unsigned | _tinyint_unsigned | _tinyint_unsigned |
123
_tinyint_unsigned | _tinyint_unsigned | _tinyint_unsigned | _tinyint_unsigned | _tinyint_unsigned |
124
_tinyint_unsigned | _tinyint_unsigned | _tinyint_unsigned | _tinyint_unsigned | _tinyint_unsigned |
125
_tinyint_unsigned | _tinyint_unsigned | _tinyint_unsigned | _tinyint_unsigned | _tinyint_unsigned |
131
l_suppkey comp_op suppkey_item |
132
l_suppkey not IN ( suppkey_list ) |
133
l_suppkey BETWEEN suppkey_item AND suppkey_item + _digit ;
139
suppkey_item , suppkey_item |
140
suppkey_item , suppkey_list ;
145
l_receiptDATE comp_op any_date |
146
l_receiptDATE not IN ( date_list ) |
147
l_receiptDATE date_between ;
152
l_commitDATE comp_op any_date |
153
l_commitDATE not IN ( date_list ) |
154
l_commitDATE date_between ;
159
l_orderkey comp_op orderkey_item |
160
l_orderkey not IN ( orderkey_list ) |
161
l_orderkey BETWEEN orderkey_item AND orderkey_item + orderkey_range ;
164
_tinyint_unsigned | { $prng->uint16(1,1500) } ;
167
orderkey_item , orderkey_item |
168
orderkey_item , orderkey_list ;
171
_digit | _tinyint_unsigned ;
176
l_quantity comp_op quantity_item |
177
l_quantity not IN ( quantity_list ) |
178
l_quantity BETWEEN quantity_item AND quantity_item + quantity_range ;
181
quantity_item , quantity_item |
182
quantity_item , quantity_list ;
185
_digit | { $prng->uint16(1,50) } ;
191
| FORCE KEY ( key_list );
194
key_name , key_name |
195
key_name , key_list ;
213
i_l_suppkey_partkey |
218
i_l_orderkey_quantity |