[GRASS-user] Error in sqlite3_step()

[Craig Leat]

I have a problem with v.db.dropcol, it's changing the length of columns.

db.describe -c table=SBC1 driver=sqlite
database=/home/craig/GIS/grassdata/uMDM_ll/craig/sqlite.db
ncols: 6
nrows: 197842
Column 1: cat:INTEGER:20
Column 2: CLASS_NAME:CHARACTER:1
Column 3: LM:CHARACTER:1
Column 4: WARD:INTEGER:20
Column 5: building:CHARACTER:20
Column 6: LM_name:CHARACTER:20

v.db.dropcol map=SBC1 col=CLASS_NAME

db.describe -c table=SBC1 driver=sqlite
database=/home/craig/GIS/grassdata/uMDM_ll/craig/sqlite.db
ncols: 5
nrows: 197842
Column 1: cat:INTEGER:20
Column 2: LM:CHARACTER:1
Column 3: WARD:INTEGER:20
Column 4: building:CHARACTER:1
Column 5: LM_name:CHARACTER:1

building and LM_name have changed from length=20 to length=1

I'll test with Spearfish and update GRASS before reporting a bug, but
this may take some time. First I have to finish this job with a broken
v.db.dropcol. It's time to play with sqlitebrowser...

Craig