Bug report #15898

Processing: ogr tools broken on QGIS LTR

Added by Giovanni Manghi about 4 years ago. Updated about 4 years ago.

Status:Closed
Priority:Severe/Regression
Assignee:Victor Olaya
Category:Processing/GDAL
Affected QGIS version:2.14.9 Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:
Crashes QGIS or corrupts data:No Copied to github as #:23816

Description

At some point along the LTR releases the ogr based tools git broke. They work for example on 2.14.3 but not on 2.14.8.
2.18 is also ok, that suggest that probably this was a thing that was fixed there but not backported.

The problem is the following:
now also input layer are transformed into temporary layers before being processed, so for example this is on 2.14.3 (working)

GDAL command:
cmd.exe /C ogr2ogr.exe "C:\\Users\\qgis\\AppData\\Local\\Temp\\processing0e8e85b5d60946b98f64d45d52dc8d9a\\534dc2c009d0437d93cdb1fd62809976\\OUTPUTLAYER.shp" E:\\training\\postgresql_postgis_training\\data\\madeira_3061\\freguesias.shp freguesias -dialect sqlite -sql "SELECT ST_Union(geometry),Concelho FROM 'freguesias' GROUP BY Concelho"

this is on 2.14.9 (not working)

cmd.exe /C ogr2ogr.exe "C:\\Users\\qgis\\AppData\\Local\\Temp\\processing4c66b9ac37844646af869626f3a60cae\\f02106d06c284d518a3b57f1db516e81\\OUTPUTLAYER.shp" C:\\Users\\qgis\\AppData\\Local\\Temp\\processing4c66b9ac37844646af869626f3a60cae\\1480172091.142.shp 1480172091.142 -dialect sqlite -sql "SELECT ST_Union(geometry),Concelho FROM 'freguesias' GROUP BY Concelho"
GDAL command output:
Warning 1: layer names ignored in combination with -sql.
ERROR 1: In ExecuteSQL(): sqlite3_prepare(SELECT ST_Union(geometry),Concelho FROM 'freguesias' GROUP BY Concelho):
no such table: freguesias

and 2.18 (working)

cmd.exe /C ogr2ogr.exe "C:\\Users\\qgis\\AppData\\Local\\Temp\\processingba7f93cc11e14726be7c277aa87aef5e\\1413d767da6d4209b73c00901446885c\\OUTPUTLAYER.shp" C:\\Users\\qgis\\AppData\\Local\\Temp\\processingba7f93cc11e14726be7c277aa87aef5e\\1480172157.252.shp 1480172157.252 -dialect sqlite -sql "SELECT ST_Union(geometry),Concelho FROM '1480172157.252' GROUP BY Concelho"

Associated revisions

Revision 19780c4d
Added by Victor Olaya about 4 years ago

[processing] fixed file extension when exporting layer

fixes #15898

Revision 7613c296
Added by Victor Olaya about 4 years ago

[processing] fixed file extension when exporting layer

fixes #15898

History

#1 Updated by Victor Olaya about 4 years ago

  • Status changed from Open to Closed

Also available in: Atom PDF