Re: Union test case broken in make check?

Then I guess that we need to fix the test.

Emmanuel

Kenneth Marshall wrote:
> Without an order by, the order is not defined. The answers are the
> same but the test gives a false failure because of the lack of
> ordering.
>
> Regards,
> Ken
>
> On Thu, Nov 19, 2009 at 07:54:30PM -0500, Emmanuel Cecchet wrote:
>
>> Tom Lane wrote:
>>
>>> Andrew Dunstan <andrew(at)dunslane(dot)net> writes:
>>>
>>>
>>>> Emmanuel Cecchet wrote:
>>>>
>>>>
>>>>> Is it just me or the union test case fails in CVS head?
>>>>>
>>>>>
>>>
>>>
>>>> The buildfarm is pretty much all green:
>>>> <http://www.pgbuildfarm.org/cgi-bin/show_status.pl>
>>>> So it looks like it's you :-)
>>>>
>>>>
>>> When in doubt, try "make distclean" and a full rebuild before assuming
>>> you've got a problem worth tracking down ...
>>>
>>>
>> Well, I did:
>> 1. make distclean
>> 2. configure with CFLAGS=-O0 --enable-cassert --enable-debug --without-perl
>> --without-python --without-tcl --without-openssl
>> 3. make (everything normal)
>> 4. make check
>> And it still fails for me. I am attaching my regression.diffs if someone
>> thinks it is worth tracking down ...
>>
>> Emmanuel
>>
>
>
>> *** /home/manu/workspace/PG-HEAD/src/test/regress/expected/union.out 2009-02-09 16:18:28.000000000 -0500
>> --- /home/manu/workspace/PG-HEAD/src/test/regress/results/union.out 2009-11-19 19:37:32.000000000 -0500
>> ***************
>> *** 198,208 ****
>> WHERE f1 BETWEEN 0 AND 1000000;
>> five
>> -----------------------
>> - -1004.3
>> - -34.84
>> - -1.2345678901234e-200
>> 0
>> 123456
>> (5 rows)
>>
>> SELECT CAST(f1 AS char(4)) AS three FROM VARCHAR_TBL
>> --- 198,208 ----
>> WHERE f1 BETWEEN 0 AND 1000000;
>> five
>> -----------------------
>> 0
>> 123456
>> + -34.84
>> + -1.2345678901234e-200
>> + -1004.3
>> (5 rows)
>>
>> SELECT CAST(f1 AS char(4)) AS three FROM VARCHAR_TBL
>> ***************
>> *** 263,278 ****
>> SELECT q2 FROM int8_tbl INTERSECT SELECT q1 FROM int8_tbl;
>> q2
>> ------------------
>> - 4567890123456789
>> 123
>> (2 rows)
>>
>> SELECT q2 FROM int8_tbl INTERSECT ALL SELECT q1 FROM int8_tbl;
>> q2
>> ------------------
>> 4567890123456789
>> 4567890123456789
>> - 123
>> (3 rows)
>>
>> SELECT q2 FROM int8_tbl EXCEPT SELECT q1 FROM int8_tbl ORDER BY 1;
>> --- 263,278 ----
>> SELECT q2 FROM int8_tbl INTERSECT SELECT q1 FROM int8_tbl;
>> q2
>> ------------------
>> 123
>> + 4567890123456789
>> (2 rows)
>>
>> SELECT q2 FROM int8_tbl INTERSECT ALL SELECT q1 FROM int8_tbl;
>> q2
>> ------------------
>> + 123
>> 4567890123456789
>> 4567890123456789
>> (3 rows)
>>
>> SELECT q2 FROM int8_tbl EXCEPT SELECT q1 FROM int8_tbl ORDER BY 1;
>> ***************
>> *** 305,320 ****
>> SELECT q1 FROM int8_tbl EXCEPT ALL SELECT q2 FROM int8_tbl;
>> q1
>> ------------------
>> - 4567890123456789
>> 123
>> (2 rows)
>>
>> SELECT q1 FROM int8_tbl EXCEPT ALL SELECT DISTINCT q2 FROM int8_tbl;
>> q1
>> ------------------
>> 4567890123456789
>> 4567890123456789
>> - 123
>> (3 rows)
>>
>> --
>> --- 305,320 ----
>> SELECT q1 FROM int8_tbl EXCEPT ALL SELECT q2 FROM int8_tbl;
>> q1
>> ------------------
>> 123
>> + 4567890123456789
>> (2 rows)
>>
>> SELECT q1 FROM int8_tbl EXCEPT ALL SELECT DISTINCT q2 FROM int8_tbl;
>> q1
>> ------------------
>> + 123
>> 4567890123456789
>> 4567890123456789
>> (3 rows)
>>
>> --
>> ***************
>> *** 341,348 ****
>> SELECT q1 FROM int8_tbl INTERSECT SELECT q2 FROM int8_tbl UNION ALL SELECT q2 FROM int8_tbl;
>> q1
>> -------------------
>> - 4567890123456789
>> 123
>> 456
>> 4567890123456789
>> 123
>> --- 341,348 ----
>> SELECT q1 FROM int8_tbl INTERSECT SELECT q2 FROM int8_tbl UNION ALL SELECT q2 FROM int8_tbl;
>> q1
>> -------------------
>> 123
>> + 4567890123456789
>> 456
>> 4567890123456789
>> 123
>> ***************
>> *** 353,367 ****
>> SELECT q1 FROM int8_tbl INTERSECT (((SELECT q2 FROM int8_tbl UNION ALL SELECT q2 FROM int8_tbl)));
>> q1
>> ------------------
>> - 4567890123456789
>> 123
>> (2 rows)
>>
>> (((SELECT q1 FROM int8_tbl INTERSECT SELECT q2 FROM int8_tbl))) UNION ALL SELECT q2 FROM int8_tbl;
>> q1
>> -------------------
>> - 4567890123456789
>> 123
>> 456
>> 4567890123456789
>> 123
>> --- 353,367 ----
>> SELECT q1 FROM int8_tbl INTERSECT (((SELECT q2 FROM int8_tbl UNION ALL SELECT q2 FROM int8_tbl)));
>> q1
>> ------------------
>> 123
>> + 4567890123456789
>> (2 rows)
>>
>> (((SELECT q1 FROM int8_tbl INTERSECT SELECT q2 FROM int8_tbl))) UNION ALL SELECT q2 FROM int8_tbl;
>> q1
>> -------------------
>> 123
>> + 4567890123456789
>> 456
>> 4567890123456789
>> 123
>> ***************
>> *** 416,423 ****
>> SELECT q1 FROM int8_tbl EXCEPT (((SELECT q2 FROM int8_tbl ORDER BY q2 LIMIT 1)));
>> q1
>> ------------------
>> - 4567890123456789
>> 123
>> (2 rows)
>>
>> --
>> --- 416,423 ----
>> SELECT q1 FROM int8_tbl EXCEPT (((SELECT q2 FROM int8_tbl ORDER BY q2 LIMIT 1)));
>> q1
>> ------------------
>> 123
>> + 4567890123456789
>> (2 rows)
>>
>> --
>>
>> ======================================================================
>>
>>
>
>

--
Emmanuel Cecchet
Aster Data
Web: http://www.asterdata.com