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

GRASS GIS trac at osgeo.org
Fri Oct 11 06:03:50 PDT 2019

#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)

 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>

More information about the grass-dev mailing list