Changes between Initial Version and Version 27 of Ticket #3719
- Timestamp:
- 10/23/18 18:30:57 (6 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #3719
- Property Milestone PostGIS 2.3.3 → PostGIS 3.0.0
- Property Owner changed from to
-
Ticket #3719 – Description
initial v27 1 1 Why this sql query returns error: 2 select ST_Intersects(ST_GeomFromText('CURVEPOLYGON( 2 3 {{{ 4 SELECT ST_Intersects(ST_GeomFromText('CURVEPOLYGON( 3 5 (25495445.625 6671632.625, 25495445.625 6671711.375, 25495555.375 6671711.375, 25495555.375 6671632.625, 25495445.625 6671632.625), 4 6 COMPOUNDCURVE( 5 7 CIRCULARSTRING(25495368.0441 6671726.9312,25495368.3959388 6671726.93601515,25495368.7478 6671726.9333), 6 8 (25495368.7478 6671726.9333,25495368.0441 6671726.9312)))'),ST_MakeEnvelope(25495443.625, 6671631.625, 25495556.375, 6671712.375)) 9 }}} 7 10 11 12 13 {{{ 8 14 ERROR: First argument geometry could not be converted to GEOS: IllegalArgumentException: Invalid number of points in LinearRing found 3 - must be 0 or >= 4 9 15 SQL state: XX000 10 16 Context: SQL function "st_intersects" statement 1 17 }}} 11 18 12 19 13 20 If I put hole geometry to boundary geometry it doesn't give error: 21 22 {{{ 14 23 15 24 select ST_Intersects(ST_GeomFromText('CURVEPOLYGON( … … 17 26 CIRCULARSTRING(25495368.0441 6671726.9312,25495368.3959388 6671726.93601515,25495368.7478 6671726.9333), 18 27 (25495368.7478 6671726.9333,25495368.0441 6671726.9312)))'),ST_MakeEnvelope(25495443.625, 6671631.625, 25495556.375, 6671712.375)) 28 }}} 19 29 30 31 32 {{{ 20 33 st_intersects 21 34 boolean 22 35 23 36 f 37 }}} 38