[postgis-devel] [PostGIS] #1657: Crasher on ST_AsLatLonText on mingw64

PostGIS trac at osgeo.org
Fri Mar 16 01:05:46 PDT 2012


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

Comment(by robe):

 Sadly its still crashing, but not sure its crashing in the same place.  As
 far as I can tell, it seems to happen more or less guaranteed after a null
 that has no args after a run of null.

 So for example the garden tester does 30 ST_AsLonLat tests (without format
 args) before it crashes.
 The tests that come right before the crasher that pass are all NULL tests.
 try this sequence
 {{{
 SELECT ST_AsLatLonText(foo1.the_geom) As result FROM ((SELECT CAST(Null As
 geometry) As the_geom)) As foo1 LIMIT 3;

 SELECT ST_AsLatLonText(foo1.the_geom) As result FROM ((SELECT CAST(Null As
 geometry) As the_geom FROM generate_series(1,4) As foo)) As foo1 LIMIT 3;

 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;

 }}}

 The last one crashes, but I can run it stand alone 10 - 20 times as long
 as I don't precede it by those other 2 it seems.

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


More information about the postgis-devel mailing list