1-- $ID$
2-- TPC-H/TPC-R Order Priority Checking Query (Q4)
3-- Functional Query Definition
4-- Approved February 1998
5:x
6:o
7select
8	o_orderpriority,
9	count(*) as order_count
10from
11	orders
12where
13	o_orderdate >= date ':1'
14	and o_orderdate < date ':1' + interval '3' month
15	and exists (
16		select
17			*
18		from
19			lineitem
20		where
21			l_orderkey = o_orderkey
22			and l_commitdate < l_receiptdate
23	)
24group by
25	o_orderpriority
26order by
27	o_orderpriority;
28:n -1
29
30select
31	o_orderpriority,
32from
33	orders
34where
35	o_orderdate >= date ':1'
36	and o_orderdate < date ':1' + interval '3' month
37
38GetColumnRowsByFTSCompare
39        TCN = 1 (o_orderdate)
40        SCN = 1
41        BOP = AND
42        Arg32 = date ':1', date ':1' + interval '3' month
43        COP32 = GTE, LE
44        RRI = 1
45GetColumnRowsByOffset
46        TCN = 2 (o_orderpriority)
47        SCN = 1
48        RSPwRID = PREV-0
49