[GRASS-dev] [GRASS GIS] #1503: parser error with db.select

GRASS GIS GRASS GIS developer
1

#1503: parser error with db.select
-------------------------------+--------------------------------------------
Reporter: hamish | Owner: grass-dev@…
     Type: defect | Status: new
Priority: normal | Milestone: 7.0.0
Component: LibGIS | Version: svn-trunk
Keywords: parser, db.select | Platform: Linux
      Cpu: x86-64 |
-------------------------------+--------------------------------------------
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

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/1503&gt;
GRASS GIS <http://grass.osgeo.org>

2

#1503: parser error with db.select
-------------------------------+--------------------------------------------
Reporter: hamish | Owner: grass-dev@…
     Type: defect | Status: new
Priority: critical | Milestone: 6.5.0
Component: LibGIS | Version: svn-trunk
Keywords: parser, db.select | Platform: Linux
      Cpu: x86-64 |
-------------------------------+--------------------------------------------
Changes (by hamish):

  * priority: normal => critical
  * milestone: 7.0.0 => 6.5.0

Comment:

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

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/1503#comment:1&gt;
GRASS GIS <http://grass.osgeo.org>

3

#1503: parser error with db.select
-------------------------------+--------------------------------------------
Reporter: hamish | Owner: grass-dev@…
     Type: defect | Status: new
Priority: critical | Milestone: 6.5.0
Component: LibGIS | Version: svn-trunk
Keywords: parser, db.select | Platform: Linux
      Cpu: x86-64 |
-------------------------------+--------------------------------------------

Comment(by glynn):

Replying to [ticket:1503 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=.

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/1503#comment:2&gt;
GRASS GIS <http://grass.osgeo.org>

4

#1503: parser error with db.select
-------------------------------+--------------------------------------------
Reporter: hamish | Owner: grass-dev@…
     Type: defect | Status: new
Priority: critical | Milestone: 6.5.0
Component: LibGIS | Version: svn-develbranch6
Keywords: parser, db.select | Platform: Linux
      Cpu: x86-64 |
-------------------------------+--------------------------------------------
Changes (by hamish):

  * version: svn-trunk => svn-develbranch6

Comment:

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

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/1503#comment:3&gt;
GRASS GIS <http://grass.osgeo.org>

5

#1503: parser error with db.select
-------------------------------+--------------------------------------------
Reporter: hamish | Owner: grass-dev@…
     Type: defect | Status: new
Priority: minor | Milestone: 6.5.0
Component: LibGIS | Version: svn-develbranch6
Keywords: parser, db.select | Platform: Linux
      Cpu: x86-64 |
-------------------------------+--------------------------------------------
Changes (by hamish):

  * priority: critical => minor

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/1503#comment:4&gt;
GRASS GIS <http://grass.osgeo.org>

6

#1503: parser error with db.select
---------------------+------------------------------------------------------
  Reporter: hamish | Owner: grass-dev@…
      Type: defect | Status: closed
  Priority: minor | Milestone: 6.5.0
Component: LibGIS | Version: svn-develbranch6
Resolution: fixed | Keywords: parser, db.select
  Platform: Linux | Cpu: x86-64
---------------------+------------------------------------------------------
Changes (by hamish):

  * status: new => closed
  * resolution: => fixed

Comment:

devbr6 reordered back to the old way in r56074.

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/1503#comment:5&gt;
GRASS GIS <http://grass.osgeo.org>