[GRASS-dev] [GRASS GIS] #3919: db.dropcolumn and v.db.dropcolumn do not drop columns

[GRASS GIS]

#3919: db.dropcolumn and v.db.dropcolumn do not drop columns
--------------------------------------------+------------------------------
 Reporter:  veroandreo                      |      Owner:  grass-dev@…
     Type:  defect                          |     Status:  new
 Priority:  normal                          |  Milestone:  7.8.1
Component:  Database                        |    Version:  git-
                                            |  releasebranch78
 Keywords:  db.dropcolumn, v.db.dropcolumn  |        CPU:  x86-64
 Platform:  Linux                           |
--------------------------------------------+------------------------------
 When trying to drop one (or many) columns from the attribute table of a
 vector map using G7:v.db.dropcolumn and G7:db.dropcolumn, I get the
 following error and the column(s) are not removed:

 {{{
 v.db.dropcolumn map=segs_stats_map column=aspect_5m_cba_min
 DBMI-SQLite driver error:
 Error in sqlite3_prepare():
 incomplete input

 DBMI-SQLite driver error:
 Error in sqlite3_prepare():
 incomplete input

 ERROR: Error while executing: 'CREATE TEMPORARY TABLE
 segs_stats_map_backup
        (cat INTEGER, IGN_Cba_02m_blue_min DOUBLE PRECISION,
        IGN_Cba_02m_blue_max DOUBLE PRECISION, IGN_Cba_02m_blue_range
 DOUBLE
        PRECISION, IGN_Cba_02m_blue_mean DOUBLE PRECISION,
        IGN_Cba_02m_blue_stddev DOUBLE PRECISION, IGN_Cba_02m_blue_median
        DOUBLE PRECISION, IGN_Cba_02m_blue_first_quart DOUBLE PRECISION,
        IGN_Cba_02m_blue_third_quart DOUBLE PRECISION,
        IGN_Cba_02m_blue_perc_90
        ...
        IGN_Cba_02m_ndvi_median_nbrmean DOUBLE PRECISION,
        IGN_Cba_02m_ndvi_median_nbrstddev DOUBLE PRECISION,
        IGN_Cba_02m_ndvi_first_quart_nbrmean DOUBLE PRECISION,
        IGN_Cba_02m_ndvi_first_quart_nbrstddev DOUBLE PRE'
 ERROR: Deleting column failed


 db.dropcolumn -f table=segs_stats_map column=aspect_5m_cba_min
 DB settings already defined, nothing to do
 Forcing ...
 DBMI-SQLite driver error:
 Error in sqlite3_prepare():
 incomplete input

 DBMI-SQLite driver error:
 Error in sqlite3_prepare():
 incomplete input

 ERROR: Error while executing: 'CREATE TEMPORARY TABLE
        segs_stats_map_backup(cat INTEGER, IGN_Cba_02m_blue_min DOUBLE
        PRECISION, IGN_Cba_02m_blue_max DOUBLE PRECISION,
        IGN_Cba_02m_blue_range DOUBLE PRECISION,
        ...
        IGN_Cba_02m_ndvi_first_quart_nbrmean DOUBLE PRECISION,
        IGN_Cba_02m_ndvi_first_quart_nbrstddev DOUBLE PREC'
 ERROR: Cannot continue (problem deleting column)
 }}}

 According to the manual, one only needs to pass the table or vector name
 and the column name(s). What else can be missing?

 I checked with G7:v.connect and the table is connected to the vector. The
 vector is the output of i.segment.stats.

 I tried both in 78 branch and dev, and I get the same error.

-- 
Ticket URL: <https://trac.osgeo.org/grass/ticket/3919>
GRASS GIS <https://grass.osgeo.org>