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-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

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 ___

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 be

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 +0100, Matteo

[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

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 -

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

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

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