Bug report #2410
field calculator results may violate spatialite type contraints
|Affected QGIS version:||Regression?:||No|
|Operating System:||All||Easy fix?:||No|
|Pull Request or Patch supplied:||Resolution:||fixed|
|Crashes QGIS or corrupts data:||Copied to github as #:||12470|
It's possible to turn editing on for spatialite layers, use e.g. field calculator or add geometries but it fails saving because spatialite provider is read-only.
This is annoying and confuses users because they think it's their mistake.
#3 Updated by Giovanni Manghi over 11 years ago
A few notes (tested on both linux and xp with qgis trunk and the spatialite sample dataset):
*) add a spatialite vector, open attributes properties and add a column. Save changes. If you open the attribute table the new column do not show (not even in the field calculator). You need to remove the layer and add it again to see the new column (and be able to populate it).
*) as consequence if you add spatialite layer, toggle editing, open the field calculator and try to populate a new column, qgis will fail
Could not commit changes to layer Towns Errors: SUCCESS: 1 attribute(s) added. ERROR: 8101 attribute value change(s) not applied.