Opened 8 years ago

Closed 8 years ago

Last modified 8 years ago

#1208 closed defect (invalid)

v.to.db option=start/end fails to populate database

Reported by: voncasec Owned by: grass-dev@…
Priority: normal Milestone: 6.4.1
Component: Vector Version: svn-releasebranch64
Keywords: v.to.db Cc:
CPU: x86-64 Platform: Linux

Description

I am unable to upload the start or end coordinates of a line segment to a database using the v.to.db command.

v.to.db map=IPLines_NorthBlock@IdealizedGrid? option=start qcolumn=Start

I have tested using the North Carolina database as follows:

v.db.addcol map=busroute11@PERMANENT columns=test double v.to.db map=busroute11@PERMANENT option=end columns=test (Same error is reported for option=start)

v.to.db -p does successfully print all of the coordinates

Reading features... Updating database... DBMI-DBF driver error: SQL parser error: syntax error, unexpected '(', expecting NAME processing '(' in statement: update busroute11 set test = 637239.56871539, (null) = 226030.942582791 where cat = 1 Error in db_execute_immediate() 1 categories read from vector map (layer 1) 1 records selected from table (layer 1) 1 categories read from vector map exist in selection from table 0 records updated/inserted (layer 1) 1 update/insert errors (layer 1)

Change History (2)

comment:1 Changed 8 years ago by voncasec

Resolution: invalid
Status: newclosed

comment:2 Changed 8 years ago by martinl

option=start/end requires at least two columns - the module should print error message and exit - fixed in r44201.

Note: See TracTickets for help on using tickets.