Hi all,
Since last night, Warthog build farm member (unixware) is failing the
returning regression test.
Regression.diffs is :
*** ./expected/returning.out Sat Aug 12 04:52:06 2006
--- ./results/returning.out Sun Aug 13 14:51:07 2006
***************
*** 155,162 ****
WHERE foo.f1 = i.q1
RETURNING *;
f1 | f2 | f3 | f4 | q1 | q2
! -----+-------+------+------+-----+-----
! 123 | child | 1998 | 1098 | 123 | 456
(1 row)
SELECT * FROM foo;
--- 155,162 ----
WHERE foo.f1 = i.q1
RETURNING *;
f1 | f2 | f3 | f4 | q1 | q2
! -----+-------+------+------+-----+------------------
! 123 | child | 1998 | 1098 | 123 | 4567890123456789
(1 row)
SELECT * FROM foo;
***************
*** 177,184 ****
WHERE foo.f1 = i.q1
RETURNING *;
f1 | f2 | f3 | f4 | q1 | q2
! -----+-------+------+------+-----+-----
! 123 | child | 1998 | 1098 | 123 | 456
(1 row)
SELECT * FROM foo;
--- 177,184 ----
WHERE foo.f1 = i.q1
RETURNING *;
f1 | f2 | f3 | f4 | q1 | q2
! -----+-------+------+------+-----+------------------
! 123 | child | 1998 | 1098 | 123 | 4567890123456789
(1 row)
SELECT * FROM foo;
======================================================================
What can I do to help debugging this?
TIA
--
Olivier PRENANT Tel: +33-5-61-50-97-00 (Work)
15, Chemin des Monges +33-5-61-50-97-01 (Fax)
31190 AUTERIVE +33-6-07-63-80-64 (GSM)
FRANCE Email: [email protected]
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
