Bug#856472: gdal-bin: SrcDataSource ODBC Segmentation fault
Andy Wood
agw at bas.ac.uk
Wed Mar 1 12:17:28 UTC 2017
Package: gdal-bin
Version: 2.1.2+dfsg-3
Severity: important
Dear Maintainer,
ogrinfo -ro -al test.xml
INFO: Open of `test.xml'
using driver `OGR_VRT' successful.
Segmentation fault
The contents of test.xml are:
<OGRVRTDataSource>
<OGRVRTLayer name="r1435252">
<SrcDataSource>ODBC:UID/PWD at DSN,</SrcDataSource>
<SrcSQL>
select s.ring,
to_char((lat_deg+(lat_min/60.0))*decode(n_s,'N',1.0,'S',-1.0,0.0),'999.999') lat,
to_char((lon_deg+(lon_min/60.0))*decode(e_w,'E',1.0,'W',-1.0,0.0),'999.999') lon
from ringing_dictionary r1, sites si, catch_details d, catch_details cd,
schedule s
where d.site_code = si.site_code
and s.ring_size = d.ring_size and s.ring = d.ring
and d.obs_date > s.ring_date
and s.ring_size = cd.ring_size and s.ring = cd.ring
and cd.obs_date = s.ring_date
and nvl(d.activity,'XXX') = r1.code and r1.segment in ('ACT','NULL')
and s.ring = '1435252'
</SrcSQL>
<GeometryType>wkbPoint</GeometryType>
<LayerSRS>WGS84</LayerSRS>
<GeometryField encoding="PointFromColumns" x="LON" y="LAT"/>
<Field name="ring" src="RING" type="String"/>
</OGRVRTLayer>
</OGRVRTDataSource>
The above SrcSQL works fine when tested using isql and the same DSN UID and PWD.
This used to work in the recent past in Testing, but I have not run it for a few months.
The same fault appears in other cases with different SQL, in other words I cannot now get
an ODBC data source to work with ogrinfo/ogr2ogr.
Andy.
-- System Information:
Debian Release: 9.0
APT prefers testing
APT policy: (900, 'testing'), (300, 'unstable')
Architecture: amd64 (x86_64)
Kernel: Linux 4.9.0-1-amd64 (SMP w/4 CPU cores)
Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)
Versions of packages gdal-bin depends on:
ii libc6 2.24-9
ii libgcc1 1:6.3.0-6
ii libgdal20 [gdal-abi-2-1-2] 2.1.2+dfsg-3
ii libstdc++6 6.3.0-6
gdal-bin recommends no packages.
Versions of packages gdal-bin suggests:
pn libgdal-grass <none>
ii python-gdal 2.1.2+dfsg-3
-- no debconf information
More information about the Pkg-grass-devel
mailing list