[postgis-tickets] [PostGIS] #4282: ST_LineToCurve hangs indefintely

[PostGIS]

#4282: ST_LineToCurve hangs indefintely
---------------------+---------------------------
 Reporter:  robe     |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  blocker  |  Milestone:  PostGIS 3.0.0
Component:  postgis  |    Version:  trunk
 Keywords:           |
---------------------+---------------------------
 I thought I had tested this in 2.5 and garden tests ran to completion.

 On trunk branch however, for PostgreSQL 12, this test hangs indefinitely.
 I let it sit there and work up 5 hrs later and it was still stuck.


 {{{
 SELECT ST_Area(foo1.the_geom) As result FROM ((SELECT
 ST_LineToCurve(ST_Buffer(ST_SetSRID(ST_Point(i,j),4326), j)) As the_geom
 FROM generate_series(-10,50,10) As i CROSS JOIN generate_series(40,70, 20)
 As j ORDER BY i, j, i*j) ) As foo1 LIMIT 10;
 }}}


 I'm guessing it's not the ST_Area and most likely the ST_LineToCurve at
 fault here.
 In addition to hanging indefinitely, it's not cancellable

 I'll isolate it down to that and if it's a pg12 issue or a PostGIS 3.0
 issue.

 This I ran against PostgreSQL 12 head as of 12/27/2018


 {{{
                                                              version
 ---------------------------------------------------------------------------------------------------------------------------------
  PostgreSQL 12devel on x86_64-w64-mingw32, compiled by gcc.exe (x86_64
 -posix-seh-rev0, Built by MinGW-W64 project) 8.1.0, 64-bit
 (1 row)

 postgis_full_version
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  POSTGIS="3.0.0dev r17118" [EXTENSION] PGSQL="120" GEOS="3.7.0-CAPI-1.11.0
 673b9939" SFCGAL="1.3.2" PROJ="Rel. 5.2.0, September 15th, 2018"
 LIBXML="2.7.8" LIBJSON="0.12" LIBPROTOBUF="1.2.1"
 (1 row)

 }}}

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4282>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.