When running the following query against a TPCH db I get 0 results
returned
selecto_orderpriority,count(*) as order_count
fromorders
whereo_orderdate >= date '1993-07-01'and o_orderdate < date '1993-07-01' + interval '3' monthand exists ( select
* from lineitem where l_orderkey = o_orderkey and l_commitdate < l_receiptdate)
group byo_orderpriority
order byo_orderpriority;
The same query runs correctly under mysql. Has anyone expierenced this
before?
Cronje
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
MailScanner thanks transtec Computers for their support.