Re: [HACKERS] regression test errors: netbsd 1.3.2/i386

From: Brook Milligan <brook(at)trillium(dot)NMSU(dot)Edu>
To: lockhart(at)alumni(dot)caltech(dot)edu
Cc: hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] regression test errors: netbsd 1.3.2/i386
Date: 1998-09-10 23:15:56
Message-ID: 199809102315.RAA25173@trillium.nmsu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1998-09-10 23:47:40 Re: [HACKERS] regression test errors: netbsd 1.3.2/i386
Previous Message Brook Milligan 1998-09-10 23:13:07 Re: [HACKERS] regression test errors: netbsd 1.3.2/i386