QGIS » QGIS Application

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"