port and bug report - Mailing list pgsql-ports
| From | Sidney Cammeresi |
|---|---|
| Subject | port and bug report |
| Date | |
| Msg-id | 773d19c03b5bb6b7c27ae2702f47c1be Whole thread Raw |
| List | pgsql-ports |
- --3V7upXqbjpZ4EhLz Content-Type: text/plain; charset=us-ascii i have just successfully compiled PostgreSQL 6.4 on OpenBSD/sparc. it passed most of the regression tests. i thought you would be interested since it is not listed in the README as working. the only problem i had was that i had to remove a -m486 from the openbsd template file. for your reference, i have attached regress.out and regression.diffs. sc - -- Sid Cammeresi <cammeres (at) uiuc.edu> | `If anything, I think the GPL has PPL, CS, University of Illinois | acted as a barrier to innovation, http://www.ks.uiuc.edu/~cammeres | reliability, [and] improvement....' PGP: 65 6F B3 DA CA 3E 3B 09 | -- Theo de Raadt 32 C8 17 1C 0A 79 2F 3F | - --3V7upXqbjpZ4EhLz Content-Type: text/plain; charset=us-ascii Content-Disposition: attachment; filename="regress.out" =============== Notes... ================= postmaster must already be running for the regression tests to succeed. The time zone is now set to PST8PDT explicitly by this regression test client frontend. Please report any apparent problems to ports@postgresql.org See regress/README for more information. =============== destroying old regression database... ================= ERROR: destroydb: database 'regression' does not exist destroydb: database destroy failed on regression. =============== creating new regression database... ================= =============== running regression queries... ================= boolean .. ok char .. ok name .. ok varchar .. ok text .. ok strings .. failed int2 .. failed int4 .. failed int8 .. ok oid .. ok float4 .. ok float8 .. failed numerology .. ok point .. ok lseg .. ok box .. ok path .. ok polygon .. ok circle .. ok geometry .. failed timespan .. ok datetime .. ok reltime .. ok abstime .. ok tinterval .. ok horology .. ok inet .. ok comments .. ok opr_sanity .. ok create_function_1 .. ok create_type .. ok create_table .. ok create_function_2 .. ok constraints .. failed triggers .. ok copy .. ok create_misc .. ok create_aggregate .. ok create_operator .. ok create_view .. ok create_index .. ok sanity_check .. ok errors .. failed select .. ok select_into .. ok select_distinct .. ok select_distinct_on .. ok select_implicit .. ok select_having .. ok subselect .. ok union .. ok aggregates .. ok transactions .. ok random .. ok portals .. ok misc .. ok arrays .. ok btree_index .. ok hash_index .. ok select_views .. ok alter_table .. ok portals_p2 .. ok rules .. ok install_plpgsql .. ok plpgsql .. ok - --3V7upXqbjpZ4EhLz Content-Type: text/plain; charset=us-ascii Content-Disposition: attachment; filename="regression.diffs" *** expected/strings.out Fri May 29 08:22:41 1998 - --- results/strings.out Fri Dec 4 11:46:37 1998 *************** *** 11,17 **** ' - next line' /* this comment is not allowed here */ ' - third line' AS "Illegal comment within continuation"; ! ERROR: parser: parse error at or near "'" QUERY: SELECT CAST(f1 AS text) AS "text(char)" FROM CHAR_TBL; text(char) ---------- - --- 11,17 ---- ' - next line' /* this comment is not allowed here */ ' - third line' AS "Illegal comment within continuation"; ! ERROR: parser: syntax error at or near "'" QUERY: SELECT CAST(f1 AS text) AS "text(char)" FROM CHAR_TBL; text(char) ---------- - ---------------------- *** expected/int2.out Sun Jan 4 21:35:35 1998 - --- results/int2.out Fri Dec 4 11:46:43 1998 *************** *** 7,13 **** QUERY: INSERT INTO INT2_TBL(f1) VALUES ('32767'); QUERY: INSERT INTO INT2_TBL(f1) VALUES ('-32767'); QUERY: INSERT INTO INT2_TBL(f1) VALUES ('100000'); ! ERROR: pg_atoi: error reading "100000": Math result not representable QUERY: INSERT INTO INT2_TBL(f1) VALUES ('asdf'); ERROR: pg_atoi: error in "asdf": can't parse "asdf" QUERY: SELECT '' AS five, INT2_TBL.*; - --- 7,13 ---- QUERY: INSERT INTO INT2_TBL(f1) VALUES ('32767'); QUERY: INSERT INTO INT2_TBL(f1) VALUES ('-32767'); QUERY: INSERT INTO INT2_TBL(f1) VALUES ('100000'); ! ERROR: pg_atoi: error reading "100000": Result too large QUERY: INSERT INTO INT2_TBL(f1) VALUES ('asdf'); ERROR: pg_atoi: error in "asdf": can't parse "asdf" QUERY: SELECT '' AS five, INT2_TBL.*; - ---------------------- *** expected/int4.out Sun Jan 4 21:35:36 1998 - --- results/int4.out Fri Dec 4 11:46:50 1998 *************** *** 7,13 **** QUERY: INSERT INTO INT4_TBL(f1) VALUES ('2147483647'); QUERY: INSERT INTO INT4_TBL(f1) VALUES ('-2147483647'); QUERY: INSERT INTO INT4_TBL(f1) VALUES ('1000000000000'); ! ERROR: pg_atoi: error reading "1000000000000": Math result not representable QUERY: INSERT INTO INT4_TBL(f1) VALUES ('asdf'); ERROR: pg_atoi: error in "asdf": can't parse "asdf" QUERY: SELECT '' AS five, INT4_TBL.*; - --- 7,13 ---- QUERY: INSERT INTO INT4_TBL(f1) VALUES ('2147483647'); QUERY: INSERT INTO INT4_TBL(f1) VALUES ('-2147483647'); QUERY: INSERT INTO INT4_TBL(f1) VALUES ('1000000000000'); ! ERROR: pg_atoi: error reading "1000000000000": Result too large QUERY: INSERT INTO INT4_TBL(f1) VALUES ('asdf'); ERROR: pg_atoi: error in "asdf": can't parse "asdf" QUERY: SELECT '' AS five, INT4_TBL.*; - ---------------------- *** expected/float8.out Tue Sep 22 11:52:56 1998 - --- results/float8.out Fri Dec 4 11:47:11 1998 *************** *** 195,209 **** 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.*; - --- 195,201 ---- 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.*; - ---------------------- *** expected/geometry.out Fri May 29 08:22:41 1998 - --- results/geometry.out Fri Dec 4 11:48:01 1998 *************** *** 99,105 **** |(5.1,34.5)|[(1,2),(3,4)] |(3,4) |(-5,-12) |[(1,2),(3,4)] |(1,2) |(10,10) |[(1,2),(3,4)] |(3,4) ! |(0,0) |[(0,0),(6,6)] |(-0,0) |(-10,0) |[(0,0),(6,6)] |(0,0) |(-3,4) |[(0,0),(6,6)] |(0.5,0.5) |(5.1,34.5)|[(0,0),(6,6)] |(6,6) - --- 99,105 ---- |(5.1,34.5)|[(1,2),(3,4)] |(3,4) |(-5,-12) |[(1,2),(3,4)] |(1,2) |(10,10) |[(1,2),(3,4)] |(3,4) ! |(0,0) |[(0,0),(6,6)] |(0,0) |(-10,0) |[(0,0),(6,6)] |(0,0) |(-3,4) |[(0,0),(6,6)] |(0.5,0.5) |(5.1,34.5)|[(0,0),(6,6)] |(6,6) *************** *** 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) *************** *** 129,139 **** 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) QUERY: SELECT '' AS twentyfour, b.f1 + p.f1 AS translation - --- 129,139 ---- 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) QUERY: SELECT '' AS twentyfour, b.f1 + p.f1 AS translation *************** *** 204,214 **** |(0,0),(0,0) |(0,0),(0,0) |(0,0),(0,0) ! |(-0,0),(-20,-20) |(-10,-10),(-30,-30) |(-25,-25),(-25,-35) |(-30,-30),(-30,-30) ! |(-0,2),(-14,0) |(-7,3),(-21,1) |(-17.5,2.5),(-21.5,-0.5) |(-21,3),(-21,3) - --- 204,214 ---- |(0,0),(0,0) |(0,0),(0,0) |(0,0),(0,0) ! |(0,0),(-20,-20) |(-10,-10),(-30,-30) |(-25,-25),(-25,-35) |(-30,-30),(-30,-30) ! |(0,2),(-14,0) |(-7,3),(-21,1) |(-17.5,2.5),(-21.5,-0.5) |(-21,3),(-21,3) *************** *** 216,222 **** |(-29.4,118.8),(-88.2,39.6) |(-73.5,104.1),(-108,99) |(-88.2,118.8),(-88.2,118.8) ! |(14,-0),(0,-34) |(21,-17),(7,-51) |(29.5,-42.5),(17.5,-47.5) |(21,-51),(21,-51) - --- 216,222 ---- |(-29.4,118.8),(-88.2,39.6) |(-73.5,104.1),(-108,99) |(-88.2,118.8),(-88.2,118.8) ! |(14,0),(0,-34) |(21,-17),(7,-51) |(29.5,-42.5),(17.5,-47.5) |(21,-51),(21,-51) *************** *** 231,241 **** WHERE (p.f1 <-> '(0,0)'::point) >= 1; twenty|rotation ------+--------------------------------------------------------------------------------- ! |(0,-0),(-0.2,-0.2) |(-0.1,-0.1),(-0.3,-0.3) |(-0.25,-0.25),(-0.25,-0.35) |(-0.3,-0.3),(-0.3,-0.3) ! |(0.08,-0),(0,-0.56) |(0.12,-0.28),(0.04,-0.84) |(0.26,-0.7),(0.1,-0.82) |(0.12,-0.84),(0.12,-0.84) - --- 231,241 ---- WHERE (p.f1 <-> '(0,0)'::point) >= 1; twenty|rotation ------+--------------------------------------------------------------------------------- ! |(0,0),(-0.2,-0.2) |(-0.1,-0.1),(-0.3,-0.3) |(-0.25,-0.25),(-0.25,-0.35) |(-0.3,-0.3),(-0.3,-0.3) ! |(0.08,0),(0,-0.56) |(0.12,-0.28),(0.04,-0.84) |(0.26,-0.7),(0.1,-0.82) |(0.12,-0.84),(0.12,-0.84) *************** *** 243,249 **** |(0.0976764836465887,-0.0241724631246608),(0.0325588278821962,-0.0725173893739825) |(0.109762715208919,-0.0562379754328844),(0.0813970697054906,-0.0604311578116521) |(0.0976764836465887,-0.0725173893739825),(0.0976764836465887,-0.0725173893739825) ! |(-0,0.0828402366863905),(-0.201183431952663,0) |(-0.100591715976331,0.124260355029586),(-0.301775147928994,0.0414201183431953) |(-0.251479289940828,0.103550295857988),(-0.322485207100592,0.0739644970414201) |(-0.301775147928994,0.124260355029586),(-0.301775147928994,0.124260355029586) - --- 243,249 ---- |(0.0976764836465887,-0.0241724631246608),(0.0325588278821962,-0.0725173893739825) |(0.109762715208919,-0.0562379754328844),(0.0813970697054906,-0.0604311578116521) |(0.0976764836465887,-0.0725173893739825),(0.0976764836465887,-0.0725173893739825) ! |(0,0.0828402366863905),(-0.201183431952663,0) |(-0.100591715976331,0.124260355029586),(-0.301775147928994,0.0414201183431953) |(-0.251479289940828,0.103550295857988),(-0.322485207100592,0.0739644970414201) |(-0.301775147928994,0.124260355029586),(-0.301775147928994,0.124260355029586) *************** *** 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,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)) ! |((-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)) ! |((-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)) ! |((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)) ! |((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)) (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.12132034355964,2.12132034355964),(3,3.67381906146713e-16),(2.12132034355964,-2.12132034355964),(5.5107285922007e-16,-3),(-2.12132034355964,-2.12132034355964)) ! |((-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)) ! |((-4,3),(-2.53553390593274,6.53553390593274),(1,8),(4.53553390593274,6.53553390593274),(6,3),(4.53553390593274,-0.535533905932737),(1,-2),(-2.53553390593274,-0.535533905932738)) ! |((-2,2),(-1.12132034355964,4.12132034355964),(1,5),(3.12132034355964,4.12132034355964),(4,2),(3.12132034355964,-0.121320343559642),(1,-1),(-1.12132034355964,-0.121320343559643)) ! |((90,200),(92.9289321881345,207.071067811865),(100,210),(107.071067811865,207.071067811865),(110,200),(107.071067811865,192.928932188135),(100,190),(92.9289321881345,192.928932188135)) ! |((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)) (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.59807621135842),(1.53102359017709e-11,3),(1.50000000001768,2.59807621134311),(2.59807621136607,1.4999999999779),(3,-3.06204718035418e-11),(2.59807621133545,-1.50000000003094),(1.49999999996464,-2.59807621137373),(-4.59307077053127e-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.02068239345139e-09),(186.602540377848,-50.0000000010313),(149.999999998821,-86.6025403791243),(99.999999998469,-100),(49.9999999985268,-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.53102359017709e-11,3),(2.12132034357588,2.1213203435434),(3,-3.06204718035418e-11),(2.12132034353258,-2.12132034358671),(-4.59307077053127e-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.02068239345139e-09),(170.710678117753,-70.7106781195569),(99.999999998469,-100),(29.2893218800822,-70.7106781173917)) (6 rows) QUERY: SELECT '' AS six, circle(f1, 50.0) *************** *** 466,476 **** 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 - --- 466,476 ---- 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 *************** *** 482,488 **** |<(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 - --- 482,488 ---- |<(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/constraints.out Fri Dec 4 11:44:59 1998 - --- results/constraints.out Fri Dec 4 11:51:57 1998 *************** *** 32,38 **** (4 rows) QUERY: CREATE TABLE error_tbl (i int DEFAULT (100, )); ! ERROR: parser: parse error at or near "," QUERY: CREATE TABLE error_tbl (b1 bool DEFAULT 1 < 2); ERROR: boolean expressions not supported in DEFAULT QUERY: CREATE TABLE CHECK_TBL (x int, - --- 32,38 ---- (4 rows) QUERY: CREATE TABLE error_tbl (i int DEFAULT (100, )); ! ERROR: parser: syntax error at or near "," QUERY: CREATE TABLE error_tbl (b1 bool DEFAULT 1 < 2); ERROR: boolean expressions not supported in DEFAULT QUERY: CREATE TABLE CHECK_TBL (x int, - ---------------------- *** expected/errors.out Wed Sep 30 00:43:23 1998 - --- results/errors.out Fri Dec 4 12:21:11 1998 *************** *** 1,7 **** QUERY: select 1 select select * from nonesuch; ! ERROR: parser: parse error at or near "select" QUERY: select nonesuch from pg_database; ERROR: attribute 'nonesuch' not found QUERY: select * from pg_database where nonesuch = pg_database.datname; - --- 1,7 ---- QUERY: select 1 select select * from nonesuch; ! ERROR: parser: syntax error at or near "select" QUERY: select nonesuch from pg_database; ERROR: attribute 'nonesuch' not found QUERY: select * from pg_database where nonesuch = pg_database.datname; *************** *** 9,27 **** QUERY: select * from pg_database where pg_database.datname = nonesuch; ERROR: attribute 'nonesuch' not found QUERY: select distinct on foobar from pg_database; ! ERROR: parser: parse error at or near "from" QUERY: select distinct on foobar * from pg_database; ERROR: All fields in the UNIQUE ON clause must appear in the target list QUERY: delete from; ! ERROR: parser: parse error at or near ";" QUERY: delete from nonesuch; ERROR: nonesuch: Table does not exist. QUERY: drop table; ! ERROR: parser: parse error at or near ";" QUERY: drop table nonesuch; ERROR: Relation nonesuch Does Not Exist! QUERY: alter table rename; ! ERROR: parser: parse error at or near ";" QUERY: alter table nonesuch rename to newnonesuch; ERROR: renamerel: relation "nonesuch" does not exist QUERY: alter table nonesuch rename to stud_emp; - --- 9,27 ---- QUERY: select * from pg_database where pg_database.datname = nonesuch; ERROR: attribute 'nonesuch' not found QUERY: select distinct on foobar from pg_database; ! ERROR: parser: syntax error at or near "from" QUERY: select distinct on foobar * from pg_database; ERROR: All fields in the UNIQUE ON clause must appear in the target list QUERY: delete from; ! ERROR: parser: syntax error at or near ";" QUERY: delete from nonesuch; ERROR: nonesuch: Table does not exist. QUERY: drop table; ! ERROR: parser: syntax error at or near ";" QUERY: drop table nonesuch; ERROR: Relation nonesuch Does Not Exist! QUERY: alter table rename; ! ERROR: parser: syntax error at or near ";" QUERY: alter table nonesuch rename to newnonesuch; ERROR: renamerel: relation "nonesuch" does not exist QUERY: alter table nonesuch rename to stud_emp; *************** *** 79,125 **** stype2 = int4); ERROR: AggregateCreate: transition function 2 MUST have an initial value QUERY: drop index; ! ERROR: parser: parse error at or near ";" QUERY: drop index 314159; ! ERROR: parser: parse error at or near "314159" QUERY: drop index nonesuch; ERROR: index "nonesuch" nonexistent QUERY: drop aggregate; ! ERROR: parser: parse error at or near ";" QUERY: drop aggregate 314159; ! ERROR: parser: parse error at or near "314159" QUERY: drop aggregate nonesuch; ! ERROR: parser: parse error at or near ";" QUERY: drop aggregate newcnt1; ! ERROR: parser: parse error at or near ";" QUERY: drop aggregate newcnt nonesuch; ERROR: RemoveAggregate: type 'nonesuch' does not exist QUERY: drop aggregate newcnt float4; ERROR: RemoveAggregate: aggregate 'newcnt' for 'float4' does not exist QUERY: drop function (); ! ERROR: parser: parse error at or near "(" QUERY: drop function 314159(); ! ERROR: parser: parse error at or near "314159" QUERY: drop function nonesuch(); ERROR: RemoveFunction: function 'nonesuch()' does not exist QUERY: drop type; ! ERROR: parser: parse error at or near ";" QUERY: drop type 314159; ! ERROR: parser: parse error at or near "314159" QUERY: drop type nonesuch; ERROR: RemoveType: type 'nonesuch' does not exist QUERY: drop operator; ! ERROR: parser: parse error at or near ";" QUERY: drop operator equals; ! ERROR: parser: parse error at or near "equals" QUERY: drop operator ===; ! ERROR: parser: parse error at or near ";" QUERY: drop operator int4, int4; ! ERROR: parser: parse error at or near "int4" QUERY: drop operator (int4, int4); ! ERROR: parser: parse error at or near "(" QUERY: drop operator === (); ! ERROR: parser: parse error at or near ")" QUERY: drop operator === (int4); ERROR: parser: argument type missing (use NONE for unary operators) QUERY: drop operator === (int4, int4); - --- 79,125 ---- stype2 = int4); ERROR: AggregateCreate: transition function 2 MUST have an initial value QUERY: drop index; ! ERROR: parser: syntax error at or near ";" QUERY: drop index 314159; ! ERROR: parser: syntax error at or near "314159" QUERY: drop index nonesuch; ERROR: index "nonesuch" nonexistent QUERY: drop aggregate; ! ERROR: parser: syntax error at or near ";" QUERY: drop aggregate 314159; ! ERROR: parser: syntax error at or near "314159" QUERY: drop aggregate nonesuch; ! ERROR: parser: syntax error at or near ";" QUERY: drop aggregate newcnt1; ! ERROR: parser: syntax error at or near ";" QUERY: drop aggregate newcnt nonesuch; ERROR: RemoveAggregate: type 'nonesuch' does not exist QUERY: drop aggregate newcnt float4; ERROR: RemoveAggregate: aggregate 'newcnt' for 'float4' does not exist QUERY: drop function (); ! ERROR: parser: syntax error at or near "(" QUERY: drop function 314159(); ! ERROR: parser: syntax error at or near "314159" QUERY: drop function nonesuch(); ERROR: RemoveFunction: function 'nonesuch()' does not exist QUERY: drop type; ! ERROR: parser: syntax error at or near ";" QUERY: drop type 314159; ! ERROR: parser: syntax error at or near "314159" QUERY: drop type nonesuch; ERROR: RemoveType: type 'nonesuch' does not exist QUERY: drop operator; ! ERROR: parser: syntax error at or near ";" QUERY: drop operator equals; ! ERROR: parser: syntax error at or near "equals" QUERY: drop operator ===; ! ERROR: parser: syntax error at or near ";" QUERY: drop operator int4, int4; ! ERROR: parser: syntax error at or near "int4" QUERY: drop operator (int4, int4); ! ERROR: parser: syntax error at or near "(" QUERY: drop operator === (); ! ERROR: parser: syntax error at or near ")" QUERY: drop operator === (int4); ERROR: parser: argument type missing (use NONE for unary operators) QUERY: drop operator === (int4, int4); *************** *** 127,148 **** QUERY: drop operator = (nonesuch); ERROR: parser: argument type missing (use NONE for unary operators) QUERY: drop operator = ( , int4); ! ERROR: parser: parse error at or near "," QUERY: drop operator = (nonesuch, int4); ERROR: RemoveOperator: type 'nonesuch' does not exist QUERY: drop operator = (int4, nonesuch); ERROR: RemoveOperator: type 'nonesuch' does not exist QUERY: drop operator = (int4, ); ! ERROR: parser: parse error at or near ")" QUERY: drop rule; ! ERROR: parser: parse error at or near ";" QUERY: drop rule 314159; ! ERROR: parser: parse error at or near "314159" QUERY: drop rule nonesuch; ERROR: RewriteGetRuleEventRel: rule "nonesuch" not found QUERY: drop tuple rule nonesuch; ! ERROR: parser: parse error at or near "tuple" QUERY: drop instance rule nonesuch; ! ERROR: parser: parse error at or near "instance" QUERY: drop rewrite rule nonesuch; ! ERROR: parser: parse error at or near "rewrite" - --- 127,148 ---- QUERY: drop operator = (nonesuch); ERROR: parser: argument type missing (use NONE for unary operators) QUERY: drop operator = ( , int4); ! ERROR: parser: syntax error at or near "," QUERY: drop operator = (nonesuch, int4); ERROR: RemoveOperator: type 'nonesuch' does not exist QUERY: drop operator = (int4, nonesuch); ERROR: RemoveOperator: type 'nonesuch' does not exist QUERY: drop operator = (int4, ); ! ERROR: parser: syntax error at or near ")" QUERY: drop rule; ! ERROR: parser: syntax error at or near ";" QUERY: drop rule 314159; ! ERROR: parser: syntax error at or near "314159" QUERY: drop rule nonesuch; ERROR: RewriteGetRuleEventRel: rule "nonesuch" not found QUERY: drop tuple rule nonesuch; ! ERROR: parser: syntax error at or near "tuple" QUERY: drop instance rule nonesuch; ! ERROR: parser: syntax error at or near "instance" QUERY: drop rewrite rule nonesuch; ! ERROR: parser: syntax error at or near "rewrite" - ---------------------- - --3V7upXqbjpZ4EhLz--
pgsql-ports by date: