parser error with db.select

[hamish]

NC2008 dataset in trunk:

GRASS7> db.select precip_30ynormals_g7 \
   sql="select annual from precip_30ynormals_g7 where cat=2"

Description:
 Selects data from attribute table (performs SQL query statement(s)).

Keywords:
 database, attribute table, SQL

Usage:
 db.select [-cdvt] [sql=string] [input=name] [table=name]
   [database=name] [driver=name] [fs=character] [vs=character]
   [nv=string] [output=name] [--overwrite] [--verbose] [--quiet]

[...]
ERROR: Option <sql> does not accept multiple answers

I guess it doesn't like the 'where cat=2' ?

v.db.select where="cat=2" seems ok though.

Hamish

[hamish]

this also happens in recent 6.5svn, but it seems to work ok in 6.4svn.

see also #1444 "g.parser does not filter for duplicate output map statements"

Hamish

[glynn]

Replying to hamish:

I guess it doesn't like the 'where cat=2'

No, it doesn't like you specifying the sql= option twice. Note that the default option is sql=, not table=.

[hamish]

d'oh! the options got reordered..

I am not sure if this ticket should be closed as invalid, or if re-ordering the primary option in 6.x should be considered a break in backwards compatibility, although one that only bites those taking command line shortcuts. If it is, devbr6 should be put back to its old way before forgetting about this ticket.

Hamish

[hamish]

devbr6 reordered back to the old way in r56074.