[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)
+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>
More information about the grass-dev
mailing list