> I just compiled up the current snapshot for a test under netbsd
> 1.3.2/i386. Everything works except the followng:
>
> union .. failed <-- all differences have extra rows
? Do other people see a problem with unions?
Still having problems with unions from last night's snapshot. The
diffs are below in case they can help pinpoint the problem. Does no
one see anything like these additional zeros?
Cheers,
Brook
===========================================================================
--- expected/union.out Fri May 29 07:22:42 1998
+++ results/union.out Thu Sep 10 16:51:42 1998
@@ -122,7 +122,10 @@
-34.84
-1.2345678901234e-200
0
-(5 rows)
+0
+0
+0
+(8 rows)
QUERY: SELECT f1 AS ten FROM FLOAT8_TBL
UNION ALL
@@ -131,15 +134,19 @@
---------------------
0
-34.84
+0
+0
-1004.3
-1.2345678901234e+200
-1.2345678901234e-200
0
-34.84
+0
+0
-1004.3
-1.2345678901234e+200
-1.2345678901234e-200
-(10 rows)
+(14 rows)
QUERY: SELECT f1 AS nine FROM FLOAT8_TBL
UNION
@@ -153,9 +160,11 @@
-34.84
-1.2345678901234e-200
0
+0
+0
123456
2147483647
-(9 rows)
+(11 rows)
QUERY: SELECT f1 AS ten FROM FLOAT8_TBL
UNION ALL
@@ -164,6 +173,8 @@
---------------------
0
-34.84
+0
+0
-1004.3
-1.2345678901234e+200
-1.2345678901234e-200
@@ -172,7 +183,7 @@
-123456
2147483647
-2147483647
-(10 rows)
+(12 rows)
QUERY: SELECT f1 AS five FROM FLOAT8_TBL
WHERE f1 BETWEEN -1e6 AND 1e6
@@ -185,8 +196,9 @@
-34.84
-1.2345678901234e-200
0
+ 0
123456
-(5 rows)
+(6 rows)
QUERY: SELECT f1 AS five FROM VARCHAR_TBL
UNION