[gdal-dev] SQLite dialect does not support ADD COLUMN

[Even Rouault]

On mercredi 6 février 2019 16:02:44 CET Rahkonen Jukka (MML) wrote:
> Hi,
> 
> I was awaiting that the following ogrinfo command woud add a new column but
> it didn't
> 
> ogrinfo -dialect sqlite -sql "alter table fidtest add column foo"
> fidtest.shp INFO: Open of `fidtest.shp'
>       using driver `ESRI Shapefile' successful.
> ERROR 1: In ExecuteSQL(): sqlite3_prepare_v2(alter table fidtest add foo):
>   no such table: fidtest
> 
> I did succeed with OGR SQL dialect but I wonder why SQLite dialect fails.

The SQLite dialect uses the SQLite virtual table mechanism internally. That 
mechanism cannot modify table structure.

Even

-- 
Spatialys - Geospatial professional services
http://www.spatialys.com