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

[Jürgen E. Fischer]

Hi Matteo,

On Fri, 16. Jan 2015 at 10:48:16 +0100, Matteo Ghetta wrote:
> I'm trying to run the Processing Execute SQL algorithm with super simple
> following query:
> 
> select * from au where ID > 100 group by ID

Um, is ID the only column?  Otherwise I'd expect that it needs to be
(as it would be undefined what to return for the other columns):

select id from au where id > 100 group by ID


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/69fcd4ca/attachment.pgp>