Thread: Warthog failing

Warthog failing

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


Re: Warthog failing

From
Tom Lane
Date:
ohp@pyrenet.fr writes:
> Since last night, Warthog build farm member (unixware) is failing the
> returning regression test.

Mea culpa --- the regression test was unintentionally displaying
processing-order-dependent behavior, by joining an updated row to
more than one row of another table.  Should be fixed now.
        regards, tom lane


Re: Warthog failing

From
ohp@pyrenet.fr
Date:
Hi Tom,

It now works like a charm!
Many thanks.

Best regards,
On Sun, 13 Aug 2006, Tom Lane wrote:

> Date: Sun, 13 Aug 2006 14:00:37 -0400
> From: Tom Lane <tgl@sss.pgh.pa.us>
> To: ohp@pyrenet.fr
> Cc: pgsql-hackers list <pgsql-hackers@postgresql.org>
> Subject: Re: [HACKERS] Warthog failing
>
> ohp@pyrenet.fr writes:
> > Since last night, Warthog build farm member (unixware) is failing the
> > returning regression test.
>
> Mea culpa --- the regression test was unintentionally displaying
> processing-order-dependent behavior, by joining an updated row to
> more than one row of another table.  Should be fixed now.
>
>             regards, tom lane
>

-- 
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)