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

[Jürgen E. Fischer]

Hi Matteo,

On Tue, 20. Jan 2015 at 09:47:50 +0100, Matteo Ghetta wrote:
> yes, the column is ID.

Meaning that ID is the only column in au?  Did you try to use ID instead of *?


> On Fri, 16. Jan 2015 at 10:48:16 +0100, Matteo Ghetta wrote:
> > GDAL execution console output
> >
> > ERROR 1: SQL Expression Parsing Error: syntax error

> Maybe GROUP BY function is not supported in Processing yet?

Well, I don't really know processing, but it looks more like an error from OGR.  

Anyway, my observation was just about the SQL.  You usually don't use * with
GROUP BY, because you can only select columns that appear in the GROUP BY and
can only use other in aggregate functions (min, max, sum...).

Maybe you can use: select distinct id from au


Jürgen

-- 
Jürgen E. Fischer           norBIT GmbH             Tel. +49-4931-918175-31
Dipl.-Inf. (FH)             Rheinstraße 13          Fax. +49-4931-918175-50
Software Engineer           D-26506 Norden             http://www.norbit.de
QGIS release manager (PSC)  Germany                    IRC: jef on FreeNode                         
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 827 bytes
Desc: Digital signature
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20150120/4a9f64bd/attachment.pgp>