From f9649012d3ddf5f9b91a4d928c940bb42ae4694d Mon Sep 17 00:00:00 2001 From: "Marc G. Fournier" Date: Tue, 13 Oct 1998 22:42:43 +0000 Subject: [PATCH] Updated regression.diffs file for Solaris x86... --- src/test/regress/regression.Solaris-i386 | 318 ++++++++++++++++++++++++++----- 1 file changed, 270 insertions(+), 48 deletions(-) diff --git a/src/test/regress/regression.Solaris-i386 b/src/test/regress/regression.Solaris-i386 index b9726c9346..493e9b5b13 100644 --- a/src/test/regress/regression.Solaris-i386 +++ b/src/test/regress/regression.Solaris-i386 @@ -1,8 +1,238 @@ -*** expected/float8.out Tue Feb 3 12:09:20 1998 ---- results/float8.out Wed Feb 25 11:01:11 1998 +*** expected/int8.out Mon Oct 12 17:08:45 1998 +--- results/int8.out Tue Oct 13 18:08:11 1998 +*************** +*** 6,115 **** + QUERY: INSERT INTO INT8_TBL VALUES('4567890123456789','-4567890123456789'); + QUERY: SELECT * FROM INT8_TBL; + q1| q2 +! ----------------+----------------- + 123| 456 +! 123| 4567890123456789 +! 4567890123456789| 123 +! 4567890123456789| 4567890123456789 +! 4567890123456789|-4567890123456789 + (5 rows) + + QUERY: SELECT '' AS five, q1 AS plus, -q1 AS minus FROM INT8_TBL; + five| plus| minus +! ----+----------------+----------------- + | 123| -123 + | 123| -123 +! |4567890123456789|-4567890123456789 +! |4567890123456789|-4567890123456789 +! |4567890123456789|-4567890123456789 + (5 rows) + + QUERY: SELECT '' AS five, q1, q2, q1 + q2 AS plus FROM INT8_TBL; + five| q1| q2| plus +! ----+----------------+-----------------+---------------- + | 123| 456| 579 +! | 123| 4567890123456789|4567890123456912 +! |4567890123456789| 123|4567890123456912 +! |4567890123456789| 4567890123456789|9135780246913578 +! |4567890123456789|-4567890123456789| 0 + (5 rows) + + QUERY: SELECT '' AS five, q1, q2, q1 - q2 AS minus FROM INT8_TBL; + five| q1| q2| minus +! ----+----------------+-----------------+----------------- + | 123| 456| -333 +! | 123| 4567890123456789|-4567890123456666 +! |4567890123456789| 123| 4567890123456666 +! |4567890123456789| 4567890123456789| 0 +! |4567890123456789|-4567890123456789| 9135780246913578 + (5 rows) + + QUERY: SELECT '' AS three, q1, q2, q1 * q2 AS multiply FROM INT8_TBL + WHERE q1 < 1000 or (q2 > 0 and q2 < 1000); + three| q1| q2| multiply +! -----+----------------+----------------+------------------ + | 123| 456| 56088 +! | 123|4567890123456789|561850485185185047 +! |4567890123456789| 123|561850485185185047 +! (3 rows) + + QUERY: SELECT '' AS five, q1, q2, q1 / q2 AS divide FROM INT8_TBL; + five| q1| q2| divide +! ----+----------------+-----------------+-------------- + | 123| 456| 0 +! | 123| 4567890123456789| 0 +! |4567890123456789| 123|37137318076884 +! |4567890123456789| 4567890123456789| 1 +! |4567890123456789|-4567890123456789| -1 + (5 rows) + + QUERY: SELECT '' AS five, q1, float8(q1) FROM INT8_TBL; + five| q1|float8 +! ----+----------------+-------------------- + | 123|123 + | 123|123 +! |4567890123456789|4.56789012345679e+15 +! |4567890123456789|4.56789012345679e+15 +! |4567890123456789|4.56789012345679e+15 + (5 rows) + + QUERY: SELECT '' AS five, q2, float8(q2) FROM INT8_TBL; + five| q2|float8 +! ----+-----------------+--------------------- + | 456|456 +! | 4567890123456789|4.56789012345679e+15 + | 123|123 +! | 4567890123456789|4.56789012345679e+15 +! |-4567890123456789|-4.56789012345679e+15 + (5 rows) + + QUERY: SELECT '' AS five, q1, int8(float8(q1)) AS "two coercions" FROM INT8_TBL; + five| q1| two coercions +! ----+----------------+---------------- + | 123| 123 + | 123| 123 +! |4567890123456789|4567890123456789 +! |4567890123456789|4567890123456789 +! |4567890123456789|4567890123456789 + (5 rows) + + QUERY: SELECT '' AS five, 2 * q1 AS "twice int4" FROM INT8_TBL; + five| twice int4 +! ----+---------------- + | 246 + | 246 +! |9135780246913578 +! |9135780246913578 +! |9135780246913578 + (5 rows) + + QUERY: SELECT '' AS five, q1 * 2 AS "twice int4" FROM INT8_TBL; + five| twice int4 +! ----+---------------- + | 246 + | 246 +! |9135780246913578 +! |9135780246913578 +! |9135780246913578 + (5 rows) + +--- 6,117 ---- + QUERY: INSERT INTO INT8_TBL VALUES('4567890123456789','-4567890123456789'); + QUERY: SELECT * FROM INT8_TBL; + q1| q2 +! ----------+---------- + 123| 456 +! 123|-869367531 +! -869367531| 123 +! -869367531|-869367531 +! -869367531| 869367531 + (5 rows) + + QUERY: SELECT '' AS five, q1 AS plus, -q1 AS minus FROM INT8_TBL; + five| plus| minus +! ----+----------+--------- + | 123| -123 + | 123| -123 +! |-869367531|869367531 +! |-869367531|869367531 +! |-869367531|869367531 + (5 rows) + + QUERY: SELECT '' AS five, q1, q2, q1 + q2 AS plus FROM INT8_TBL; + five| q1| q2| plus +! ----+----------+----------+----------- + | 123| 456| 579 +! | 123|-869367531| -869367408 +! |-869367531| 123| -869367408 +! |-869367531|-869367531|-1738735062 +! |-869367531| 869367531| 0 + (5 rows) + + QUERY: SELECT '' AS five, q1, q2, q1 - q2 AS minus FROM INT8_TBL; + five| q1| q2| minus +! ----+----------+----------+----------- + | 123| 456| -333 +! | 123|-869367531| 869367654 +! |-869367531| 123| -869367654 +! |-869367531|-869367531| 0 +! |-869367531| 869367531|-1738735062 + (5 rows) + + QUERY: SELECT '' AS three, q1, q2, q1 * q2 AS multiply FROM INT8_TBL + WHERE q1 < 1000 or (q2 > 0 and q2 < 1000); + three| q1| q2| multiply +! -----+----------+----------+---------- + | 123| 456| 56088 +! | 123|-869367531| 441976087 +! |-869367531| 123| 441976087 +! |-869367531|-869367531| 480390073 +! |-869367531| 869367531|-480390073 +! (5 rows) + + QUERY: SELECT '' AS five, q1, q2, q1 / q2 AS divide FROM INT8_TBL; + five| q1| q2| divide +! ----+----------+----------+-------- + | 123| 456| 0 +! | 123|-869367531| 0 +! |-869367531| 123|-7068028 +! |-869367531|-869367531| 1 +! |-869367531| 869367531| -1 + (5 rows) + + QUERY: SELECT '' AS five, q1, float8(q1) FROM INT8_TBL; + five| q1| float8 +! ----+----------+---------- + | 123| 123 + | 123| 123 +! |-869367531|-869367531 +! |-869367531|-869367531 +! |-869367531|-869367531 + (5 rows) + + QUERY: SELECT '' AS five, q2, float8(q2) FROM INT8_TBL; + five| q2| float8 +! ----+----------+---------- + | 456| 456 +! |-869367531|-869367531 + | 123| 123 +! |-869367531|-869367531 +! | 869367531| 869367531 + (5 rows) + + QUERY: SELECT '' AS five, q1, int8(float8(q1)) AS "two coercions" FROM INT8_TBL; + five| q1|two coercions +! ----+----------+------------- + | 123| 123 + | 123| 123 +! |-869367531| -869367531 +! |-869367531| -869367531 +! |-869367531| -869367531 + (5 rows) + + QUERY: SELECT '' AS five, 2 * q1 AS "twice int4" FROM INT8_TBL; + five| twice int4 +! ----+----------- + | 246 + | 246 +! |-1738735062 +! |-1738735062 +! |-1738735062 + (5 rows) + + QUERY: SELECT '' AS five, q1 * 2 AS "twice int4" FROM INT8_TBL; + five| twice int4 +! ----+----------- + | 246 + | 246 +! |-1738735062 +! |-1738735062 +! |-1738735062 + (5 rows) + + +---------------------- + +*** expected/float8.out Mon Oct 12 17:08:38 1998 +--- results/float8.out Tue Oct 13 18:08:15 1998 *************** -*** 203,217 **** +*** 195,209 **** QUERY: SELECT '' AS bad, (; (f.f1)) from FLOAT8_TBL f where f.f1 < '0.0' ; ERROR: can't take log of a negative number QUERY: SELECT '' AS bad, : (f.f1) from FLOAT8_TBL f; @@ -18,7 +248,7 @@ QUERY: SELECT '' AS bad, f.f1 / '0.0' from FLOAT8_TBL f; ERROR: float8div: divide by zero error QUERY: SELECT '' AS five, FLOAT8_TBL.*; ---- 203,209 ---- +--- 195,201 ---- QUERY: SELECT '' AS bad, (; (f.f1)) from FLOAT8_TBL f where f.f1 < '0.0' ; ERROR: can't take log of a negative number QUERY: SELECT '' AS bad, : (f.f1) from FLOAT8_TBL f; @@ -29,10 +259,10 @@ ---------------------- -*** expected/geometry.out Tue Feb 3 12:09:21 1998 ---- results/geometry.out Wed Feb 25 11:01:15 1998 +*** expected/geometry.out Mon Oct 12 17:08:42 1998 +--- results/geometry.out Tue Oct 13 18:08:25 1998 *************** -*** 132,138 **** +*** 131,137 **** |(2.12132034355964,2.12132034355964),(-2.12132034355964,-2.12132034355964) |(71.7106781186548,72.7106781186548),(-69.7106781186548,-68.7106781186548) |(4.53553390593274,6.53553390593274),(-2.53553390593274,-0.535533905932738) @@ -40,7 +270,7 @@ |(107.071067811865,207.071067811865),(92.9289321881345,192.928932188135) |(170.710678118655,70.7106781186548),(29.2893218813452,-70.7106781186548) (6 rows) ---- 132,138 ---- +--- 131,137 ---- |(2.12132034355964,2.12132034355964),(-2.12132034355964,-2.12132034355964) |(71.7106781186548,72.7106781186548),(-69.7106781186548,-68.7106781186548) |(4.53553390593274,6.53553390593274),(-2.53553390593274,-0.535533905932738) @@ -49,7 +279,7 @@ |(170.710678118655,70.7106781186548),(29.2893218813452,-70.7106781186548) (6 rows) *************** -*** 410,434 **** +*** 409,433 **** QUERY: SELECT '' AS six, polygon(f1) FROM CIRCLE_TBL; six|polygon @@ -75,7 +305,7 @@ (6 rows) QUERY: SELECT '' AS six, circle(f1, 50.0) ---- 410,434 ---- +--- 409,433 ---- QUERY: SELECT '' AS six, polygon(f1) FROM CIRCLE_TBL; six|polygon @@ -102,7 +332,7 @@ QUERY: SELECT '' AS six, circle(f1, 50.0) *************** -*** 468,474 **** +*** 467,473 **** ORDER BY distance, circle, point using <<; twentyfour|circle |point | distance ----------+--------------+----------+----------------- @@ -110,7 +340,7 @@ |<(1,2),3> |(-3,4) | 1.47213595499958 |<(0,0),3> |(-3,4) | 2 |<(100,0),100> |(-3,4) | 3.07764064044151 ---- 468,474 ---- +--- 467,473 ---- ORDER BY distance, circle, point using <<; twentyfour|circle |point | distance ----------+--------------+----------+----------------- @@ -119,7 +349,7 @@ |<(0,0),3> |(-3,4) | 2 |<(100,0),100> |(-3,4) | 3.07764064044151 *************** -*** 483,489 **** +*** 482,488 **** |<(0,0),3> |(10,10) | 11.142135623731 |<(1,3),5> |(-5,-12) | 11.1554944214035 |<(1,2),3> |(-5,-12) | 12.2315462117278 @@ -127,7 +357,7 @@ |<(1,2),3> |(5.1,34.5)| 29.757594539282 |<(0,0),3> |(5.1,34.5)| 31.8749193547455 |<(100,200),10>|(5.1,34.5)| 180.778038568384 ---- 483,489 ---- +--- 482,488 ---- |<(0,0),3> |(10,10) | 11.142135623731 |<(1,3),5> |(-5,-12) | 11.1554944214035 |<(1,2),3> |(-5,-12) | 12.2315462117278 @@ -138,8 +368,8 @@ ---------------------- -*** expected/abstime.out Tue Feb 3 12:09:18 1998 ---- results/abstime.out Wed Feb 25 11:01:17 1998 +*** expected/abstime.out Mon Oct 12 17:08:31 1998 +--- results/abstime.out Tue Oct 13 18:08:33 1998 *************** *** 22,28 **** |current @@ -321,8 +551,8 @@ ---------------------- -*** expected/tinterval.out Tue Feb 3 12:09:34 1998 ---- results/tinterval.out Wed Feb 25 11:01:17 1998 +*** expected/tinterval.out Mon Oct 12 17:09:13 1998 +--- results/tinterval.out Tue Oct 13 18:08:34 1998 *************** *** 19,25 **** five|f1 @@ -471,8 +701,8 @@ ---------------------- -*** expected/horology.out Tue Feb 3 12:09:22 1998 ---- results/horology.out Wed Feb 25 11:01:18 1998 +*** expected/horology.out Mon Oct 12 17:08:44 1998 +--- results/horology.out Tue Oct 13 18:08:37 1998 *************** *** 430,436 **** ORDER BY abstime; @@ -714,35 +944,27 @@ ---------------------- -*** expected/random.out Tue Feb 3 12:09:24 1998 ---- results/random.out Wed Feb 25 11:03:40 1998 -*************** -*** 7,18 **** - QUERY: SELECT count(*) FROM onek where oidrand(onek.oid, 10); - count - ----- -! 92 - (1 row) - - QUERY: SELECT count(*) FROM onek where oidrand(onek.oid, 10); - count - ----- -! 98 - (1 row) - ---- 7,18 ---- - QUERY: SELECT count(*) FROM onek where oidrand(onek.oid, 10); - count - ----- -! 95 - (1 row) - - QUERY: SELECT count(*) FROM onek where oidrand(onek.oid, 10); - count - ----- -! 88 - (1 row) +*** expected/rules.out Mon Oct 12 17:08:59 1998 +--- results/rules.out Tue Oct 13 18:13:02 1998 +*************** +*** 315,322 **** + pname |sysname + ------+------- + bm |pluto +- jwieck|orion + jwieck|notjw + (3 rows) + + QUERY: delete from rtest_system where sysname = 'orion'; +--- 315,322 ---- + pname |sysname + ------+------- + bm |pluto + jwieck|notjw ++ jwieck|orion + (3 rows) + QUERY: delete from rtest_system where sysname = 'orion'; ---------------------- -- 2.11.0