[GRASS-dev] [bug #5352] (grass) v.db.select segfault if SQL query is malformed

Maciek Sieczka via RT grass-bugs at intevation.de
Thu Nov 30 04:24:43 EST 2006

hbowman wrote (Thu, Nov 30 2006 04:54:41):

> v.db.select segfaults if SQL query is malformed:
> G63> v.db.select -c fish_sites col=site_id where="CAT = 1"
> Ai1
> G63> v.db.select -c fish_sites col=site_id where="CAT=1"
> Segmentation fault


Why do you think "CAT=1" is malformed and "CAT = 1" is not?

See eg. http://www.w3schools.com/sql/sql_where.asp. Both notations are allowed.

Also GRASS manual mentions both, eg.

d.vect map where="individual='juvenile'
v.db.update map=roads col=exprtest value=cat/nulltest+cat where=cat=1
echo "UPDATE roads SET exprtest=NULL WHERE cat>2" | db.execute

This bug is similar to my recent
http://intevation.de/rt/webrt?serial_num=5341, please see the recent notes.


-------------------------------------------- Managed by Request Tracker

More information about the grass-dev mailing list