*** expected/int8.out	Fri Apr  7 14:17:39 2000
--- results/int8.out	Sat Sep 16 23:55:08 2000
***************
*** 246,256 ****
  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;
--- 246,256 ----
  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 14:17:42 2000
--- results/numeric.out	Sat Sep 16 23:55:44 2000
***************
*** 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/select_implicit.out	Thu Jan  6 00:40:54 2000
--- results/select_implicit.out	Sat Sep 16 23:57:09 2000
***************
*** 23,32 ****
  ----------+-------
   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
--- 23,32 ----
  ----------+-------
   AAAA     |     2
   BBBB     |     2
   bbbb     |     1
+  CCCC     |     2
   cccc     |     2
+  XXXX     |     1
  (6 rows)
  
  --   w/o existing GROUP BY target using a relation name in GROUP BY clause
***************
*** 35,44 ****
  -------
       2
       2
-      2
-      1
       1
       2
  (6 rows)
  
  --   w/o existing GROUP BY target and w/o existing a different ORDER BY target
--- 35,44 ----
  -------
       2
       2
       1
       2
+      2
+      1
  (6 rows)
  
  --   w/o existing GROUP BY target and w/o existing a different ORDER BY target
***************
*** 105,114 ****
  ----------+-------
   AAAA     |     2
   BBBB     |     2
-  CCCC     |     2
-  XXXX     |     1
   bbbb     |     1
   cccc     |     2
  (6 rows)
  
  --   group using reference number out of range
--- 105,114 ----
  ----------+-------
   AAAA     |     2
   BBBB     |     2
   bbbb     |     1
+  CCCC     |     2
   cccc     |     2
+  XXXX     |     1
  (6 rows)
  
  --   group using reference number out of range

----------------------

*** expected/select_having.out	Thu Jan  6 00:40:54 2000
--- results/select_having.out	Sat Sep 16 23:57:10 2000
***************
*** 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 Jan  8 21:48:37 2000
--- results/select_views.out	Sat Sep 16 23:57:24 2000
***************
*** 415,420 ****
--- 415,434 ----
   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
***************
*** 665,684 ****
   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
--- 679,684 ----

----------------------