Re: strange buildfarm failure on lionfish

"Stefan Kaltenbrunner" <stefan@kaltenbrunner.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.f1BETWEEN '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