[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