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

2015-01-20 Thread Even Rouault
Le mardi 20 janvier 2015 10:40:05, Jürgen E. Fischer a écrit : > 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 +010

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

2015-01-20 Thread 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 E

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

2015-01-20 Thread Matteo Ghetta
Hi Jürgen, yes, the column is ID. BTW, if I import the shapefile in SpatiaLite (or PostGIS) through DB Manager the same query works and I can easily load the file in QGIS. Maybe GROUP BY function is not supported in Processing yet? Thanks Matteo ___ Qg

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

2015-01-20 Thread 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

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

2015-01-20 Thread Roy
Hi Matteo, I thing the problem is that "GROUP BY" is not supported on shapefile format. Il 16/01/2015 12.08, Matteo Ghetta ha scritto: mmm I made some attempts but always the same parsing error.. so, you are saying that the error in Processing is related to the GEOMETRY column right? in the

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

2015-01-16 Thread Matteo Ghetta
mmm I made some attempts but always the same parsing error.. so, you are saying that the error in Processing is related to the GEOMETRY column right? in the DB manager I can run the same query and then load the file when I specify the GEOMETRY column. That's ok But why I don't have any problem wi

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

2015-01-16 Thread Régis Haubourg
Ok, I see some issues:;: 1- your query does WHERE + GROUp BY. SQL standards requires a HAVING CLAUSE with group by: select * from au group by ID HAVING ID > 100 2- Geoprocessing waits for a spatial layer in return. I think you need to add explicit aggregate operators for your columns and geom

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

2015-01-16 Thread Matteo Ghetta
Hi Régis, nope, same error with the quotes. BTW: `au` is a shapefile, but if I load it in a SpatiaLite DB and if I use DB Manager the query runs without problems. Last information: same error in 2.6 and in Master Cheers Matteo ___ Qgis-developer maili

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

2015-01-16 Thread Régis Haubourg
Hi, not sure, did you try double quotes on fields names, like: select * from au where "ID" > 100 group by "ID" ? Régis -- View this message in context: http://osgeo-org.1560.x6.nabble.com/problem-with-GROUP-BY-in-Execute-SQL-Processing-tp5181825p5181832.html Sent from the Quantum GIS - Deve

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

2015-01-16 Thread Matteo Ghetta
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 si