*** ./expected/char.out Mon May 21 12:54:46 2001 --- ./results/char.out Thu Nov 22 22:15:30 2001 *************** *** 63,74 **** WHERE c.f1 < 'a'; five | f1 ------+---- - | A | 1 | 2 | 3 | ! (5 rows) SELECT '' AS six, c.* FROM CHAR_TBL c --- 63,73 ---- WHERE c.f1 < 'a'; five | f1 ------+---- | 1 | 2 | 3 | ! (4 rows) SELECT '' AS six, c.* FROM CHAR_TBL c *************** *** 76,95 **** six | f1 -----+---- | a - | A | 1 | 2 | 3 | ! (6 rows) SELECT '' AS one, c.* FROM CHAR_TBL c WHERE c.f1 > 'a'; one | f1 -----+---- | c ! (1 row) SELECT '' AS two, c.* FROM CHAR_TBL c --- 75,94 ---- six | f1 -----+---- | a | 1 | 2 | 3 | ! (5 rows) SELECT '' AS one, c.* FROM CHAR_TBL c WHERE c.f1 > 'a'; one | f1 -----+---- + | A | c ! (2 rows) SELECT '' AS two, c.* FROM CHAR_TBL c *************** *** 97,104 **** two | f1 -----+---- | a | c ! (2 rows) DROP TABLE CHAR_TBL; -- --- 96,104 ---- two | f1 -----+---- | a + | A | c ! (3 rows) DROP TABLE CHAR_TBL; -- ====================================================================== *** ./expected/varchar.out Mon May 21 12:54:46 2001 --- ./results/varchar.out Thu Nov 22 22:15:30 2001 *************** *** 52,63 **** WHERE c.f1 < 'a'; five | f1 ------+---- - | A | 1 | 2 | 3 | ! (5 rows) SELECT '' AS six, c.* FROM VARCHAR_TBL c --- 52,62 ---- WHERE c.f1 < 'a'; five | f1 ------+---- | 1 | 2 | 3 | ! (4 rows) SELECT '' AS six, c.* FROM VARCHAR_TBL c *************** *** 65,84 **** six | f1 -----+---- | a - | A | 1 | 2 | 3 | ! (6 rows) SELECT '' AS one, c.* FROM VARCHAR_TBL c WHERE c.f1 > 'a'; one | f1 -----+---- | c ! (1 row) SELECT '' AS two, c.* FROM VARCHAR_TBL c --- 64,83 ---- six | f1 -----+---- | a | 1 | 2 | 3 | ! (5 rows) SELECT '' AS one, c.* FROM VARCHAR_TBL c WHERE c.f1 > 'a'; one | f1 -----+---- + | A | c ! (2 rows) SELECT '' AS two, c.* FROM VARCHAR_TBL c *************** *** 86,93 **** two | f1 -----+---- | a | c ! (2 rows) DROP TABLE VARCHAR_TBL; -- --- 85,93 ---- two | f1 -----+---- | a + | A | c ! (3 rows) DROP TABLE VARCHAR_TBL; -- ====================================================================== *** ./expected/int8.out Fri Jan 26 17:50:26 2001 --- ./results/int8.out Thu Nov 22 22:15:29 2001 *************** *** 236,246 **** SELECT '' AS to_char_13, to_char(q2, 'L9999999999999999.000') FROM INT8_TBL; to_char_13 | to_char ------------+------------------------ ! | 456.000 ! | 4567890123456789.000 ! | 123.000 ! | 4567890123456789.000 ! | -4567890123456789.000 (5 rows) SELECT '' AS to_char_14, to_char(q2, 'FM9999999999999999.999') FROM INT8_TBL; --- 236,246 ---- SELECT '' AS to_char_13, to_char(q2, 'L9999999999999999.000') FROM INT8_TBL; to_char_13 | to_char ------------+------------------------ ! | $ 456.000 ! | $ 4567890123456789.000 ! | $ 123.000 ! | $ 4567890123456789.000 ! | $-4567890123456789.000 (5 rows) SELECT '' AS to_char_14, to_char(q2, 'FM9999999999999999.999') FROM INT8_TBL; ====================================================================== *** ./expected/numeric.out Fri Apr 7 15:17:42 2000 --- ./results/numeric.out Thu Nov 22 22:15:43 2001 *************** *** 928,943 **** SELECT '' AS to_char_16, to_char(val, 'L9999999999999999.099999999999999') FROM num_data; to_char_16 | to_char ------------+------------------------------------ ! | .000000000000000 ! | .000000000000000 ! | -34338492.215397047000000 ! | 4.310000000000000 ! | 7799461.411900000000000 ! | 16397.038491000000000 ! | 93901.577630260000000 ! | -83028485.000000000000000 ! | 74881.000000000000000 ! | -24926804.045047420000000 (10 rows) SELECT '' AS to_char_17, to_char(val, 'FM9999999999999999.99999999999999') FROM num_data; --- 928,943 ---- SELECT '' AS to_char_16, to_char(val, 'L9999999999999999.099999999999999') FROM num_data; to_char_16 | to_char ------------+------------------------------------ ! | $ .000000000000000 ! | $ .000000000000000 ! | $ -34338492.215397047000000 ! | $ 4.310000000000000 ! | $ 7799461.411900000000000 ! | $ 16397.038491000000000 ! | $ 93901.577630260000000 ! | $ -83028485.000000000000000 ! | $ 74881.000000000000000 ! | $ -24926804.045047420000000 (10 rows) SELECT '' AS to_char_17, to_char(val, 'FM9999999999999999.99999999999999') FROM num_data; ====================================================================== *** ./expected/geometry.out Fri Sep 28 03:59:52 2001 --- ./results/geometry.out Thu Nov 22 22:15:55 2001 *************** *** 127,133 **** | (-5,-12) | [(10,-10),(-3,-4)] | (-1.60487804878049,-4.64390243902439) | (10,10) | [(10,-10),(-3,-4)] | (2.39024390243902,-6.48780487804878) | (0,0) | [(-1000000,200),(300000,-40)] | (0.0028402365895872,15.384614860264) ! | (-10,0) | [(-1000000,200),(300000,-40)] | (-9.99715942258202,15.3864610140473) | (-3,4) | [(-1000000,200),(300000,-40)] | (-2.99789812267519,15.3851688427303) | (5.1,34.5) | [(-1000000,200),(300000,-40)] | (5.09647083221496,15.3836744976925) | (-5,-12) | [(-1000000,200),(300000,-40)] | (-4.99494420845634,15.3855375281616) --- 127,133 ---- | (-5,-12) | [(10,-10),(-3,-4)] | (-1.60487804878049,-4.64390243902439) | (10,10) | [(10,-10),(-3,-4)] | (2.39024390243902,-6.48780487804878) | (0,0) | [(-1000000,200),(300000,-40)] | (0.0028402365895872,15.384614860264) ! | (-10,0) | [(-1000000,200),(300000,-40)] | (-9.99715942258202,15.3864610140472) | (-3,4) | [(-1000000,200),(300000,-40)] | (-2.99789812267519,15.3851688427303) | (5.1,34.5) | [(-1000000,200),(300000,-40)] | (5.09647083221496,15.3836744976925) | (-5,-12) | [(-1000000,200),(300000,-40)] | (-4.99494420845634,15.3855375281616) *************** *** 152,158 **** | (2.12132034355964,2.12132034355964),(-2.12132034355964,-2.12132034355964) | (71.7106781186548,72.7106781186548),(-69.7106781186548,-68.7106781186548) | (4.53553390593274,6.53553390593274),(-2.53553390593274,-0.535533905932738) ! | (3.12132034355964,4.12132034355964),(-1.12132034355964,-0.121320343559642) | (107.071067811865,207.071067811865),(92.9289321881345,192.928932188135) | (170.710678118655,70.7106781186548),(29.2893218813452,-70.7106781186548) (6 rows) --- 152,158 ---- | (2.12132034355964,2.12132034355964),(-2.12132034355964,-2.12132034355964) | (71.7106781186548,72.7106781186548),(-69.7106781186548,-68.7106781186548) | (4.53553390593274,6.53553390593274),(-2.53553390593274,-0.535533905932738) ! | (3.12132034355964,4.12132034355964),(-1.12132034355964,-0.121320343559643) | (107.071067811865,207.071067811865),(92.9289321881345,192.928932188135) | (170.710678118655,70.7106781186548),(29.2893218813452,-70.7106781186548) (6 rows) *************** *** 504,510 **** ORDER BY distance, circle, point using <<; twentyfour | circle | point | distance ------------+----------------+------------+------------------- ! | <(100,0),100> | (5.1,34.5) | 0.976531926977965 | <(1,2),3> | (-3,4) | 1.47213595499958 | <(0,0),3> | (-3,4) | 2 | <(100,0),100> | (-3,4) | 3.07764064044151 --- 504,510 ---- ORDER BY distance, circle, point using <<; twentyfour | circle | point | distance ------------+----------------+------------+------------------- ! | <(100,0),100> | (5.1,34.5) | 0.976531926977964 | <(1,2),3> | (-3,4) | 1.47213595499958 | <(0,0),3> | (-3,4) | 2 | <(100,0),100> | (-3,4) | 3.07764064044151 *************** *** 519,525 **** | <(0,0),3> | (10,10) | 11.142135623731 | <(1,3),5> | (-5,-12) | 11.1554944214035 | <(1,2),3> | (-5,-12) | 12.2315462117278 ! | <(1,3),5> | (5.1,34.5) | 26.7657047773223 | <(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 --- 519,525 ---- | <(0,0),3> | (10,10) | 11.142135623731 | <(1,3),5> | (-5,-12) | 11.1554944214035 | <(1,2),3> | (-5,-12) | 12.2315462117278 ! | <(1,3),5> | (5.1,34.5) | 26.7657047773224 | <(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 ====================================================================== *** ./expected/select_implicit.out Tue Sep 12 17:07:17 2000 --- ./results/select_implicit.out Thu Nov 22 22:16:50 2001 *************** *** 22,32 **** c | count ----------+------- AAAA | 2 BBBB | 2 CCCC | 2 XXXX | 1 - bbbb | 1 - cccc | 2 (6 rows) -- w/o existing GROUP BY target using a relation name in GROUP BY clause --- 22,32 ---- c | count ----------+------- AAAA | 2 + bbbb | 1 BBBB | 2 + cccc | 2 CCCC | 2 XXXX | 1 (6 rows) -- w/o existing GROUP BY target using a relation name in GROUP BY clause *************** *** 34,44 **** count ------- 2 2 2 - 1 - 1 2 (6 rows) -- w/o existing GROUP BY target and w/o existing a different ORDER BY target --- 34,44 ---- count ------- 2 + 1 2 2 2 + 1 (6 rows) -- w/o existing GROUP BY target and w/o existing a different ORDER BY target *************** *** 104,114 **** c | count ----------+------- AAAA | 2 BBBB | 2 CCCC | 2 XXXX | 1 - bbbb | 1 - cccc | 2 (6 rows) -- group using reference number out of range --- 104,114 ---- c | count ----------+------- AAAA | 2 + bbbb | 1 BBBB | 2 + cccc | 2 CCCC | 2 XXXX | 1 (6 rows) -- group using reference number out of range ====================================================================== *** ./expected/select_having.out Thu Jan 6 01:40:54 2000 --- ./results/select_having.out Thu Nov 22 22:16:48 2001 *************** *** 34,41 **** GROUP BY c HAVING count(*) > 2 OR min(a) = max(a); c | max ----------+----- - XXXX | 0 bbbb | 5 (2 rows) DROP TABLE test_having; --- 34,41 ---- GROUP BY c HAVING count(*) > 2 OR min(a) = max(a); c | max ----------+----- bbbb | 5 + XXXX | 0 (2 rows) DROP TABLE test_having; ====================================================================== *** ./expected/select_views.out Sat Oct 13 13:41:11 2001 --- ./results/select_views.out Thu Nov 22 22:17:04 2001 *************** *** 467,472 **** --- 467,486 ---- I- 580 | 21 I- 580 | 22 I- 580 | 22 + I- 580/I-680 Ramp | 2 + I- 580/I-680 Ramp | 2 + I- 580/I-680 Ramp | 2 + I- 580/I-680 Ramp | 2 + I- 580/I-680 Ramp | 2 + I- 580/I-680 Ramp | 2 + I- 580/I-680 Ramp | 4 + I- 580/I-680 Ramp | 4 + I- 580/I-680 Ramp | 4 + I- 580/I-680 Ramp | 4 + I- 580/I-680 Ramp | 5 + I- 580/I-680 Ramp | 6 + I- 580/I-680 Ramp | 6 + I- 580/I-680 Ramp | 6 I- 580 Ramp | 2 I- 580 Ramp | 2 I- 580 Ramp | 2 *************** *** 717,736 **** I- 580 Ramp | 8 I- 580 Ramp | 8 I- 580 Ramp | 8 - I- 580/I-680 Ramp | 2 - I- 580/I-680 Ramp | 2 - I- 580/I-680 Ramp | 2 - I- 580/I-680 Ramp | 2 - I- 580/I-680 Ramp | 2 - I- 580/I-680 Ramp | 2 - I- 580/I-680 Ramp | 4 - I- 580/I-680 Ramp | 4 - I- 580/I-680 Ramp | 4 - I- 580/I-680 Ramp | 4 - I- 580/I-680 Ramp | 5 - I- 580/I-680 Ramp | 6 - I- 580/I-680 Ramp | 6 - I- 580/I-680 Ramp | 6 I- 680 | 2 I- 680 | 2 I- 680 | 2 --- 731,736 ---- ======================================================================