Skip site navigation (1) Skip section navigation (2)

Re: SunOS patch for memcmp()

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: tgl(at)sss(dot)pgh(dot)pa(dot)us
Cc: peter_e(at)gmx(dot)net, pgman(at)candle(dot)pha(dot)pa(dot)us, pgsql-patches(at)postgresql(dot)org
Subject: Re: SunOS patch for memcmp()
Date: 2001-12-20 01:45:53
Message-ID: 20011220104553D.t-ishii@sra.co.jp (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
> Clearly it should be tested, and I presume Tatsuo will do that,
> but my vote is to apply it.  Why should we drop SunOS off the list
> of supported ports?

Ok. I have tested patches from Bruce. Now tests for bit passed.
Remaining issues seem that strtol() is broken on SunOS4, not detecting
an overflow, which causes int4 and some of other tests failure. Should
we use our own strtol()?
--
Tatsuo Ishii

*** ./expected/int4.out	Wed Mar 15 08:06:56 2000
--- ./results/int4.out	Thu Dec 20 10:22:52 2001
***************
*** 14,20 ****
  INSERT INTO INT4_TBL(f1) VALUES ('-2147483647');
  -- bad input values -- should give warnings 
  INSERT INTO INT4_TBL(f1) VALUES ('1000000000000');
- ERROR:  pg_atoi: error reading "1000000000000": Numerical result out of range
  INSERT INTO INT4_TBL(f1) VALUES ('asdf');
  ERROR:  pg_atoi: error in "asdf": can't parse "asdf"
  SELECT '' AS five, INT4_TBL.*;
--- 14,19 ----
***************
*** 25,31 ****
        |     -123456
        |  2147483647
        | -2147483647
! (5 rows)
  
  SELECT '' AS four, i.* FROM INT4_TBL i WHERE i.f1 <> int2 '0';
   four |     f1      
--- 24,31 ----
        |     -123456
        |  2147483647
        | -2147483647
!       |  -727379968
! (6 rows)
  
  SELECT '' AS four, i.* FROM INT4_TBL i WHERE i.f1 <> int2 '0';
   four |     f1      
***************
*** 34,40 ****
        |     -123456
        |  2147483647
        | -2147483647
! (4 rows)
  
  SELECT '' AS four, i.* FROM INT4_TBL i WHERE i.f1 <> int4 '0';
   four |     f1      
--- 34,41 ----
        |     -123456
        |  2147483647
        | -2147483647
!       |  -727379968
! (5 rows)
  
  SELECT '' AS four, i.* FROM INT4_TBL i WHERE i.f1 <> int4 '0';
   four |     f1      
***************
*** 43,49 ****
        |     -123456
        |  2147483647
        | -2147483647
! (4 rows)
  
  SELECT '' AS one, i.* FROM INT4_TBL i WHERE i.f1 = int2 '0';
   one | f1 
--- 44,51 ----
        |     -123456
        |  2147483647
        | -2147483647
!       |  -727379968
! (5 rows)
  
  SELECT '' AS one, i.* FROM INT4_TBL i WHERE i.f1 = int2 '0';
   one | f1 
***************
*** 62,75 ****
  -----+-------------
       |     -123456
       | -2147483647
! (2 rows)
  
  SELECT '' AS two, i.* FROM INT4_TBL i WHERE i.f1 < int4 '0';
   two |     f1      
  -----+-------------
       |     -123456
       | -2147483647
! (2 rows)
  
  SELECT '' AS three, i.* FROM INT4_TBL i WHERE i.f1 <= int2 '0';
   three |     f1      
--- 64,79 ----
  -----+-------------
       |     -123456
       | -2147483647
!      |  -727379968
! (3 rows)
  
  SELECT '' AS two, i.* FROM INT4_TBL i WHERE i.f1 < int4 '0';
   two |     f1      
  -----+-------------
       |     -123456
       | -2147483647
!      |  -727379968
! (3 rows)
  
  SELECT '' AS three, i.* FROM INT4_TBL i WHERE i.f1 <= int2 '0';
   three |     f1      
***************
*** 77,83 ****
         |           0
         |     -123456
         | -2147483647
! (3 rows)
  
  SELECT '' AS three, i.* FROM INT4_TBL i WHERE i.f1 <= int4 '0';
   three |     f1      
--- 81,88 ----
         |           0
         |     -123456
         | -2147483647
!        |  -727379968
! (4 rows)
  
  SELECT '' AS three, i.* FROM INT4_TBL i WHERE i.f1 <= int4 '0';
   three |     f1      
***************
*** 85,91 ****
         |           0
         |     -123456
         | -2147483647
! (3 rows)
  
  SELECT '' AS two, i.* FROM INT4_TBL i WHERE i.f1 > int2 '0';
   two |     f1     
--- 90,97 ----
         |           0
         |     -123456
         | -2147483647
!        |  -727379968
! (4 rows)
  
  SELECT '' AS two, i.* FROM INT4_TBL i WHERE i.f1 > int2 '0';
   two |     f1     
***************
*** 127,157 ****
  -- any evens 
  SELECT '' AS three, i.* FROM INT4_TBL i WHERE (i.f1 % int4 '2') = int2 '0';
   three |   f1    
! -------+---------
         |       0
         |  123456
         | -123456
! (3 rows)
  
  SELECT '' AS five, i.f1, i.f1 * int2 '2' AS x FROM INT4_TBL i;
   five |     f1      |    x    
! ------+-------------+---------
        |           0 |       0
        |      123456 |  246912
        |     -123456 | -246912
        |  2147483647 |      -2
        | -2147483647 |       2
! (5 rows)
  
  SELECT '' AS five, i.f1, i.f1 * int4 '2' AS x FROM INT4_TBL i;
   five |     f1      |    x    
! ------+-------------+---------
        |           0 |       0
        |      123456 |  246912
        |     -123456 | -246912
        |  2147483647 |      -2
        | -2147483647 |       2
! (5 rows)
  
  SELECT '' AS five, i.f1, i.f1 + int2 '2' AS x FROM INT4_TBL i;
   five |     f1      |      x      
--- 133,166 ----
  -- any evens 
  SELECT '' AS three, i.* FROM INT4_TBL i WHERE (i.f1 % int4 '2') = int2 '0';
   three |     f1     
! -------+------------
         |          0
         |     123456
         |    -123456
!        | -727379968
! (4 rows)
  
  SELECT '' AS five, i.f1, i.f1 * int2 '2' AS x FROM INT4_TBL i;
   five |     f1      |      x      
! ------+-------------+-------------
        |           0 |           0
        |      123456 |      246912
        |     -123456 |     -246912
        |  2147483647 |          -2
        | -2147483647 |           2
!       |  -727379968 | -1454759936
! (6 rows)
  
  SELECT '' AS five, i.f1, i.f1 * int4 '2' AS x FROM INT4_TBL i;
   five |     f1      |      x      
! ------+-------------+-------------
        |           0 |           0
        |      123456 |      246912
        |     -123456 |     -246912
        |  2147483647 |          -2
        | -2147483647 |           2
!       |  -727379968 | -1454759936
! (6 rows)
  
  SELECT '' AS five, i.f1, i.f1 + int2 '2' AS x FROM INT4_TBL i;
   five |     f1      |      x      
***************
*** 161,167 ****
        |     -123456 |     -123454
        |  2147483647 | -2147483647
        | -2147483647 | -2147483645
! (5 rows)
  
  SELECT '' AS five, i.f1, i.f1 + int4 '2' AS x FROM INT4_TBL i;
   five |     f1      |      x      
--- 170,177 ----
        |     -123456 |     -123454
        |  2147483647 | -2147483647
        | -2147483647 | -2147483645
!       |  -727379968 |  -727379966
! (6 rows)
  
  SELECT '' AS five, i.f1, i.f1 + int4 '2' AS x FROM INT4_TBL i;
   five |     f1      |      x      
***************
*** 171,177 ****
        |     -123456 |     -123454
        |  2147483647 | -2147483647
        | -2147483647 | -2147483645
! (5 rows)
  
  SELECT '' AS five, i.f1, i.f1 - int2 '2' AS x FROM INT4_TBL i;
   five |     f1      |     x      
--- 181,188 ----
        |     -123456 |     -123454
        |  2147483647 | -2147483647
        | -2147483647 | -2147483645
!       |  -727379968 |  -727379966
! (6 rows)
  
  SELECT '' AS five, i.f1, i.f1 - int2 '2' AS x FROM INT4_TBL i;
   five |     f1      |     x      
***************
*** 181,187 ****
        |     -123456 |    -123458
        |  2147483647 | 2147483645
        | -2147483647 | 2147483647
! (5 rows)
  
  SELECT '' AS five, i.f1, i.f1 - int4 '2' AS x FROM INT4_TBL i;
   five |     f1      |     x      
--- 192,199 ----
        |     -123456 |    -123458
        |  2147483647 | 2147483645
        | -2147483647 | 2147483647
!       |  -727379968 | -727379970
! (6 rows)
  
  SELECT '' AS five, i.f1, i.f1 - int4 '2' AS x FROM INT4_TBL i;
   five |     f1      |     x      
***************
*** 191,197 ****
        |     -123456 |    -123458
        |  2147483647 | 2147483645
        | -2147483647 | 2147483647
! (5 rows)
  
  SELECT '' AS five, i.f1, i.f1 / int2 '2' AS x FROM INT4_TBL i;
   five |     f1      |      x      
--- 203,210 ----
        |     -123456 |    -123458
        |  2147483647 | 2147483645
        | -2147483647 | 2147483647
!       |  -727379968 | -727379970
! (6 rows)
  
  SELECT '' AS five, i.f1, i.f1 / int2 '2' AS x FROM INT4_TBL i;
   five |     f1      |      x      
***************
*** 201,207 ****
        |     -123456 |      -61728
        |  2147483647 |  1073741823
        | -2147483647 | -1073741823
! (5 rows)
  
  SELECT '' AS five, i.f1, i.f1 / int4 '2' AS x FROM INT4_TBL i;
   five |     f1      |      x      
--- 214,221 ----
        |     -123456 |      -61728
        |  2147483647 |  1073741823
        | -2147483647 | -1073741823
!       |  -727379968 |  -363689984
! (6 rows)
  
  SELECT '' AS five, i.f1, i.f1 / int4 '2' AS x FROM INT4_TBL i;
   five |     f1      |      x      
***************
*** 211,217 ****
        |     -123456 |      -61728
        |  2147483647 |  1073741823
        | -2147483647 | -1073741823
! (5 rows)
  
  --
  -- more complex expressions
--- 225,232 ----
        |     -123456 |      -61728
        |  2147483647 |  1073741823
        | -2147483647 | -1073741823
!       |  -727379968 |  -363689984
! (6 rows)
  
  --
  -- more complex expressions

======================================================================

*** ./expected/numerology.out	Thu Mar 16 08:31:06 2000
--- ./results/numerology.out	Thu Dec 20 10:25:54 2001
***************
*** 17,22 ****
--- 17,23 ----
   ten |     f1      
  -----+-------------
       | -2147483647
+      |  -727379968
       |     -123456
       |      -32767
       |       -1234
***************
*** 26,32 ****
       |       32767
       |      123456
       |  2147483647
! (10 rows)
  
  -- int4
  CREATE TABLE TEMP_INT4 (f1 INT4);
--- 27,33 ----
       |       32767
       |      123456
       |  2147483647
! (11 rows)
  
  -- int4
  CREATE TABLE TEMP_INT4 (f1 INT4);

======================================================================

*** ./expected/geometry.out	Fri Nov 30 03:57:31 2001
--- ./results/geometry.out	Thu Dec 20 10:26:46 2001
***************
*** 150,160 ****
   six |                                    box                                     
  -----+----------------------------------------------------------------------------
       | (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)
  
  -- translation
--- 150,160 ----
   six |                                    box                                     
  -----+----------------------------------------------------------------------------
       | (2.12132034355964,2.12132034355964),(-2.12132034355964,-2.12132034355964)
!      | (71.7106781186547,72.7106781186547),(-69.7106781186547,-68.7106781186547)
!      | (4.53553390593274,6.53553390593274),(-2.53553390593274,-0.535533905932737)
!      | (3.12132034355964,4.12132034355964),(-1.12132034355964,-0.121320343559642)
       | (107.071067811865,207.071067811865),(92.9289321881345,192.928932188135)
!      | (170.710678118655,70.7106781186547),(29.2893218813453,-70.7106781186547)
  (6 rows)
  
  -- translation
***************
*** 445,452 ****
  -----+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
       | ((-3,0),(-2.59807621135076,1.50000000000442),(-1.49999999999116,2.59807621135842),(1.53102359078377e-11,3),(1.50000000001768,2.59807621134311),(2.59807621136607,1.4999999999779),(3,-3.06204718156754e-11),(2.59807621133545,-1.50000000003094),(1.49999999996464,-2.59807621137373),(-4.59307077235131e-11,-3),(-1.5000000000442,-2.5980762113278),(-2.59807621138138,-1.49999999995138))
       | ((-99,2),(-85.6025403783588,52.0000000001473),(-48.9999999997054,88.602540378614),(1.00000000051034,102),(51.0000000005893,88.6025403781036),(87.6025403788692,51.9999999992634),(101,1.99999999897932),(87.6025403778485,-48.0000000010313),(50.9999999988214,-84.6025403791243),(0.999999998468976,-98),(-49.0000000014732,-84.6025403775933),(-85.6025403793795,-47.9999999983795))
!      | ((-4,3),(-3.33012701891794,5.50000000000737),(-1.49999999998527,7.3301270189307),(1.00000000002552,8),(3.50000000002946,7.33012701890518),(5.33012701894346,5.49999999996317),(6,2.99999999994897),(5.33012701889242,0.499999999948437),(3.49999999994107,-1.33012701895622),(0.999999999923449,-2),(-1.50000000007366,-1.33012701887966),(-3.33012701896897,0.500000000081028))
!      | ((-2,2),(-1.59807621135076,3.50000000000442),(-0.499999999991161,4.59807621135842),(1.00000000001531,5),(2.50000000001768,4.59807621134311),(3.59807621136607,3.4999999999779),(4,1.99999999996938),(3.59807621133545,0.499999999969062),(2.49999999996464,-0.59807621137373),(0.999999999954069,-1),(-0.500000000044197,-0.598076211327799),(-1.59807621138138,0.500000000048617))
       | ((90,200),(91.3397459621641,205.000000000015),(95.0000000000295,208.660254037861),(100.000000000051,210),(105.000000000059,208.66025403781),(108.660254037887,204.999999999926),(110,199.999999999898),(108.660254037785,194.999999999897),(104.999999999882,191.339745962088),(99.9999999998469,190),(94.9999999998527,191.339745962241),(91.3397459620621,195.000000000162))
       | ((0,0),(13.3974596216412,50.0000000001473),(50.0000000002946,86.602540378614),(100.00000000051,100),(150.000000000589,86.6025403781036),(186.602540378869,49.9999999992634),(200,-1.02068239385585e-09),(186.602540377848,-50.0000000010313),(149.999999998821,-86.6025403791243),(99.999999998469,-100),(49.9999999985268,-86.6025403775933),(13.3974596206205,-49.9999999983795))
  (6 rows)
--- 445,452 ----
  -----+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
       | ((-3,0),(-2.59807621135076,1.50000000000442),(-1.49999999999116,2.59807621135842),(1.53102359078377e-11,3),(1.50000000001768,2.59807621134311),(2.59807621136607,1.4999999999779),(3,-3.06204718156754e-11),(2.59807621133545,-1.50000000003094),(1.49999999996464,-2.59807621137373),(-4.59307077235131e-11,-3),(-1.5000000000442,-2.5980762113278),(-2.59807621138138,-1.49999999995138))
       | ((-99,2),(-85.6025403783588,52.0000000001473),(-48.9999999997054,88.602540378614),(1.00000000051034,102),(51.0000000005893,88.6025403781036),(87.6025403788692,51.9999999992634),(101,1.99999999897932),(87.6025403778485,-48.0000000010313),(50.9999999988214,-84.6025403791243),(0.999999998468976,-98),(-49.0000000014732,-84.6025403775933),(-85.6025403793795,-47.9999999983795))
!      | ((-4,3),(-3.33012701891794,5.50000000000737),(-1.49999999998527,7.3301270189307),(1.00000000002552,8),(3.50000000002946,7.33012701890518),(5.33012701894346,5.49999999996317),(6,2.99999999994897),(5.33012701889242,0.499999999948437),(3.49999999994107,-1.33012701895622),(0.999999999923449,-2),(-1.50000000007366,-1.33012701887967),(-3.33012701896897,0.500000000081028))
!      | ((-2,2),(-1.59807621135076,3.50000000000442),(-0.499999999991161,4.59807621135842),(1.00000000001531,5),(2.50000000001768,4.59807621134311),(3.59807621136607,3.4999999999779),(4,1.99999999996938),(3.59807621133545,0.499999999969062),(2.49999999996464,-0.598076211373729),(0.999999999954069,-1),(-0.500000000044197,-0.598076211327799),(-1.59807621138138,0.500000000048616))
       | ((90,200),(91.3397459621641,205.000000000015),(95.0000000000295,208.660254037861),(100.000000000051,210),(105.000000000059,208.66025403781),(108.660254037887,204.999999999926),(110,199.999999999898),(108.660254037785,194.999999999897),(104.999999999882,191.339745962088),(99.9999999998469,190),(94.9999999998527,191.339745962241),(91.3397459620621,195.000000000162))
       | ((0,0),(13.3974596216412,50.0000000001473),(50.0000000002946,86.602540378614),(100.00000000051,100),(150.000000000589,86.6025403781036),(186.602540378869,49.9999999992634),(200,-1.02068239385585e-09),(186.602540377848,-50.0000000010313),(149.999999998821,-86.6025403791243),(99.999999998469,-100),(49.9999999985268,-86.6025403775933),(13.3974596206205,-49.9999999983795))
  (6 rows)
***************
*** 457,467 ****
   six |                                                                                                                  polygon                                                                                                                  
  -----+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
       | ((-3,0),(-2.12132034355423,2.12132034356506),(1.53102359078377e-11,3),(2.12132034357588,2.1213203435434),(3,-3.06204718156754e-11),(2.12132034353258,-2.12132034358671),(-4.59307077235131e-11,-3),(-2.12132034359753,-2.12132034352175))
!      | ((-99,2),(-69.7106781184743,72.7106781188352),(1.00000000051034,102),(71.710678119196,72.7106781181134),(101,1.99999999897932),(71.7106781177526,-68.7106781195569),(0.999999998468976,-98),(-69.7106781199178,-68.7106781173917))
       | ((-4,3),(-2.53553390592372,6.53553390594176),(1.00000000002552,8),(4.5355339059598,6.53553390590567),(6,2.99999999994897),(4.53553390588763,-0.535533905977846),(0.999999999923449,-2),(-2.53553390599589,-0.535533905869586))
       | ((-2,2),(-1.12132034355423,4.12132034356506),(1.00000000001531,5),(3.12132034357588,4.1213203435434),(4,1.99999999996938),(3.12132034353258,-0.121320343586707),(0.999999999954069,-1),(-1.12132034359753,-0.121320343521752))
       | ((90,200),(92.9289321881526,207.071067811884),(100.000000000051,210),(107.07106781192,207.071067811811),(110,199.999999999898),(107.071067811775,192.928932188044),(99.9999999998469,190),(92.9289321880082,192.928932188261))
!      | ((0,0),(29.2893218815257,70.7106781188352),(100.00000000051,100),(170.710678119196,70.7106781181134),(200,-1.02068239385585e-09),(170.710678117753,-70.7106781195569),(99.999999998469,-100),(29.2893218800822,-70.7106781173917))
  (6 rows)
  
  --
--- 457,467 ----
   six |                                                                                                                  polygon                                                                                                                  
  -----+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
       | ((-3,0),(-2.12132034355423,2.12132034356506),(1.53102359078377e-11,3),(2.12132034357588,2.1213203435434),(3,-3.06204718156754e-11),(2.12132034353258,-2.12132034358671),(-4.59307077235131e-11,-3),(-2.12132034359753,-2.12132034352175))
!      | ((-99,2),(-69.7106781184743,72.7106781188352),(1.00000000051034,102),(71.710678119196,72.7106781181135),(101,1.99999999897932),(71.7106781177526,-68.7106781195569),(0.999999998468976,-98),(-69.7106781199178,-68.7106781173917))
       | ((-4,3),(-2.53553390592372,6.53553390594176),(1.00000000002552,8),(4.5355339059598,6.53553390590567),(6,2.99999999994897),(4.53553390588763,-0.535533905977846),(0.999999999923449,-2),(-2.53553390599589,-0.535533905869586))
       | ((-2,2),(-1.12132034355423,4.12132034356506),(1.00000000001531,5),(3.12132034357588,4.1213203435434),(4,1.99999999996938),(3.12132034353258,-0.121320343586707),(0.999999999954069,-1),(-1.12132034359753,-0.121320343521752))
       | ((90,200),(92.9289321881526,207.071067811884),(100.000000000051,210),(107.07106781192,207.071067811811),(110,199.999999999898),(107.071067811775,192.928932188044),(99.9999999998469,190),(92.9289321880082,192.928932188261))
!      | ((0,0),(29.2893218815257,70.7106781188352),(100.00000000051,100),(170.710678119196,70.7106781181135),(200,-1.02068239385585e-09),(170.710678117753,-70.7106781195569),(99.999999998469,-100),(29.2893218800822,-70.7106781173917))
  (6 rows)
  
  --
***************
*** 503,513 ****
     WHERE (p1.f1 <-> c1.f1) > 0
     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
              | <(100,0),100>  | (-5,-12)   |  5.68348972285122
              | <(1,3),5>      | (-10,0)    |  6.40175425099138
              | <(1,3),5>      | (10,10)    |  6.40175425099138
--- 503,513 ----
     WHERE (p1.f1 <-> c1.f1) > 0
     ORDER BY distance, circle, point using <<;
   twentyfour |     circle     |   point    |     distance     
! ------------+----------------+------------+------------------
!             | <(100,0),100>  | (5.1,34.5) | 0.97653192697797
              | <(1,2),3>      | (-3,4)     | 1.47213595499958
              | <(0,0),3>      | (-3,4)     |                2
!             | <(100,0),100>  | (-3,4)     | 3.07764064044152
              | <(100,0),100>  | (-5,-12)   | 5.68348972285122
              | <(1,3),5>      | (-10,0)    | 6.40175425099138
              | <(1,3),5>      | (10,10)    | 6.40175425099138
***************
*** 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
--- 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

======================================================================

*** ./expected/horology.out	Thu Nov 22 03:27:25 2001
--- ./results/horology.out	Thu Dec 20 10:26:49 2001
***************
*** 1499,1508 ****
       | Wed Mar 15 13:14:02 2000 PST | @ 34 years                    | Tue Mar 15 13:14:02 1966 PST
       | Sun Dec 31 17:32:01 2000 PST | @ 34 years                    | Sat Dec 31 17:32:01 1966 PST
       | Mon Jan 01 17:32:01 2001 PST | @ 34 years                    | Sun Jan 01 17:32:01 1967 PST
!      | Sat Sep 22 18:19:20 2001 PDT | @ 34 years                    | Fri Sep 22 18:19:20 1967 PDT
!      | Thu Jan 01 00:00:00 1970 PST | @ 5 mons 12 hours             | Thu Jul 31 13:00:00 1969 PDT
!      | Thu Jan 01 00:00:00 1970 PST | @ 5 mons                      | Fri Aug 01 01:00:00 1969 PDT
!      | Thu Jan 01 00:00:00 1970 PST | @ 3 mons                      | Wed Oct 01 01:00:00 1969 PDT
       | Thu Jan 01 00:00:00 1970 PST | @ 10 days                     | Mon Dec 22 00:00:00 1969 PST
       | Thu Jan 01 00:00:00 1970 PST | @ 1 day 2 hours 3 mins 4 secs | Tue Dec 30 21:56:56 1969 PST
       | Thu Jan 01 00:00:00 1970 PST | @ 5 hours                     | Wed Dec 31 19:00:00 1969 PST
--- 1499,1508 ----
       | Wed Mar 15 13:14:02 2000 PST | @ 34 years                    | Tue Mar 15 13:14:02 1966 PST
       | Sun Dec 31 17:32:01 2000 PST | @ 34 years                    | Sat Dec 31 17:32:01 1966 PST
       | Mon Jan 01 17:32:01 2001 PST | @ 34 years                    | Sun Jan 01 17:32:01 1967 PST
!      | Sat Sep 22 18:19:20 2001 PDT | @ 34 years                    | Fri Sep 22 17:19:20 1967 PST
!      | Thu Jan 01 00:00:00 1970 PST | @ 5 mons 12 hours             | Thu Jul 31 12:00:00 1969 PST
!      | Thu Jan 01 00:00:00 1970 PST | @ 5 mons                      | Fri Aug 01 00:00:00 1969 PST
!      | Thu Jan 01 00:00:00 1970 PST | @ 3 mons                      | Wed Oct 01 00:00:00 1969 PST
       | Thu Jan 01 00:00:00 1970 PST | @ 10 days                     | Mon Dec 22 00:00:00 1969 PST
       | Thu Jan 01 00:00:00 1970 PST | @ 1 day 2 hours 3 mins 4 secs | Tue Dec 30 21:56:56 1969 PST
       | Thu Jan 01 00:00:00 1970 PST | @ 5 hours                     | Wed Dec 31 19:00:00 1969 PST

======================================================================

*** ./expected/union.out	Thu Nov  9 11:47:49 2000
--- ./results/union.out	Thu Dec 20 10:28:50 2001
***************
*** 163,168 ****
--- 163,169 ----
  -----------------------
   -1.2345678901234e+200
             -2147483647
+             -727379968
                 -123456
                 -1004.3
                  -34.84
***************
*** 170,176 ****
                       0
                  123456
              2147483647
! (9 rows)
  
  SELECT f1 AS ten FROM FLOAT8_TBL
  UNION ALL
--- 171,177 ----
                       0
                  123456
              2147483647
! (10 rows)
  
  SELECT f1 AS ten FROM FLOAT8_TBL
  UNION ALL
***************
*** 187,193 ****
                 -123456
              2147483647
             -2147483647
! (10 rows)
  
  SELECT f1 AS five FROM FLOAT8_TBL
    WHERE f1 BETWEEN -1e6 AND 1e6
--- 188,195 ----
                 -123456
              2147483647
             -2147483647
!             -727379968
! (11 rows)
  
  SELECT f1 AS five FROM FLOAT8_TBL
    WHERE f1 BETWEEN -1e6 AND 1e6

======================================================================

*** ./expected/random.out	Thu Jan  6 15:40:54 2000
--- ./results/random.out	Thu Dec 20 10:28:58 2001
***************
*** 25,31 ****
    GROUP BY random HAVING count(random) > 1;
   random | count 
  --------+-------
! (0 rows)
  
  SELECT random FROM RANDOM_TBL
    WHERE random NOT BETWEEN 80 AND 120;
--- 25,32 ----
    GROUP BY random HAVING count(random) > 1;
   random | count 
  --------+-------
!     105 |     2
! (1 row)
  
  SELECT random FROM RANDOM_TBL
    WHERE random NOT BETWEEN 80 AND 120;

======================================================================


In response to

Responses

pgsql-hackers by date

Next:From: Christopher Kings-LynneDate: 2001-12-20 02:02:42
Subject: Re: 7.2 is slow? [compile problem]
Previous:From: Don BaccusDate: 2001-12-20 01:45:35
Subject: Re: Concerns about this release

pgsql-patches by date

Next:From: Christopher Kings-LynneDate: 2001-12-20 02:53:56
Subject: Geometry patch for freebsd alpha
Previous:From: Tom LaneDate: 2001-12-19 19:58:48
Subject: Re: SunOS patch for memcmp()

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group