Processing: ogr tools broken on QGIS LTR

[qgib]

Author Name: Giovanni Manghi (@gioman)
Original Redmine Issue: 15898
Affected QGIS version: 2.14.9
Redmine category:processing/gdal
Assignee: Victor Olaya

---

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"@

[qgib]

Author Name: Victor Olaya (@volaya)

---

Fixed in changeset "19780c4d479f5bdf7fb04a8b29268fbf9e40d19e".

---

• status_id was changed from Open to Closed