[GRASS-user] db.select driver issue

Richard Chirgwin rchirgwin at ozemail.com.au
Sat Mar 27 17:54:07 EDT 2010

In a previous thread, I mentioned trouble with Grass-GIS's database 
driver on complex queries, but couldn't remember an example.

I've bumped into one this morning. In MySQL, this query works fine:

select sum(population) from australia

in Grass-GIS:

echo "select sum(population) from Australia" | db.select -c


> DBMI-DBF driver error:
> SQL parser error: syntax error, unexpected '(', expecting FROM 
> processing '('
> in statement:
> select sum(population) from Australia
> Error in db_open_select_cursor()

More information about the grass-user mailing list