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