Thread
-
Three Regression Test Problems involving dates
Duncan Kinder <dckinder@mountain.net> — 1999-10-09T23:24:35Z
Set forth below are three regression test failures encountered on RedHat 6.0. All involved differences between expected and actual dates. The actual date is the date the test was run: If PostgreSQL failed to compile on your computer or you found a bug that is likely to be specific to one platform then please fill out this form and e-mail it to pgsql-ports@postgresql.org. To report any other bug, fill out the form below and e-mail it to pgsql-bugs@postgresql.org. If you not only found the problem but solved it and generated a patch then e-mail it to pgsql-patches@postgresql.org instead. Please use the command "diff -c" to generate the patch. You may also enter a bug report at http://www.postgresql.org/ instead of e-mail-ing this form. ============================================================================ POSTGRESQL BUG REPORT TEMPLATE ============================================================================ Your name : Duncan Kinder Your email address : dckinder@mountain.net System Configuration --------------------- Architecture (example: Intel Pentium) : Intel Pentium Operating System (example: Linux 2.0.26 ELF) : RedHat 6.0 PostgreSQL version (example: PostgreSQL-6.5.2): PostgreSQL-6.5.2 Compiler used (example: gcc 2.8.0) : ??? (RedHat 6.0 ) Please enter a FULL description of your problem: ------------------------------------------------ Regression test failures: Failures: Float8 , Geometry, Random (regression.diffs is set forth below) *** expected/float8.out Sat Jan 23 19:12:59 1999 --- results/float8.out Mon Oct 4 09:29:27 1999 *************** *** 189,201 **** QUERY: SELECT '' AS bad, f.f1 * '1e200' from FLOAT8_TBL f; ERROR: Bad float8 input format -- overflow QUERY: SELECT '' AS bad, f.f1 ^ '1e200' from FLOAT8_TBL f; ! ERROR: pow() result is out of range QUERY: SELECT '' AS bad, (; (f.f1)) from FLOAT8_TBL f where f.f1 = '0.0' ; ERROR: can't take log of zero QUERY: SELECT '' AS bad, (; (f.f1)) from FLOAT8_TBL f where f.f1 < '0.0' ; ERROR: can't take log of a negative number QUERY: SELECT '' AS bad, : (f.f1) from FLOAT8_TBL f; ! ERROR: exp() result is out of range QUERY: SELECT '' AS bad, f.f1 / '0.0' from FLOAT8_TBL f; ERROR: float8div: divide by zero error QUERY: SELECT '' AS five, FLOAT8_TBL.*; --- 189,217 ---- QUERY: SELECT '' AS bad, f.f1 * '1e200' from FLOAT8_TBL f; ERROR: Bad float8 input format -- overflow QUERY: SELECT '' AS bad, f.f1 ^ '1e200' from FLOAT8_TBL f; ! bad|?column? ! ---+-------- ! |0 ! |NaN ! |NaN ! |NaN ! |NaN ! (5 rows) ! QUERY: SELECT '' AS bad, (; (f.f1)) from FLOAT8_TBL f where f.f1 = '0.0' ; ERROR: can't take log of zero QUERY: SELECT '' AS bad, (; (f.f1)) from FLOAT8_TBL f where f.f1 < '0.0' ; ERROR: can't take log of a negative number QUERY: SELECT '' AS bad, : (f.f1) from FLOAT8_TBL f; ! bad| ?column? ! ---+-------------------- ! | 1 ! |7.39912306090513e-16 ! | 0 ! | 0 ! | 1 ! (5 rows) ! QUERY: SELECT '' AS bad, f.f1 / '0.0' from FLOAT8_TBL f; ERROR: float8div: divide by zero error QUERY: SELECT '' AS five, FLOAT8_TBL.*; ---------------------- *** expected/geometry.out Sun Dec 13 18:49:18 1998 --- results/geometry.out Mon Oct 4 09:29:31 1999 *************** *** 112,118 **** |(-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) --- 112,118 ---- |(-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) *************** *** 409,433 **** QUERY: SELECT '' AS six, polygon(f1) FROM CIRCLE_TBL; six|polygon ! ---+---------------------------------------------------------------------- ---------------------------------------------------------------------------- ---------------------------------------------------------------------------- ------------------------------------------------------ ! |((-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)) ! |((-99,2),(-85.6025403784439,52),(-49,88.6025403784439),(0.999999999999994,1 02),(51,88.6025403784439),(87.6025403784439,52),(101,2.00000000000001),(87.6 025403784439,-48),(51,-84.6025403784438),(1.00000000000002,-98),(-49,-84.602 5403784439),(-85.6025403784438,-48)) ! |((-4,3),(-3.33012701892219,5.5),(-1.5,7.33012701892219),(1,8),(3.5,7.330127 01892219),(5.33012701892219,5.5),(6,3),(5.33012701892219,0.500000000000001), (3.5,-1.33012701892219),(1,-2),(-1.5,-1.33012701892219),(-3.33012701892219,0 .499999999999998)) ! |((-2,2),(-1.59807621135332,3.5),(-0.5,4.59807621135332),(1,5),(2.5,4.598076 21135332),(3.59807621135332,3.5),(4,2),(3.59807621135332,0.500000000000001), (2.5,-0.598076211353315),(1,-1),(-0.5,-0.598076211353316),(-1.59807621135332 ,0.499999999999999)) ! |((90,200),(91.3397459621556,205),(95,208.660254037844),(100,210),(105,208.6 60254037844),(108.660254037844,205),(110,200),(108.660254037844,195),(105,19 1.339745962156),(100,190),(95,191.339745962156),(91.3397459621556,195)) ! |((0,0),(13.3974596215561,50),(50,86.6025403784439),(100,100),(150,86.602540 3784439),(186.602540378444,50),(200,1.22460635382238e-14),(186.602540378444, -50),(150,-86.6025403784438),(100,-100),(50,-86.6025403784439),(13.397459621 5562,-50)) (6 rows) QUERY: SELECT '' AS six, polygon(8, f1) FROM CIRCLE_TBL; six|polygon ! ---+---------------------------------------------------------------------- ---------------------------------------------------------------------------- ---------------------------------------------------------------------------- ---------- ! |((-3,0),(-2.12132034355964,2.12132034355964),(-1.83690953073357e-16,3),(2.1 2132034355964,2.12132034355964),(3,3.67381906146713e-16),(2.12132034355964,- 2.12132034355964),(5.5107285922007e-16,-3),(-2.12132034355964,-2.12132034355 964)) ! |((-99,2),(-69.7106781186548,72.7106781186548),(0.999999999999994,102),(71.7 106781186547,72.7106781186548),(101,2.00000000000001),(71.7106781186548,-68. 7106781186547),(1.00000000000002,-98),(-69.7106781186547,-68.7106781186548)) ! |((-4,3),(-2.53553390593274,6.53553390593274),(1,8),(4.53553390593274,6.5355 3390593274),(6,3),(4.53553390593274,-0.535533905932737),(1,-2),(-2.535533905 93274,-0.535533905932738)) ! |((-2,2),(-1.12132034355964,4.12132034355964),(1,5),(3.12132034355964,4.1213 2034355964),(4,2),(3.12132034355964,-0.121320343559642),(1,-1),(-1.121320343 55964,-0.121320343559643)) ! |((90,200),(92.9289321881345,207.071067811865),(100,210),(107.071067811865,2 07.071067811865),(110,200),(107.071067811865,192.928932188135),(100,190),(92 .9289321881345,192.928932188135)) ! |((0,0),(29.2893218813452,70.7106781186548),(100,100),(170.710678118655,70.7 106781186548),(200,1.22460635382238e-14),(170.710678118655,-70.7106781186547 ),(100,-100),(29.2893218813453,-70.7106781186548)) (6 rows) QUERY: SELECT '' AS six, circle(f1, 50.0) --- 409,433 ---- QUERY: SELECT '' AS six, polygon(f1) FROM CIRCLE_TBL; six|polygon ! ---+---------------------------------------------------------------------- ---------------------------------------------------------------------------- ---------------------------------------------------------------------------- ---------------------------------------------------------------------------- ---------------------------------------------------------------------------- ----- ! |((-3,0),(-2.59807621135076,1.50000000000442),(-1.49999999999116,2.598076211 35842),(1.53102359078377e-11,3),(1.50000000001768,2.59807621134311),(2.59807 621136607,1.4999999999779),(3,-3.06204718156754e-11),(2.59807621133545,-1.50 000000003094),(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.6025403 78614),(1.00000000051034,102),(51.0000000005893,88.6025403781036),(87.602540 3788692,51.9999999992634),(101,1.99999999897932),(87.6025403778485,-48.00000 00010313),(50.9999999988214,-84.6025403791243),(0.999999998468976,-98),(-49. 0000000014732,-84.6025403775933),(-85.6025403793795,-47.9999999983795)) ! |((-4,3),(-3.33012701891794,5.50000000000737),(-1.49999999998527,7.330127018 9307),(1.00000000002552,8),(3.50000000002946,7.33012701890518),(5.3301270189 4346,5.49999999996317),(6,2.99999999994897),(5.33012701889242,0.499999999948 437),(3.49999999994107,-1.33012701895622),(0.999999999923449,-2),(-1.5000000 0007366,-1.33012701887966),(-3.33012701896897,0.500000000081028)) ! |((-2,2),(-1.59807621135076,3.50000000000442),(-0.499999999991161,4.59807621 135842),(1.00000000001531,5),(2.50000000001768,4.59807621134311),(3.59807621 136607,3.4999999999779),(4,1.99999999996938),(3.59807621133545,0.49999999996 9062),(2.49999999996464,-0.59807621137373),(0.999999999954069,-1),(-0.500000 000044197,-0.598076211327799),(-1.59807621138138,0.500000000048617)) ! |((90,200),(91.3397459621641,205.000000000015),(95.0000000000295,208.6602540 37861),(100.000000000051,210),(105.000000000059,208.66025403781),(108.660254 037887,204.999999999926),(110,199.999999999898),(108.660254037785,194.999999 999897),(104.999999999882,191.339745962088),(99.9999999998469,190),(94.99999 99998527,191.339745962241),(91.3397459620621,195.000000000162)) ! |((0,0),(13.3974596216412,50.0000000001473),(50.0000000002946,86.60254037861 4),(100.00000000051,100),(150.000000000589,86.6025403781036),(186.6025403788 69,49.9999999992634),(200,-1.02068239385585e-09),(186.602540377848,-50.00000 00010313),(149.999999998821,-86.6025403791243),(99.999999998469,-100),(49.99 99999985268,-86.6025403775933),(13.3974596206205,-49.9999999983795)) (6 rows) QUERY: SELECT '' AS six, polygon(8, f1) FROM CIRCLE_TBL; six|polygon ! ---+---------------------------------------------------------------------- ---------------------------------------------------------------------------- ---------------------------------------------------------------------------- ----------- ! |((-3,0),(-2.12132034355423,2.12132034356506),(1.53102359078377e-11,3),(2.12 132034357588,2.1213203435434),(3,-3.06204718156754e-11),(2.12132034353258,-2 .12132034358671),(-4.59307077235131e-11,-3),(-2.12132034359753,-2.1213203435 2175)) ! |((-99,2),(-69.7106781184743,72.7106781188352),(1.00000000051034,102),(71.71 0678119196,72.7106781181134),(101,1.99999999897932),(71.7106781177526,-68.71 06781195569),(0.999999998468976,-98),(-69.7106781199178,-68.7106781173917)) ! |((-4,3),(-2.53553390592372,6.53553390594176),(1.00000000002552,8),(4.535533 9059598,6.53553390590567),(6,2.99999999994897),(4.53553390588763,-0.53553390 5977846),(0.999999999923449,-2),(-2.53553390599589,-0.535533905869586)) ! |((-2,2),(-1.12132034355423,4.12132034356506),(1.00000000001531,5),(3.121320 34357588,4.1213203435434),(4,1.99999999996938),(3.12132034353258,-0.12132034 3586707),(0.999999999954069,-1),(-1.12132034359753,-0.121320343521752)) ! |((90,200),(92.9289321881526,207.071067811884),(100.000000000051,210),(107.0 7106781192,207.071067811811),(110,199.999999999898),(107.071067811775,192.92 8932188044),(99.9999999998469,190),(92.9289321880082,192.928932188261)) ! |((0,0),(29.2893218815257,70.7106781188352),(100.00000000051,100),(170.71067 8119196,70.7106781181134),(200,-1.02068239385585e-09),(170.710678117753,-70. 7106781195569),(99.999999998469,-100),(29.2893218800822,-70.7106781173917)) (6 rows) QUERY: SELECT '' AS six, circle(f1, 50.0) ---------------------- *** expected/random.out Mon Aug 17 12:11:15 1998 --- results/random.out Mon Oct 4 09:31:08 1999 *************** *** 13,19 **** GROUP BY random HAVING count(random) > 1; random|count ------+----- ! (0 rows) QUERY: SELECT random FROM RANDOM_TBL WHERE random NOT BETWEEN 80 AND 120; --- 13,20 ---- GROUP BY random HAVING count(random) > 1; random|count ------+----- ! 89| 2 ! (1 row) QUERY: SELECT random FROM RANDOM_TBL WHERE random NOT BETWEEN 80 AND 120; ---------------------- Please describe a way to repeat the problem. Please try to provide a concise reproducible example, if at all possible: ---------------------------------------------------------------------- Compile and run the tests on stated platform. If you know how this problem might be fixed, list the solution below: --------------------------------------------------------------------- I have no solutions. Regards, Duncan C. Kinder dckinder@mountain.net