[GRASS-user] db.select driver issue

GRASS GRASS user
1

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

returns:

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

Richard

2

Richard, FYI the problem may be located at the driver level: with 'pg'
driver this query works fine.

Bye,
Vincent

Le dimanche 28 mars 2010 à 08:54 +1100, Richard Chirgwin a écrit :

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

returns:

> 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()
Richard
_______________________________________________
grass-user mailing list
grass-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-user

3

On 03/28/2010 11:08 AM, Vincent Bain wrote:

Richard, FYI the problem may be located at the driver level: with 'pg'
driver this query works fine.

Bye,
Vincent

Le dimanche 28 mars 2010 à 08:54 +1100, Richard Chirgwin a écrit :
   

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

returns:

DBMI-DBF driver error:
       

So is it a dbf driver or mysql?
db.connect -p??

SQL parser error: syntax error, unexpected '(', expecting FROM
processing '('
in statement:
select sum(population) from Australia

Error in db_open_select_cursor()
       

Richard
_______________________________________________
grass-user mailing list
grass-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-user

_______________________________________________
grass-user mailing list
grass-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-user

This mail was received via Mail-SeCure System.

--
Micha Silver
http://www.surfaces.co.il/
Arava Development Co. +972-52-3665918

4

Micha Silver wrote:

On 03/28/2010 11:08 AM, Vincent Bain wrote:

Richard, FYI the problem may be located at the driver level: with 'pg'
driver this query works fine.

Bye,
Vincent

Le dimanche 28 mars 2010 à 08:54 +1100, Richard Chirgwin a écrit :
  

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

returns:

DBMI-DBF driver error:
       

So is it a dbf driver or mysql?
db.connect -p??

Whack. I think the cluestick just hit me. I will double-check the connection and try again ...

RC

SQL parser error: syntax error, unexpected '(', expecting FROM
processing '('
in statement:
select sum(population) from Australia

Error in db_open_select_cursor()
       

Richard
_______________________________________________
grass-user mailing list
grass-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-user

_______________________________________________
grass-user mailing list
grass-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-user

This mail was received via Mail-SeCure System.