Subject: TPCH Benchmark query result invalid
From: Cronje Fourie <cfourie@e-intelligence.com>
To: pgsql-sql@postgresql.org
Content-Type: text/plain
Date: Tue, 12 Dec 2006 16:09:22 +0200
Message-Id: <1165932562.10968.1.camel@localhost>
Mime-Version: 1.0
Content-Transfer-Encoding: 7bit

When running the following query against a TPCH db I get 0 results
returned

select
	o_orderpriority,
	count(*) as order_count
from
	orders
where
	o_orderdate >= date '1993-07-01'
	and o_orderdate < date '1993-07-01' + interval '3' month
	and exists (
		select
			*
		from
			lineitem
		where
			l_orderkey = o_orderkey
			and l_commitdate < l_receiptdate
	)
group by
	o_orderpriority
order by
	o_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.