开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > 数据库系统 > 查看源码
regression.FreeBSD
资源名称：postgresql-6.5.2.tar.gz　[点击查看]
上传用户：blenddy
上传日期：2007-01-07
资源大小：6495k
文件大小：35k
源码类别：

数据库系统

开发平台：

Unix_Linux

regression.FreeBSD：源码内容
  2. *** expected/float8.out Thu Mar 19 00:49:38 1998
  3. --- results/float8.out Sun Mar 22 15:36:24 1998
  4. ***************
  5. *** 9,17 ****
  6.   QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e400');
  7.   ERROR:  Bad float8 input format '-10e400'
  8.   QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('10e-400');
  9. - ERROR:  Bad float8 input format '10e-400'
  10.   QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e-400');
  11. - ERROR:  Bad float8 input format '-10e-400'
  12.   QUERY: SELECT '' AS five, FLOAT8_TBL.*;
  13.   five|f1                  
  14.   ----+--------------------
  15. --- 9,15 ----
  16. ***************
  17. *** 20,26 ****
  18.       |-34.84              
  19.       |1.2345678901234e+200
  20.       |1.2345678901234e-200
  21. ! (5 rows)
  22.   
  23.   QUERY: SELECT '' AS four, f.* FROM FLOAT8_TBL f WHERE f.f1 <> '1004.3';
  24.   four|f1                  
  25. --- 18,26 ----
  26.       |-34.84              
  27.       |1.2345678901234e+200
  28.       |1.2345678901234e-200
  29. !     |0                   
  30. !     |0                   
  31. ! (7 rows)
  32.   
  33.   QUERY: SELECT '' AS four, f.* FROM FLOAT8_TBL f WHERE f.f1 <> '1004.3';
  34.   four|f1                  
  35. ***************
  36. *** 29,35 ****
  37.       |-34.84              
  38.       |1.2345678901234e+200
  39.       |1.2345678901234e-200
  40. ! (4 rows)
  41.   
  42.   QUERY: SELECT '' AS one, f.* FROM FLOAT8_TBL f WHERE f.f1 = '1004.3';
  43.   one|    f1
  44. --- 29,37 ----
  45.       |-34.84              
  46.       |1.2345678901234e+200
  47.       |1.2345678901234e-200
  48. !     |0                   
  49. !     |0                   
  50. ! (6 rows)
  51.   
  52.   QUERY: SELECT '' AS one, f.* FROM FLOAT8_TBL f WHERE f.f1 = '1004.3';
  53.   one|    f1
  54. ***************
  55. *** 43,49 ****
  56.        |                   0
  57.        |              -34.84
  58.        |1.2345678901234e-200
  59. ! (3 rows)
  60.   
  61.   QUERY: SELECT '' AS three, f.* FROM FLOAT8_TBL f WHERE  f.f1 < '1004.3';
  62.   three|                  f1
  63. --- 45,53 ----
  64.        |                   0
  65.        |              -34.84
  66.        |1.2345678901234e-200
  67. !      |                   0
  68. !      |                   0
  69. ! (5 rows)
  70.   
  71.   QUERY: SELECT '' AS three, f.* FROM FLOAT8_TBL f WHERE  f.f1 < '1004.3';
  72.   three|                  f1
  73. ***************
  74. *** 51,57 ****
  75.        |                   0
  76.        |              -34.84
  77.        |1.2345678901234e-200
  78. ! (3 rows)
  79.   
  80.   QUERY: SELECT '' AS four, f.* FROM FLOAT8_TBL f WHERE '1004.3' >= f.f1;
  81.   four|                  f1
  82. --- 55,63 ----
  83.        |                   0
  84.        |              -34.84
  85.        |1.2345678901234e-200
  86. !      |                   0
  87. !      |                   0
  88. ! (5 rows)
  89.   
  90.   QUERY: SELECT '' AS four, f.* FROM FLOAT8_TBL f WHERE '1004.3' >= f.f1;
  91.   four|                  f1
  92. ***************
  93. *** 60,66 ****
  94.       |              1004.3
  95.       |              -34.84
  96.       |1.2345678901234e-200
  97. ! (4 rows)
  98.   
  99.   QUERY: SELECT '' AS four, f.* FROM FLOAT8_TBL f WHERE  f.f1 <= '1004.3';
  100.   four|                  f1
  101. --- 66,74 ----
  102.       |              1004.3
  103.       |              -34.84
  104.       |1.2345678901234e-200
  105. !     |                   0
  106. !     |                   0
  107. ! (6 rows)
  108.   
  109.   QUERY: SELECT '' AS four, f.* FROM FLOAT8_TBL f WHERE  f.f1 <= '1004.3';
  110.   four|                  f1
  111. ***************
  112. *** 69,75 ****
  113.       |              1004.3
  114.       |              -34.84
  115.       |1.2345678901234e-200
  116. ! (4 rows)
  117.   
  118.   QUERY: SELECT '' AS three, f.f1, f.f1 * '-10' AS x
  119.      FROM FLOAT8_TBL f
  120. --- 77,85 ----
  121.       |              1004.3
  122.       |              -34.84
  123.       |1.2345678901234e-200
  124. !     |                   0
  125. !     |                   0
  126. ! (6 rows)
  127.   
  128.   QUERY: SELECT '' AS three, f.f1, f.f1 * '-10' AS x
  129.      FROM FLOAT8_TBL f
  130. ***************
  131. *** 127,133 ****
  132.       |-34.84              |34.84               
  133.       |1.2345678901234e+200|1.2345678901234e+200
  134.       |1.2345678901234e-200|1.2345678901234e-200
  135. ! (5 rows)
  136.   
  137.   QUERY: SELECT '' AS five, f.f1, %f.f1 AS trunc_f1
  138.      FROM FLOAT8_TBL f;
  139. --- 137,145 ----
  140.       |-34.84              |34.84               
  141.       |1.2345678901234e+200|1.2345678901234e+200
  142.       |1.2345678901234e-200|1.2345678901234e-200
  143. !     |0                   |0                   
  144. !     |0                   |0                   
  145. ! (7 rows)
  146.   
  147.   QUERY: SELECT '' AS five, f.f1, %f.f1 AS trunc_f1
  148.      FROM FLOAT8_TBL f;
  149. ***************
  150. *** 138,144 ****
  151.       |-34.84              |-34                 
  152.       |1.2345678901234e+200|1.2345678901234e+200
  153.       |1.2345678901234e-200|0                   
  154. ! (5 rows)
  155.   
  156.   QUERY: SELECT '' AS five, f.f1, f.f1 % AS round_f1
  157.      FROM FLOAT8_TBL f;
  158. --- 150,158 ----
  159.       |-34.84              |-34                 
  160.       |1.2345678901234e+200|1.2345678901234e+200
  161.       |1.2345678901234e-200|0                   
  162. !     |0                   |0                   
  163. !     |0                   |0                   
  164. ! (7 rows)
  165.   
  166.   QUERY: SELECT '' AS five, f.f1, f.f1 % AS round_f1
  167.      FROM FLOAT8_TBL f;
  168. ***************
  169. *** 149,155 ****
  170.       |-34.84              |-35                 
  171.       |1.2345678901234e+200|1.2345678901234e+200
  172.       |1.2345678901234e-200|0                   
  173. ! (5 rows)
  174.   
  175.   QUERY: SELECT '' AS three, f.f1, |/f.f1 AS sqrt_f1
  176.      FROM FLOAT8_TBL f
  177. --- 163,171 ----
  178.       |-34.84              |-35                 
  179.       |1.2345678901234e+200|1.2345678901234e+200
  180.       |1.2345678901234e-200|0                   
  181. !     |0                   |0                   
  182. !     |0                   |0                   
  183. ! (7 rows)
  184.   
  185.   QUERY: SELECT '' AS three, f.f1, |/f.f1 AS sqrt_f1
  186.      FROM FLOAT8_TBL f
  187. ***************
  188. *** 179,185 ****
  189.       |-34.84              |-3.26607421344208   
  190.       |1.2345678901234e+200|4.97933859234765e+66
  191.       |1.2345678901234e-200|2.3112042409018e-67 
  192. ! (5 rows)
  193.   
  194.   QUERY: SELECT '' AS five, FLOAT8_TBL.*;
  195.   five|f1                  
  196. --- 195,203 ----
  197.       |-34.84              |-3.26607421344208   
  198.       |1.2345678901234e+200|4.97933859234765e+66
  199.       |1.2345678901234e-200|2.3112042409018e-67 
  200. !     |0                   |0                   
  201. !     |0                   |0                   
  202. ! (7 rows)
  203.   
  204.   QUERY: SELECT '' AS five, FLOAT8_TBL.*;
  205.   five|f1                  
  206. ***************
  207. *** 189,203 ****
  208.       |-34.84              
  209.       |1.2345678901234e+200
  210.       |1.2345678901234e-200
  211. ! (5 rows)
  212.   
  213.   QUERY: UPDATE FLOAT8_TBL
  214.      SET f1 = FLOAT8_TBL.f1 * '-1'
  215.      WHERE FLOAT8_TBL.f1 > '0.0';
  216.   QUERY: SELECT '' AS bad, f.f1 * '1e200' from FLOAT8_TBL f;
  217. ! ERROR:  Bad float8 input format -- overflow
  218.   QUERY: SELECT '' AS bad, f.f1 ^ '1e200' from FLOAT8_TBL f;
  219. ! ERROR:  pow() result is out of range
  220.   QUERY: SELECT '' AS bad, (; (f.f1)) from FLOAT8_TBL f where f.f1 = '0.0' ;
  221.   ERROR:  can't take log of zero
  222.   QUERY: SELECT '' AS bad, (; (f.f1)) from FLOAT8_TBL f where f.f1 < '0.0' ;
  223. --- 207,223 ----
  224.       |-34.84              
  225.       |1.2345678901234e+200
  226.       |1.2345678901234e-200
  227. !     |0                   
  228. !     |0                   
  229. ! (7 rows)
  230.   
  231.   QUERY: UPDATE FLOAT8_TBL
  232.      SET f1 = FLOAT8_TBL.f1 * '-1'
  233.      WHERE FLOAT8_TBL.f1 > '0.0';
  234.   QUERY: SELECT '' AS bad, f.f1 * '1e200' from FLOAT8_TBL f;
  235. ! ERROR:  floating point exception! The last floating point operation either exceeded legal ranges or was a divide by zero
  236.   QUERY: SELECT '' AS bad, f.f1 ^ '1e200' from FLOAT8_TBL f;
  237. ! ERROR:  Bad float8 input format -- overflow
  238.   QUERY: SELECT '' AS bad, (; (f.f1)) from FLOAT8_TBL f where f.f1 = '0.0' ;
  239.   ERROR:  can't take log of zero
  240.   QUERY: SELECT '' AS bad, (; (f.f1)) from FLOAT8_TBL f where f.f1 < '0.0' ;
  241. ***************
  242. *** 207,216 ****
  243.   ---+--------------------
  244.      |                   1
  245.      |7.39912306090513e-16
  246.      |                   0
  247.      |                   0
  248.      |                   1
  249. ! (5 rows)
  250.   
  251.   QUERY: SELECT '' AS bad, f.f1 / '0.0' from FLOAT8_TBL f;
  252.   ERROR:  float8div: divide by zero error
  253. --- 227,238 ----
  254.   ---+--------------------
  255.      |                   1
  256.      |7.39912306090513e-16
  257. +    |                   1
  258. +    |                   1
  259.      |                   0
  260.      |                   0
  261.      |                   1
  262. ! (7 rows)
  263.   
  264.   QUERY: SELECT '' AS bad, f.f1 / '0.0' from FLOAT8_TBL f;
  265.   ERROR:  float8div: divide by zero error
  266. ***************
  267. *** 219,226 ****
  268.   ----+---------------------
  269.       |0                    
  270.       |-34.84               
  271.       |-1004.3              
  272.       |-1.2345678901234e+200
  273.       |-1.2345678901234e-200
  274. ! (5 rows)
  275.   
  276. --- 241,250 ----
  277.   ----+---------------------
  278.       |0                    
  279.       |-34.84               
  280. +     |0                    
  281. +     |0                    
  282.       |-1004.3              
  283.       |-1.2345678901234e+200
  284.       |-1.2345678901234e-200
  285. ! (7 rows)
  286.   
  288. ----------------------
  290. *** expected/numerology.out Thu Mar 19 00:49:56 1998
  291. --- results/numerology.out Sun Mar 22 15:36:25 1998
  292. ***************
  293. *** 23,28 ****
  294. --- 23,31 ----
  295.   QUERY: INSERT INTO TEMP_INT4 (f1)
  296.     SELECT int4(f1) FROM FLOAT8_TBL
  297.     WHERE (f1 > -2147483647) AND (f1 < 2147483647);
  298. + ERROR:  There is no operator '>' for types 'float8' and 'int4'
  299. +  You will either have to retype this query using an explicit cast,
  300. +  or you will have to define the operator using CREATE OPERATOR
  301.   QUERY: INSERT INTO TEMP_INT4 (f1)
  302.     SELECT int4(f1) FROM INT2_TBL;
  303.   QUERY: SELECT '' AS nine, f1 FROM TEMP_INT4
  304. ***************
  305. *** 31,44 ****
  306.   ----+------
  307.       |-32767
  308.       | -1234
  309. -     | -1004
  310. -     |   -35
  311. -     |     0
  312. -     |     0
  313.       |     0
  314.       |  1234
  315.       | 32767
  316. ! (9 rows)
  317.   
  318.   QUERY: CREATE TABLE TEMP_INT2 (f1 INT2);
  319.   QUERY: INSERT INTO TEMP_INT2 (f1)
  320. --- 34,43 ----
  321.   ----+------
  322.       |-32767
  323.       | -1234
  324.       |     0
  325.       |  1234
  326.       | 32767
  327. ! (5 rows)
  328.   
  329.   QUERY: CREATE TABLE TEMP_INT2 (f1 INT2);
  330.   QUERY: INSERT INTO TEMP_INT2 (f1)
  331. ***************
  332. *** 56,62 ****
  333.       |    0
  334.       |    0
  335.       |    0
  336. ! (5 rows)
  337.   
  338.   QUERY: CREATE TABLE TEMP_GROUP (f1 INT4, f2 INT4, f3 FLOAT8);
  339.   QUERY: INSERT INTO TEMP_GROUP
  340. --- 55,63 ----
  341.       |    0
  342.       |    0
  343.       |    0
  344. !     |    0
  345. !     |    0
  346. ! (7 rows)
  347.   
  348.   QUERY: CREATE TABLE TEMP_GROUP (f1 INT4, f2 INT4, f3 FLOAT8);
  349.   QUERY: INSERT INTO TEMP_GROUP
  351. ----------------------
  353. *** expected/geometry.out Thu Mar 19 00:49:41 1998
  354. --- results/geometry.out Sun Mar 22 15:36:29 1998
  355. ***************
  356. *** 100,106 ****
  357.         |(5.1,34.5)|[(1,2),(3,4)]                |(3,4)                               
  358.         |(-5,-12)  |[(1,2),(3,4)]                |(1,2)                               
  359.         |(10,10)   |[(1,2),(3,4)]                |(3,4)                               
  360. !       |(0,0)     |[(0,0),(6,6)]                |(-0,0)                              
  361.         |(-10,0)   |[(0,0),(6,6)]                |(0,0)                               
  362.         |(-3,4)    |[(0,0),(6,6)]                |(0,0)                               
  363.         |(5.1,34.5)|[(0,0),(6,6)]                |(6,6)                               
  364. --- 100,106 ----
  365.         |(5.1,34.5)|[(1,2),(3,4)]                |(3,4)                               
  366.         |(-5,-12)  |[(1,2),(3,4)]                |(1,2)                               
  367.         |(10,10)   |[(1,2),(3,4)]                |(3,4)                               
  368. !       |(0,0)     |[(0,0),(6,6)]                |(0,0)                               
  369.         |(-10,0)   |[(0,0),(6,6)]                |(0,0)                               
  370.         |(-3,4)    |[(0,0),(6,6)]                |(0,0)                               
  371.         |(5.1,34.5)|[(0,0),(6,6)]                |(6,6)                               
  372. ***************
  373. *** 113,119 ****
  374.         |(-5,-12)  |[(10,-10),(-3,-4)]           |(-3,-4)                             
  375.         |(10,10)   |[(10,-10),(-3,-4)]           |(-3,-4)                             
  376.         |(0,0)     |[(-1000000,200),(300000,-40)]|(0.0028402365895872,15.384614860264)
  377. !       |(-10,0)   |[(-1000000,200),(300000,-40)]|(-9.99715942258202,15.3864610140473)
  378.         |(-3,4)    |[(-1000000,200),(300000,-40)]|(-2.99789812267519,15.3851688427303)
  379.         |(5.1,34.5)|[(-1000000,200),(300000,-40)]|(5.09647083221496,15.3836744976925) 
  380.         |(-5,-12)  |[(-1000000,200),(300000,-40)]|(-4.99494420845634,15.3855375281616)
  381. --- 113,119 ----
  382.         |(-5,-12)  |[(10,-10),(-3,-4)]           |(-3,-4)                             
  383.         |(10,10)   |[(10,-10),(-3,-4)]           |(-3,-4)                             
  384.         |(0,0)     |[(-1000000,200),(300000,-40)]|(0.0028402365895872,15.384614860264)
  385. !       |(-10,0)   |[(-1000000,200),(300000,-40)]|(-9.99715942258202,15.3864610140472)
  386.         |(-3,4)    |[(-1000000,200),(300000,-40)]|(-2.99789812267519,15.3851688427303)
  387.         |(5.1,34.5)|[(-1000000,200),(300000,-40)]|(5.09647083221496,15.3836744976925) 
  388.         |(-5,-12)  |[(-1000000,200),(300000,-40)]|(-4.99494420845634,15.3855375281616)
  389. ***************
  390. *** 130,140 ****
  391.   six|box                                                                       
  392.   ---+--------------------------------------------------------------------------
  393.      |(2.12132034355964,2.12132034355964),(-2.12132034355964,-2.12132034355964) 
  394. !    |(71.7106781186548,72.7106781186548),(-69.7106781186548,-68.7106781186548) 
  395. !    |(4.53553390593274,6.53553390593274),(-2.53553390593274,-0.535533905932738)
  396. !    |(3.12132034355964,4.12132034355964),(-1.12132034355964,-0.121320343559643)
  397.      |(107.071067811865,207.071067811865),(92.9289321881345,192.928932188135)   
  398. !    |(170.710678118655,70.7106781186548),(29.2893218813452,-70.7106781186548)  
  399.   (6 rows)
  400.   
  401.   QUERY: SELECT '' AS twentyfour, b.f1 + p.f1 AS translation
  402. --- 130,140 ----
  403.   six|box                                                                       
  404.   ---+--------------------------------------------------------------------------
  405.      |(2.12132034355964,2.12132034355964),(-2.12132034355964,-2.12132034355964) 
  406. !    |(71.7106781186547,72.7106781186547),(-69.7106781186547,-68.7106781186547) 
  407. !    |(4.53553390593274,6.53553390593274),(-2.53553390593274,-0.535533905932737)
  408. !    |(3.12132034355964,4.12132034355964),(-1.12132034355964,-0.121320343559642)
  409.      |(107.071067811865,207.071067811865),(92.9289321881345,192.928932188135)   
  410. !    |(170.710678118655,70.7106781186547),(29.2893218813453,-70.7106781186547)  
  411.   (6 rows)
  412.   
  413.   QUERY: SELECT '' AS twentyfour, b.f1 + p.f1 AS translation
  414. ***************
  415. *** 205,215 ****
  416.             |(0,0),(0,0)                
  417.             |(0,0),(0,0)                
  418.             |(0,0),(0,0)                
  419. !           |(-0,0),(-20,-20)           
  420.             |(-10,-10),(-30,-30)        
  421.             |(-25,-25),(-25,-35)        
  422.             |(-30,-30),(-30,-30)        
  423. !           |(-0,2),(-14,0)             
  424.             |(-7,3),(-21,1)             
  425.             |(-17.5,2.5),(-21.5,-0.5)   
  426.             |(-21,3),(-21,3)            
  427. --- 205,215 ----
  428.             |(0,0),(0,0)                
  429.             |(0,0),(0,0)                
  430.             |(0,0),(0,0)                
  431. !           |(0,0),(-20,-20)            
  432.             |(-10,-10),(-30,-30)        
  433.             |(-25,-25),(-25,-35)        
  434.             |(-30,-30),(-30,-30)        
  435. !           |(0,2),(-14,0)              
  436.             |(-7,3),(-21,1)             
  437.             |(-17.5,2.5),(-21.5,-0.5)   
  438.             |(-21,3),(-21,3)            
  439. ***************
  440. *** 217,223 ****
  441.             |(-29.4,118.8),(-88.2,39.6) 
  442.             |(-73.5,104.1),(-108,99)    
  443.             |(-88.2,118.8),(-88.2,118.8)
  444. !           |(14,-0),(0,-34)            
  445.             |(21,-17),(7,-51)           
  446.             |(29.5,-42.5),(17.5,-47.5)  
  447.             |(21,-51),(21,-51)          
  448. --- 217,223 ----
  449.             |(-29.4,118.8),(-88.2,39.6) 
  450.             |(-73.5,104.1),(-108,99)    
  451.             |(-88.2,118.8),(-88.2,118.8)
  452. !           |(14,0),(0,-34)             
  453.             |(21,-17),(7,-51)           
  454.             |(29.5,-42.5),(17.5,-47.5)  
  455.             |(21,-51),(21,-51)          
  456. ***************
  457. *** 232,242 ****
  458.      WHERE (p.f1 <-> '(0,0)'::point) >= 1;
  459.   twenty|rotation                                                                         
  460.   ------+---------------------------------------------------------------------------------
  461. !       |(0,-0),(-0.2,-0.2)                                                               
  462.         |(-0.1,-0.1),(-0.3,-0.3)                                                          
  463.         |(-0.25,-0.25),(-0.25,-0.35)                                                      
  464.         |(-0.3,-0.3),(-0.3,-0.3)                                                          
  465. !       |(0.08,-0),(0,-0.56)                                                              
  466.         |(0.12,-0.28),(0.04,-0.84)                                                        
  467.         |(0.26,-0.7),(0.1,-0.82)                                                          
  468.         |(0.12,-0.84),(0.12,-0.84)                                                        
  469. --- 232,242 ----
  470.      WHERE (p.f1 <-> '(0,0)'::point) >= 1;
  471.   twenty|rotation                                                                         
  472.   ------+---------------------------------------------------------------------------------
  473. !       |(0,0),(-0.2,-0.2)                                                                
  474.         |(-0.1,-0.1),(-0.3,-0.3)                                                          
  475.         |(-0.25,-0.25),(-0.25,-0.35)                                                      
  476.         |(-0.3,-0.3),(-0.3,-0.3)                                                          
  477. !       |(0.08,0),(0,-0.56)                                                               
  478.         |(0.12,-0.28),(0.04,-0.84)                                                        
  479.         |(0.26,-0.7),(0.1,-0.82)                                                          
  480.         |(0.12,-0.84),(0.12,-0.84)                                                        
  481. ***************
  482. *** 244,250 ****
  483.         |(0.0976764836465887,-0.0241724631246608),(0.0325588278821962,-0.0725173893739825)
  484.         |(0.109762715208919,-0.0562379754328844),(0.0813970697054906,-0.0604311578116521) 
  485.         |(0.0976764836465887,-0.0725173893739825),(0.0976764836465887,-0.0725173893739825)
  486. !       |(-0,0.0828402366863905),(-0.201183431952663,0)                                   
  487.         |(-0.100591715976331,0.124260355029586),(-0.301775147928994,0.0414201183431953)   
  488.         |(-0.251479289940828,0.103550295857988),(-0.322485207100592,0.0739644970414201)   
  489.         |(-0.301775147928994,0.124260355029586),(-0.301775147928994,0.124260355029586)    
  490. --- 244,250 ----
  491.         |(0.0976764836465887,-0.0241724631246608),(0.0325588278821962,-0.0725173893739825)
  492.         |(0.109762715208919,-0.0562379754328844),(0.0813970697054906,-0.0604311578116521) 
  493.         |(0.0976764836465887,-0.0725173893739825),(0.0976764836465887,-0.0725173893739825)
  494. !       |(0,0.0828402366863905),(-0.201183431952663,0)                                    
  495.         |(-0.100591715976331,0.124260355029586),(-0.301775147928994,0.0414201183431953)   
  496.         |(-0.251479289940828,0.103550295857988),(-0.322485207100592,0.0739644970414201)   
  497.         |(-0.301775147928994,0.124260355029586),(-0.301775147928994,0.124260355029586)    
  498. ***************
  499. *** 410,434 ****
  500.   QUERY: SELECT '' AS six, polygon(f1)
  501.      FROM CIRCLE_TBL;
  502.   six|polygon                                                                                                                                                                                                                                                                             
  503. ! ---+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  504. !    |((-3,0),(-2.59807621135332,1.5),(-1.5,2.59807621135332),(-1.83690953073357e-16,3),(1.5,2.59807621135332),(2.59807621135332,1.5),(3,3.67381906146713e-16),(2.59807621135332,-1.5),(1.5,-2.59807621135332),(5.5107285922007e-16,-3),(-1.5,-2.59807621135332),(-2.59807621135332,-1.5))
  505. !    |((-99,2),(-85.6025403784439,52),(-49,88.6025403784439),(0.999999999999994,102),(51,88.6025403784439),(87.6025403784439,52),(101,2.00000000000001),(87.6025403784439,-48),(51,-84.6025403784438),(1.00000000000002,-98),(-49,-84.6025403784439),(-85.6025403784438,-48))             
  506. !    |((-4,3),(-3.33012701892219,5.5),(-1.5,7.33012701892219),(1,8),(3.5,7.33012701892219),(5.33012701892219,5.5),(6,3),(5.33012701892219,0.500000000000001),(3.5,-1.33012701892219),(1,-2),(-1.5,-1.33012701892219),(-3.33012701892219,0.499999999999998))                               
  507. !    |((-2,2),(-1.59807621135332,3.5),(-0.5,4.59807621135332),(1,5),(2.5,4.59807621135332),(3.59807621135332,3.5),(4,2),(3.59807621135332,0.500000000000001),(2.5,-0.598076211353315),(1,-1),(-0.5,-0.598076211353316),(-1.59807621135332,0.499999999999999))                             
  508. !    |((90,200),(91.3397459621556,205),(95,208.660254037844),(100,210),(105,208.660254037844),(108.660254037844,205),(110,200),(108.660254037844,195),(105,191.339745962156),(100,190),(95,191.339745962156),(91.3397459621556,195))                                                      
  509. !    |((0,0),(13.3974596215561,50),(50,86.6025403784439),(100,100),(150,86.6025403784439),(186.602540378444,50),(200,1.22460635382238e-14),(186.602540378444,-50),(150,-86.6025403784438),(100,-100),(50,-86.6025403784439),(13.3974596215562,-50))                                       
  510.   (6 rows)
  511.   
  512.   QUERY: SELECT '' AS six, polygon(8, f1)
  513.      FROM CIRCLE_TBL;
  514.   six|polygon                                                                                                                                                                                                                                 
  515. ! ---+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  516. !    |((-3,0),(-2.12132034355964,2.12132034355964),(-1.83690953073357e-16,3),(2.12132034355964,2.12132034355964),(3,3.67381906146713e-16),(2.12132034355964,-2.12132034355964),(5.5107285922007e-16,-3),(-2.12132034355964,-2.12132034355964))
  517. !    |((-99,2),(-69.7106781186548,72.7106781186548),(0.999999999999994,102),(71.7106781186547,72.7106781186548),(101,2.00000000000001),(71.7106781186548,-68.7106781186547),(1.00000000000002,-98),(-69.7106781186547,-68.7106781186548))     
  518. !    |((-4,3),(-2.53553390593274,6.53553390593274),(1,8),(4.53553390593274,6.53553390593274),(6,3),(4.53553390593274,-0.535533905932737),(1,-2),(-2.53553390593274,-0.535533905932738))                                                       
  519. !    |((-2,2),(-1.12132034355964,4.12132034355964),(1,5),(3.12132034355964,4.12132034355964),(4,2),(3.12132034355964,-0.121320343559642),(1,-1),(-1.12132034355964,-0.121320343559643))                                                       
  520. !    |((90,200),(92.9289321881345,207.071067811865),(100,210),(107.071067811865,207.071067811865),(110,200),(107.071067811865,192.928932188135),(100,190),(92.9289321881345,192.928932188135))                                                
  521. !    |((0,0),(29.2893218813452,70.7106781186548),(100,100),(170.710678118655,70.7106781186548),(200,1.22460635382238e-14),(170.710678118655,-70.7106781186547),(100,-100),(29.2893218813453,-70.7106781186548))                               
  522.   (6 rows)
  523.   
  524.   QUERY: SELECT '' AS six, circle(f1, 50.0)
  525. --- 410,434 ----
  526.   QUERY: SELECT '' AS six, polygon(f1)
  527.      FROM CIRCLE_TBL;
  528.   six|polygon                                                                                                                                                                                                                                                                                                                                                                                    
  529. ! ---+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  530. !    |((-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))
  531. !    |((-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))     
  532. !    |((-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))           
  533. !    |((-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))       
  534. !    |((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))             
  535. !    |((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))        
  536.   (6 rows)
  537.   
  538.   QUERY: SELECT '' AS six, polygon(8, f1)
  539.      FROM CIRCLE_TBL;
  540.   six|polygon                                                                                                                                                                                                                                  
  541. ! ---+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  542. !    |((-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))
  543. !    |((-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))       
  544. !    |((-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))           
  545. !    |((-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))           
  546. !    |((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))           
  547. !    |((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))       
  548.   (6 rows)
  549.   
  550.   QUERY: SELECT '' AS six, circle(f1, 50.0)
  551. ***************
  552. *** 467,477 ****
  553.      WHERE (p1.f1 <-> c1.f1) > 0
  554.      ORDER BY distance, circle, point using <<;
  555.   twentyfour|circle        |point     |         distance
  556. ! ----------+--------------+----------+-----------------
  557. !           |<(100,0),100> |(5.1,34.5)|0.976531926977964
  558.             |<(1,2),3>     |(-3,4)    | 1.47213595499958
  559.             |<(0,0),3>     |(-3,4)    |                2
  560. !           |<(100,0),100> |(-3,4)    | 3.07764064044151
  561.             |<(100,0),100> |(-5,-12)  | 5.68348972285122
  562.             |<(1,3),5>     |(-10,0)   | 6.40175425099138
  563.             |<(1,3),5>     |(10,10)   | 6.40175425099138
  564. --- 467,477 ----
  565.      WHERE (p1.f1 <-> c1.f1) > 0
  566.      ORDER BY distance, circle, point using <<;
  567.   twentyfour|circle        |point     |        distance
  568. ! ----------+--------------+----------+----------------
  569. !           |<(100,0),100> |(5.1,34.5)|0.97653192697797
  570.             |<(1,2),3>     |(-3,4)    |1.47213595499958
  571.             |<(0,0),3>     |(-3,4)    |               2
  572. !           |<(100,0),100> |(-3,4)    |3.07764064044152
  573.             |<(100,0),100> |(-5,-12)  |5.68348972285122
  574.             |<(1,3),5>     |(-10,0)   |6.40175425099138
  575.             |<(1,3),5>     |(10,10)   |6.40175425099138
  576. ***************
  577. *** 483,489 ****
  578.             |<(0,0),3>     |(10,10)   |  11.142135623731
  579.             |<(1,3),5>     |(-5,-12)  | 11.1554944214035
  580.             |<(1,2),3>     |(-5,-12)  | 12.2315462117278
  581. !           |<(1,3),5>     |(5.1,34.5)| 26.7657047773224
  582.             |<(1,2),3>     |(5.1,34.5)|  29.757594539282
  583.             |<(0,0),3>     |(5.1,34.5)| 31.8749193547455
  584.             |<(100,200),10>|(5.1,34.5)| 180.778038568384
  585. --- 483,489 ----
  586.             |<(0,0),3>     |(10,10)   | 11.142135623731
  587.             |<(1,3),5>     |(-5,-12)  |11.1554944214035
  588.             |<(1,2),3>     |(-5,-12)  |12.2315462117278
  589. !           |<(1,3),5>     |(5.1,34.5)|26.7657047773223
  590.             |<(1,2),3>     |(5.1,34.5)| 29.757594539282
  591.             |<(0,0),3>     |(5.1,34.5)|31.8749193547455
  592.             |<(100,200),10>|(5.1,34.5)|180.778038568384
  594. ----------------------
  596. *** expected/tinterval.out Thu Mar 19 00:50:31 1998
  597. --- results/tinterval.out Sun Mar 22 15:36:32 1998
  598. ***************
  599. *** 110,129 ****
  600.      ORDER BY interval1, interval2;
  601.   fourteen|interval1                                                      |interval2                                                      
  602.   --------+---------------------------------------------------------------+---------------------------------------------------------------
  603. -         |["-infinity" "infinity"]                                       |["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]
  604. -         |["-infinity" "infinity"]                                       |["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]
  605.           |["-infinity" "infinity"]                                       |["epoch" "Mon May 01 00:30:30 1995 PDT"]                       
  606.           |["-infinity" "infinity"]                                       |["Thu Feb 15 12:15:03 1990 PST" "current"]                     
  607. !         |["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]|["-infinity" "infinity"]                                       
  608. !         |["epoch" "Mon May 01 00:30:30 1995 PDT"]                       |["-infinity" "infinity"]                                       
  609. !         |["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]|["-infinity" "infinity"]                                       
  610.           |["Thu Feb 15 12:15:03 1990 PST" "current"]                     |["-infinity" "infinity"]                                       
  611.           |["epoch" "Mon May 01 00:30:30 1995 PDT"]                       |["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]
  612.           |["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]|["epoch" "Mon May 01 00:30:30 1995 PDT"]                       
  613.           |["epoch" "Mon May 01 00:30:30 1995 PDT"]                       |["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]
  614. -         |["epoch" "Mon May 01 00:30:30 1995 PDT"]                       |["Thu Feb 15 12:15:03 1990 PST" "current"]                     
  615.           |["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]|["epoch" "Mon May 01 00:30:30 1995 PDT"]                       
  616. !         |["Thu Feb 15 12:15:03 1990 PST" "current"]                     |["epoch" "Mon May 01 00:30:30 1995 PDT"]                       
  617.   (14 rows)
  618.   
  619.   QUERY: SELECT '' AS five, t1.f1
  620. --- 110,129 ----
  621.      ORDER BY interval1, interval2;
  622.   fourteen|interval1                                                      |interval2                                                      
  623.   --------+---------------------------------------------------------------+---------------------------------------------------------------
  624.           |["-infinity" "infinity"]                                       |["epoch" "Mon May 01 00:30:30 1995 PDT"]                       
  625. +         |["-infinity" "infinity"]                                       |["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]
  626.           |["-infinity" "infinity"]                                       |["Thu Feb 15 12:15:03 1990 PST" "current"]                     
  627. !         |["-infinity" "infinity"]                                       |["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]
  628.           |["Thu Feb 15 12:15:03 1990 PST" "current"]                     |["-infinity" "infinity"]                                       
  629. +         |["epoch" "Mon May 01 00:30:30 1995 PDT"]                       |["Thu Feb 15 12:15:03 1990 PST" "current"]                     
  630. +         |["epoch" "Mon May 01 00:30:30 1995 PDT"]                       |["-infinity" "infinity"]                                       
  631. +         |["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]|["-infinity" "infinity"]                                       
  632.           |["epoch" "Mon May 01 00:30:30 1995 PDT"]                       |["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]
  633. +         |["Thu Feb 15 12:15:03 1990 PST" "current"]                     |["epoch" "Mon May 01 00:30:30 1995 PDT"]                       
  634.           |["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]|["epoch" "Mon May 01 00:30:30 1995 PDT"]                       
  635.           |["epoch" "Mon May 01 00:30:30 1995 PDT"]                       |["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]
  636.           |["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]|["epoch" "Mon May 01 00:30:30 1995 PDT"]                       
  637. !         |["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]|["-infinity" "infinity"]                                       
  638.   (14 rows)
  639.   
  640.   QUERY: SELECT '' AS five, t1.f1
  642. ----------------------
  644. *** expected/random.out Thu Mar 19 00:50:07 1998
  645. --- results/random.out Sun Mar 22 15:38:52 1998
  646. ***************
  647. *** 7,18 ****
  648.   QUERY: SELECT count(*) FROM onek where oidrand(onek.oid, 10);
  649.   count
  650.   -----
  651. !    92
  652.   (1 row)
  653.   
  654.   QUERY: SELECT count(*) FROM onek where oidrand(onek.oid, 10);
  655.   count
  656.   -----
  657. !    98
  658.   (1 row)
  659.   
  660. --- 7,18 ----
  661.   QUERY: SELECT count(*) FROM onek where oidrand(onek.oid, 10);
  662.   count
  663.   -----
  664. !   107
  665.   (1 row)
  666.   
  667.   QUERY: SELECT count(*) FROM onek where oidrand(onek.oid, 10);
  668.   count
  669.   -----
  670. !   115
  671.   (1 row)
  672.   
  674. ----------------------