*** ./expected/oid.out Mon Nov 20 22:23:20 2000 --- ./results/oid.out Wed Dec 27 18:27:16 2000 *************** *** 6,11 **** --- 6,12 ---- INSERT INTO OID_TBL(f1) VALUES ('1235'); INSERT INTO OID_TBL(f1) VALUES ('987'); INSERT INTO OID_TBL(f1) VALUES ('-1040'); + ERROR: oidin: error reading "-1040": Error 0 occurred. INSERT INTO OID_TBL(f1) VALUES ('99999999'); INSERT INTO OID_TBL(f1) VALUES (''); -- bad inputs *************** *** 15,28 **** ERROR: oidin: error in "99asdfasd": can't parse "asdfasd" SELECT '' AS six, OID_TBL.*; six | f1 ! -----+------------ | 1234 | 1235 | 987 - | 4294966256 | 99999999 | 0 ! (6 rows) SELECT '' AS one, o.* FROM OID_TBL o WHERE o.f1 = 1234; one | f1 --- 16,28 ---- ERROR: oidin: error in "99asdfasd": can't parse "asdfasd" SELECT '' AS six, OID_TBL.*; six | f1 ! -----+---------- | 1234 | 1235 | 987 | 99999999 | 0 ! (5 rows) SELECT '' AS one, o.* FROM OID_TBL o WHERE o.f1 = 1234; one | f1 *************** *** 32,44 **** SELECT '' AS five, o.* FROM OID_TBL o WHERE o.f1 <> '1234'; five | f1 ! ------+------------ | 1235 | 987 - | 4294966256 | 99999999 | 0 ! (5 rows) SELECT '' AS three, o.* FROM OID_TBL o WHERE o.f1 <= '1234'; three | f1 --- 32,43 ---- SELECT '' AS five, o.* FROM OID_TBL o WHERE o.f1 <> '1234'; five | f1 ! ------+---------- | 1235 | 987 | 99999999 | 0 ! (4 rows) SELECT '' AS three, o.* FROM OID_TBL o WHERE o.f1 <= '1234'; three | f1 *************** *** 57,75 **** SELECT '' AS four, o.* FROM OID_TBL o WHERE o.f1 >= '1234'; four | f1 ! ------+------------ | 1234 | 1235 - | 4294966256 | 99999999 ! (4 rows) SELECT '' AS three, o.* FROM OID_TBL o WHERE o.f1 > '1234'; three | f1 ! -------+------------ | 1235 - | 4294966256 | 99999999 ! (3 rows) DROP TABLE OID_TBL; --- 56,72 ---- SELECT '' AS four, o.* FROM OID_TBL o WHERE o.f1 >= '1234'; four | f1 ! ------+---------- | 1234 | 1235 | 99999999 ! (3 rows) SELECT '' AS three, o.* FROM OID_TBL o WHERE o.f1 > '1234'; three | f1 ! -------+---------- | 1235 | 99999999 ! (2 rows) DROP TABLE OID_TBL; ====================================================================== *** ./expected/float8-fp-exception.out Thu Mar 30 02:46:00 2000 --- ./results/float8.out Wed Dec 27 18:27:15 2000 *************** *** 214,220 **** SET f1 = FLOAT8_TBL.f1 * '-1' WHERE FLOAT8_TBL.f1 > '0.0'; SELECT '' AS bad, f.f1 * '1e200' from FLOAT8_TBL f; ! ERROR: floating point exception! The last floating point operation either exceeded legal ranges or was a divide by zero SELECT '' AS bad, f.f1 ^ '1e200' from FLOAT8_TBL f; ERROR: pow() result is out of range SELECT '' AS bad, ln(f.f1) from FLOAT8_TBL f where f.f1 = '0.0' ; --- 214,220 ---- SET f1 = FLOAT8_TBL.f1 * '-1' WHERE FLOAT8_TBL.f1 > '0.0'; SELECT '' AS bad, f.f1 * '1e200' from FLOAT8_TBL f; ! ERROR: Bad float8 input format -- overflow SELECT '' AS bad, f.f1 ^ '1e200' from FLOAT8_TBL f; ERROR: pow() result is out of range SELECT '' AS bad, ln(f.f1) from FLOAT8_TBL f where f.f1 = '0.0' ; ====================================================================== *** ./expected/geometry-alpha-precision.out Mon Oct 16 18:37:37 2000 --- ./results/geometry.out Wed Dec 27 18:28:10 2000 *************** *** 163,190 **** twentyfour | translation ------------+------------------------- | (2,2),(0,0) - | (3,3),(1,1) - | (2.5,3.5),(2.5,2.5) - | (3,3),(3,3) | (-8,2),(-10,0) - | (-7,3),(-9,1) - | (-7.5,3.5),(-7.5,2.5) - | (-7,3),(-7,3) | (-1,6),(-3,4) - | (0,7),(-2,5) - | (-0.5,7.5),(-0.5,6.5) - | (0,7),(0,7) | (7.1,36.5),(5.1,34.5) - | (8.1,37.5),(6.1,35.5) - | (7.6,38),(7.6,37) - | (8.1,37.5),(8.1,37.5) | (-3,-10),(-5,-12) - | (-2,-9),(-4,-11) - | (-2.5,-8.5),(-2.5,-9.5) - | (-2,-9),(-2,-9) | (12,12),(10,10) | (13,13),(11,11) | (12.5,13.5),(12.5,12.5) | (13,13),(13,13) (24 rows) --- 163,190 ---- twentyfour | translation ------------+------------------------- | (2,2),(0,0) | (-8,2),(-10,0) | (-1,6),(-3,4) | (7.1,36.5),(5.1,34.5) | (-3,-10),(-5,-12) | (12,12),(10,10) + | (3,3),(1,1) + | (-7,3),(-9,1) + | (0,7),(-2,5) + | (8.1,37.5),(6.1,35.5) + | (-2,-9),(-4,-11) | (13,13),(11,11) + | (2.5,3.5),(2.5,2.5) + | (-7.5,3.5),(-7.5,2.5) + | (-0.5,7.5),(-0.5,6.5) + | (7.6,38),(7.6,37) + | (-2.5,-8.5),(-2.5,-9.5) | (12.5,13.5),(12.5,12.5) + | (3,3),(3,3) + | (-7,3),(-7,3) + | (0,7),(0,7) + | (8.1,37.5),(8.1,37.5) + | (-2,-9),(-2,-9) | (13,13),(13,13) (24 rows) *************** *** 193,220 **** twentyfour | translation ------------+--------------------------- | (2,2),(0,0) - | (3,3),(1,1) - | (2.5,3.5),(2.5,2.5) - | (3,3),(3,3) | (12,2),(10,0) - | (13,3),(11,1) - | (12.5,3.5),(12.5,2.5) - | (13,3),(13,3) | (5,-2),(3,-4) - | (6,-1),(4,-3) - | (5.5,-0.5),(5.5,-1.5) - | (6,-1),(6,-1) | (-3.1,-32.5),(-5.1,-34.5) - | (-2.1,-31.5),(-4.1,-33.5) - | (-2.6,-31),(-2.6,-32) - | (-2.1,-31.5),(-2.1,-31.5) | (7,14),(5,12) - | (8,15),(6,13) - | (7.5,15.5),(7.5,14.5) - | (8,15),(8,15) | (-8,-8),(-10,-10) | (-7,-7),(-9,-9) | (-7.5,-6.5),(-7.5,-7.5) | (-7,-7),(-7,-7) (24 rows) --- 193,220 ---- twentyfour | translation ------------+--------------------------- | (2,2),(0,0) | (12,2),(10,0) | (5,-2),(3,-4) | (-3.1,-32.5),(-5.1,-34.5) | (7,14),(5,12) | (-8,-8),(-10,-10) + | (3,3),(1,1) + | (13,3),(11,1) + | (6,-1),(4,-3) + | (-2.1,-31.5),(-4.1,-33.5) + | (8,15),(6,13) | (-7,-7),(-9,-9) + | (2.5,3.5),(2.5,2.5) + | (12.5,3.5),(12.5,2.5) + | (5.5,-0.5),(5.5,-1.5) + | (-2.6,-31),(-2.6,-32) + | (7.5,15.5),(7.5,14.5) | (-7.5,-6.5),(-7.5,-7.5) + | (3,3),(3,3) + | (13,3),(13,3) + | (6,-1),(6,-1) + | (-2.1,-31.5),(-2.1,-31.5) + | (8,15),(8,15) | (-7,-7),(-7,-7) (24 rows) *************** *** 224,251 **** twentyfour | rotation ------------+----------------------------- | (0,0),(0,0) - | (0,0),(0,0) - | (0,0),(0,0) - | (0,0),(0,0) | (-0,0),(-20,-20) - | (-10,-10),(-30,-30) - | (-25,-25),(-25,-35) - | (-30,-30),(-30,-30) | (-0,2),(-14,0) - | (-7,3),(-21,1) - | (-17.5,2.5),(-21.5,-0.5) - | (-21,3),(-21,3) | (0,79.2),(-58.8,0) - | (-29.4,118.8),(-88.2,39.6) - | (-73.5,104.1),(-108,99) - | (-88.2,118.8),(-88.2,118.8) | (14,-0),(0,-34) - | (21,-17),(7,-51) - | (29.5,-42.5),(17.5,-47.5) - | (21,-51),(21,-51) | (0,40),(0,0) | (0,60),(0,20) | (0,60),(-10,50) | (0,60),(0,60) (24 rows) --- 224,251 ---- twentyfour | rotation ------------+----------------------------- | (0,0),(0,0) | (-0,0),(-20,-20) | (-0,2),(-14,0) | (0,79.2),(-58.8,0) | (14,-0),(0,-34) | (0,40),(0,0) + | (0,0),(0,0) + | (-10,-10),(-30,-30) + | (-7,3),(-21,1) + | (-29.4,118.8),(-88.2,39.6) + | (21,-17),(7,-51) | (0,60),(0,20) + | (0,0),(0,0) + | (-25,-25),(-25,-35) + | (-17.5,2.5),(-21.5,-0.5) + | (-73.5,104.1),(-108,99) + | (29.5,-42.5),(17.5,-47.5) | (0,60),(-10,50) + | (0,0),(0,0) + | (-30,-30),(-30,-30) + | (-21,3),(-21,3) + | (-88.2,118.8),(-88.2,118.8) + | (21,-51),(21,-51) | (0,60),(0,60) (24 rows) ======================================================================