TPCH Benchmark query result invalid - Mailing list pgsql-sql

From Cronje Fourie
Subject TPCH Benchmark query result invalid
Date
Msg-id 1165932562.10968.1.camel@localhost
Whole thread Raw
Responses Re: TPCH Benchmark query result invalid
List pgsql-sql
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.



pgsql-sql by date:

Previous
From: "Aaron Bono"
Date:
Subject: Re: subquery abnormal behavior
Next
From: Richard Huxton
Date:
Subject: Re: TPCH Benchmark query result invalid