[GRASS-dev] [GRASS GIS] #315: v.db.join fails in winNative Grass 6.3 for sqlite driver

[GRASS GIS]

#315: v.db.join fails in winNative Grass 6.3 for sqlite driver
-----------------------+----------------------------------------------------
 Reporter:  aprasad    |       Owner:  grass-dev at lists.osgeo.org
     Type:  defect     |      Status:  new                      
 Priority:  major      |   Milestone:  6.4.0                    
Component:  Database   |     Version:  6.3.0                    
 Keywords:  v.db.join  |    Platform:  MSWindows XP             
      Cpu:  x86-32     |  
-----------------------+----------------------------------------------------
 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

-- 
Ticket URL: <http://trac.osgeo.org/grass/ticket/315>
GRASS GIS <http://grass.osgeo.org>