[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
Resolution:              |   Keywords:  db.dropcolumn, v.db.dropcolumn
       CPU:  x86-64      |   Platform:  Linux
-------------------------+--------------------------------------------

Comment (by mlennert):

 From the error message, it looks like an issue with the length of the SQL
 statement creating the temporary table (necessary since SQLite does not
 implement ALTER TABLE DROP COLUMN). But AFAICT, SQLite's query size limit
 is pretty big (1 000 000 bytes by default).

 Could you try by altering your local copy to print the column definition:


 {{{
 coltypes = ", ".join(coltypes)
 +print(coltypes)
 }}}

 That would allow to run an SQL statement directly in SQLite to test
 whether this works.

 If this is the issue, we could test for the length of the column
 definition and cut it into several parts if necessary using ALTER TABLE
 ADD COLUMN with parts 2+.

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