Re: strange buildfarm failure on lionfish

"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