[postgis-devel] [PostGIS] #1657: Crasher on ST_AsLatLonText on mingw64 (was: Crasher on ST_AsLatLonText on mingw64 in combo query_to_xml)

[PostGIS]

#1657: Crasher on ST_AsLatLonText on mingw64
------------------------------------+---------------------------------------
 Reporter:  robe                    |       Owner:  pramsey      
     Type:  defect                  |      Status:  new          
 Priority:  medium                  |   Milestone:  PostGIS 2.0.0
Component:  postgis                 |     Version:  trunk        
 Keywords:  mingw64, windows 64bit  |  
------------------------------------+---------------------------------------

Comment(by robe):

 Okay was wrong this doesn't need query_to_xml to crash.  However I can't
 get ti to crash under mymingw64 compiled postgresql.  It only does it on
 my windows 2003 64-bit 9.1 EDB version and only if you give it an invalid
 format.

 So this works:

 {{{
 SELECT ST_AsLatLonText(the_geom, 'D°M''S.SSS"C') As result,
 ST_AsText(the_geom) FROM ((SELECT ST_SetSRID(ST_Point(i,j),4326) As
 the_geom FROM (SELECT a*1.11111111 FROM generate_series(-10,50,2) As a) As
 i(i) CROSS JOIN generate_series(40,70, 5) j ORDER BY i,j )) As foo1 LIMIT
 3;
 }}}

 This crashes the service wit EDB compiled version - but have to run it 3
 times to force a crash and sometimes it refuses to crash after a restart
 though in my garden tests (presumably because I have 20 like calls, it
 manages to consistently kick)


 {{{
 SELECT ST_AsLatLonText(foo1.the_geom, 'monkey') As result FROM ((SELECT
 ST_SetSRID(ST_Point(i,j),4326) As the_geom FROM (SELECT a*1.11111111 FROM
 generate_series(-10,50,2) As a) As i(i) CROSS JOIN generate_series(40,70,
 5) j ORDER BY i,j )) As foo1 LIMIT 3;
 }}}

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1657#comment:2>
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.