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

[Rahkonen Jukka (MML)]

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.

-Jukka Rahkonen-
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20190206/b17751ee/attachment.html>