Re: MonetDB test says that PostgreSQL often has errors or missing results - Mailing list pgsql-hackers

From Stefan Kaltenbrunner
Subject Re: MonetDB test says that PostgreSQL often has errors or missing results
Date
Msg-id 4B5617A3.4000809@kaltenbrunner.cc
Whole thread Raw
In response to MonetDB test says that PostgreSQL often has errors or missing results  ("Dann Corbit" <DCorbit@connx.com>)
List pgsql-hackers
Dann Corbit wrote:
> See:
> http://monetdb.cwi.nl/SQL/Benchmark/TPCH/
> If the result is correct, then the problem queries should be added to
> the regression test suite.
> If the result is not correct, then perhaps they could get assistance on
> proper configuration of PostgreSQL and rerun the tests.

this is a known issues and has been discussed in the past - the problem 
here is that postgresql misparsed the interval syntax in older version 
(not that they used 8.2 when 8.3 was long released in that test).
This has since been fixed in 8.4+ however.


Stefan


pgsql-hackers by date:

Previous
From: "Dann Corbit"
Date:
Subject: MonetDB test says that PostgreSQL often has errors or missing results
Next
From: Tom Lane
Date:
Subject: Re: MySQL-ism help patch for psql