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

[Maciek Sieczka via RT]

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

Hamish,

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.
http://grass.itc.it/grass63/manuals/html63_user/sql.html:

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.

Maciek


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