[GRASS-dev] [grass-code I][520] v.overlay: "SQL parser error" if output name is "and", "or" or "not"

[grass-dev at grass.itc.it]

code I item #520, was opened at 2007-10-23 19:33
Status: Open
Priority: 3
Submitted By: Maciej Sieczka (msieczka)
Assigned to: Nobody (None)
Summary: v.overlay: "SQL parser error" if output name is "and", "or" or "not" 
Issue type: module bug
Issue status: None
GRASS version: CVS HEAD
GRASS component: vector
Operating system: all
Operating system version: 
GRASS CVS checkout date, if applies (YYMMDD): 071023


Initial Comment:
I don't think vector names same as logical operators are not allowed. But they make v.overlay fail:

$ v.overlay ainput=small_box atype=area binput=big_box btype=area output=not operator=and

Copying vector objects from vector map <small_box>...
 100%
Collecting input attributes...
WARNING: Database connection not defined for layer 1
Copying vector objects from vector map <big_box>...
 100%
Collecting input attributes...
WARNING: Database connection not defined for layer 1
DBMI-DBF driver error:
SQL parser error:
in statement:
create table not (cat integer , a_cat integer, b_cat integer )
Error in db_execute_immediate()

ERROR: Unable to create table: 'create table not (cat integer , a_cat
       integer, b_cat integer )'



Same v.overaly command line, but with output other than "and", "or", "not", works OK.

Maciek


----------------------------------------------------------------------

You can respond by visiting: 
http://wald.intevation.org/tracker/?func=detail&atid=204&aid=520&group_id=21