[Qgis-developer] problem with GROUP BY in `Execute SQL` Processing

Matteo Ghetta matteo.ghetta at gmail.com
Fri Jan 16 01:48:16 PST 2015


Hi guys,
I'm trying to run the Processing Execute SQL algorithm with super simple
following query:

select * from au where ID > 100 group by ID

But it returns this error (Processing log):

GDAL execution console output

ERROR 1: SQL Expression Parsing Error: syntax error


No problem with other simple query like:

select * from au where ID > 100 order by ID

so maybe the error is related to *group by*.

Am I doing something wrong?

Cheers

Matteo
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20150116/1730f52e/attachment-0001.html>


More information about the Qgis-developer mailing list