Re: Union test case broken in make check? - Mailing list pgsql-hackers

Tom Lane wrote:
> Andrew Dunstan <andrew@dunslane.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)

  --

======================================================================