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.
git-svn-id: http://svn.osgeo.org/qgis/trunk/[email protected] c8812cc2-4d05-0410-92ff-de0c093fc19c
git-svn-id: http://svn.osgeo.org/qgis/[email protected] c8812cc2-4d05-0410-92ff-de0c093fc19c
#1 Updated by Jürgen Fischer about 13 years ago
The problem is not reproducable here. Can you post the database?
#2 Updated by Jürgen Fischer about 13 years ago
#3 Updated by Giovanni Manghi about 13 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.
#4 Updated by Jürgen Fischer about 13 years ago
fixed in d240f031 (SVN r12899).
#5 Updated by Giovanni Manghi about 13 years ago
- Resolution set to fixed
- Status changed from Open to Closed