From: | Gregory Stark <stark(at)enterprisedb(dot)com> |
---|---|
To: | "Stefan Kaltenbrunner" <stefan(at)kaltenbrunner(dot)cc> |
Cc: | "pgsql-hackers" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: strange buildfarm failure on lionfish |
Date: | 2007-07-24 15:39:54 |
Message-ID: | 87y7h5zu7p.fsf@oxford.xeocode.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
"Stefan Kaltenbrunner" <stefan(at)kaltenbrunner(dot)cc> writes:
> http://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=lionfish&dt=2007-07-24%2005:30:13
That's just a faulty test:
SELECT t.d1 + i.f1 AS "102" FROM TIMESTAMP_TBL t, INTERVAL_TBL i
WHERE t.d1 BETWEEN '1990-01-01' AND '2001-01-01'
AND i.f1 BETWEEN '00:00' AND '23:00';
Note that there's no ORDER BY on the test. I bet the planner came up with an
entirely different plan than usual which generated the records in a different
order.
Offhand I can only think of one kind of plan myself but I'm sure the planner
is more inventive than me :)
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-07-24 16:08:42 | Re: strange buildfarm failure on lionfish |
Previous Message | Stefan Kaltenbrunner | 2007-07-24 15:36:38 | Re: strange buildfarm failure on lionfish |