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