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: ohp@pyrenet.fr ------------------------------------------------------------------------------ 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