[GRASS-dev] [GRASS GIS] #1055: db.select can´t found columns generated by v.rast.stats with dbf driver

GRASS GRASS developer
1

#1055: db.select can´t found columns generated by v.rast.stats with dbf driver
----------------------------+-----------------------------------------------
Reporter: jeleniste | Owner: grass-dev@lists.osgeo.org
     Type: defect | Status: new
Priority: normal | Milestone: 6.4.0
Component: default | Version: 6.4.0 RCs
Keywords: dbf, db.select | Platform: MSWindows XP
      Cpu: Unspecified |
----------------------------+-----------------------------------------------
if I try to use in sql parameter in where clausule column generated by
v.rast.stats it return me error, column cant be found, but is presented in
table output (if not used in where clausule), using in list of columns for
select returns me error to

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

2

#1055: db.select can´t found columns generated by v.rast.stats with dbf driver
---------------------------+------------------------------------------------
  Reporter: jeleniste | Owner: grass-dev@lists.osgeo.org
      Type: defect | Status: new
  Priority: normal | Milestone: 6.4.0
Component: Database | Version: 6.4.0 RCs
Resolution: | Keywords: dbf, db.select
  Platform: MSWindows XP | Cpu: Unspecified
---------------------------+------------------------------------------------
Changes (by martinl):

  * component: default => Database

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

3

#1055: db.select can´t found columns generated by v.rast.stats with dbf driver
---------------------------+------------------------------------------------
  Reporter: jeleniste | Owner: grass-dev@lists.osgeo.org
      Type: defect | Status: new
  Priority: normal | Milestone: 6.4.0
Component: Database | Version: 6.4.0 RCs
Resolution: | Keywords: dbf, db.select
  Platform: MSWindows XP | Cpu: Unspecified
---------------------------+------------------------------------------------
Comment (by martinl):

Replying to [ticket:1055 jeleniste]:
> if I try to use in sql parameter in where clausule column generated by
v.rast.stats it return me error, column cant be found, but is presented in
table output (if not used in where clausule), using in list of columns for
select returns me error to

{{{
g.copy vect=geology,geo --o
v.rast.stats vector=geo raster=elevation colprefix=elev --v
}}}

{{{
v.info -c geo | grep elevINTEGER|elev_n
DOUBLE PRECISION|elev_min
DOUBLE PRECISION|elev_max
DOUBLE PRECISION|elev_range
DOUBLE PRECISION|elev_mean
DOUBLE PRECISION|elev_stdde
DOUBLE PRECISION|elev_varia
DOUBLE PRECISION|elev_cf_va
DOUBLE PRECISION|elev_sum
}}}

{{{
v.db.select map=geo columns=cat,elev_n,elev_min where="elev_n not NULL"
cat|elev_n|elev_min
217|725565|80.929474
262|198686|75.525719
270|689296|55.578793
405|253653|90.39637
583|21656|118.640244
720|4807|102.848068
766|7086|113.913361
862|61710|91.674515
910|45044|73.698929
921|12563|115.666611
945|9|124.292007
946|4053|75.179901
948|872|118.361198
}}}

Seems to work... Did I understood well?

Martin

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

4

#1055: db.select can´t found columns generated by v.rast.stats with dbf driver
---------------------------+------------------------------------------------
  Reporter: jeleniste | Owner: grass-dev@lists.osgeo.org
      Type: defect | Status: new
  Priority: normal | Milestone: 6.4.0
Component: Database | Version: 6.4.0 RCs
Resolution: | Keywords: dbf, db.select
  Platform: MSWindows XP | Cpu: Unspecified
---------------------------+------------------------------------------------
Comment (by jeleniste):

>
> Seems to work... Did I understood well?
>
> Martin

No

Try db.select sql = "Select cat,elev_n,elev_min from geo where=elev_n not
NULL"

this return me error

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

5

#1055: db.select can´t found columns generated by v.rast.stats with dbf driver
---------------------------+------------------------------------------------
  Reporter: jeleniste | Owner: grass-dev@lists.osgeo.org
      Type: defect | Status: new
  Priority: normal | Milestone: 6.4.0
Component: Database | Version: 6.4.0 RCs
Resolution: | Keywords: dbf, db.select
  Platform: MSWindows XP | Cpu: Unspecified
---------------------------+------------------------------------------------
Comment (by martinl):

Replying to [comment:3 jeleniste]:
> Try db.select sql = "Select cat,elev_n,elev_min from geo where=elev_n
not NULL"

it should be

{{{
db.select sql="select cat,elev_n,elev_min from geo where elev_n not NULL"
}}}

so without `=` after {{{where}}} keyword.

Martin

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

6

#1055: db.select can´t found columns generated by v.rast.stats with dbf driver
---------------------------+------------------------------------------------
  Reporter: jeleniste | Owner: grass-dev@lists.osgeo.org
      Type: defect | Status: new
  Priority: normal | Milestone: 6.4.0
Component: Database | Version: 6.4.0 RCs
Resolution: | Keywords: dbf, db.select
  Platform: MSWindows XP | Cpu: Unspecified
---------------------------+------------------------------------------------
Comment (by jeleniste):

of coururse, but
{{{
db.select sql="select cat,elev_n,elev_min from geo where elev_n not NULL"
}}}
don´t work on my distribution

{{{
GRASS 6.4> db.select sql="select cat, slope_n from vvp_plochy where elev_n
not
  NULL"
DBMI-DBF driver error:
Column 'slope_n' not found
Error in db_open_select_cursor()

GRASS 6.4>
GRASS 6.4> db.columns vvp_plochy
cat
CISLO_VVP
ID
NAZEV
slope__n
slope__min
slope__max
slope__ran
slope__mea
slope__std
slope__var
slope__cf_
slope__sum
GRASS 6.4>
slope__var
slope__cf_
slope__sum
}}}

Oh. I'm so sorry, my columns have two __ in prefix.
My fault

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

7

#1055: db.select can´t found columns generated by v.rast.stats with dbf driver
---------------------------+------------------------------------------------
  Reporter: jeleniste | Owner: grass-dev@lists.osgeo.org
      Type: defect | Status: closed
  Priority: normal | Milestone: 6.4.0
Component: Database | Version: 6.4.0 RCs
Resolution: invalid | Keywords: dbf, db.select
  Platform: MSWindows XP | Cpu: Unspecified
---------------------------+------------------------------------------------
Changes (by neteler):

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

Comment:

As far as I understand, user error. Closing.

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