Opened 11 years ago

Closed 11 years ago

#315 closed defect (fixed)

v.db.join fails in winNative Grass 6.3 for sqlite driver

Reported by: aprasad Owned by: grass-dev@…
Priority: major Milestone: 6.4.0
Component: Database Version: 6.3.0
Keywords: v.db.join Cc:
CPU: x86-32 Platform: MSWindows XP

Description

Grass 6.3.0 winNative (WinGRASS-6.3.0-4-Setup.exe)

NOTE: I know this is a bug because the exact same set of commands works fine on Ubuntu Linux Grass 6.3.0:

GRASS 6.3.0 (eastwide):C:\GRASS_Native >db.connect driver=sqlite database=c:/grassdb/eastwide/prasad/sqlite/ew.db

GRASS 6.3.0 (eastwide):C:\GRASS_Native >db.copy from_driver=dbf from_database=c:/grassdb/eastwide/prasad/dbf from_table=ew20km to_driver=sqlite to_database=c:/grassdb/eastwide/prasad/sqlite/ew.db to_table=ew20kmsql

GRASS 6.3.0 (eastwide):C:\GRASS_Native >db.tables -p curr_pred ew20kmsql

GRASS 6.3.0 (eastwide):C:\GRASS_Native >v.db.connect -o map=ew20km driver=sqlite

database=c:/grassdb/eastwide/prasad/sqlite/ew.db table=ew20kmsql key=cat layer=1

The table <ew20kmsql> is now part of vector map <ew20km> and may be deleted or overwritten by GRASS modules

GRASS 6.3.0 (eastwide):C:\GRASS_Native >db.columns ew20kmsql cat AREA PERIMETER EW20KM_ EW20KMID DOCLINK

GRASS 6.3.0 (eastwide):C:\GRASS_Native >db.columns curr_pred ewid ppt pptmaysep tjan tjul juljandiff tmaysep tavg ...

GRASS 6.3.0 (eastwide):C:\GRASS_Native >v.db.connect -p -c map=ew20km Vector map <ew20km> is connected by: layer <1> table <ew20kmsql> in database <c:/grassdb/eastwide/prasad/sqlite/ew.db> through driver <sqlite> with key <cat>

GRASS 6.3.0 (eastwide):C:\GRASS_Native >v.db.join map=ew20km column=EW20KMID otable=curr_pred ocolumn=ewid

ERROR: Column <> not found in table <ew20km> at layer 1

Change History (3)

comment:1 Changed 11 years ago by aprasad

I found out the reason - the v.db.join script in winNative does not parse the input arguments with the correct case ...for example $GIS_OPT_column is not recognized in the script - when I changed it to $GIS_OPT_COLUMN it worked....this is true for other parsed input arguments....hopefully this will help correct the bug.

comment:2 in reply to:  1 Changed 11 years ago by glynn

Replying to aprasad:

I found out the reason - the v.db.join script in winNative does not parse the input arguments with the correct case ...for example $GIS_OPT_column is not recognized in the script - when I changed it to $GIS_OPT_COLUMN it worked....this is true for other parsed input arguments....hopefully this will help correct the bug.

Fixed in r33630 (trunk); recommend back-porting.

comment:3 Changed 11 years ago by neteler

Resolution: fixed
Status: newclosed

Done for 6.4.svn and 6.3.svn

Markus

Note: See TracTickets for help on using tickets.