Bug report #16017

Field calculator error with spatialite layer

Added by Andrew McAninch about 7 years ago. Updated about 5 years ago.

Affected QGIS version:2.18.2 Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:fixed/implemented
Crashes QGIS or corrupts data:No Copied to github as #:23932


I am using OSGEO4W QGIS 2.18.2. When I try to save edits after using the field calculator to calculate a field with a name that has capital letters, QGIS give the follow error:

1 Commit errors:
SUCCESS: 1 attribute(s) added.
ERROR: field with index 17 is not the same!
Provider: ogr
Storage: SQLite
expected field: name=WFC_wt type=QString typeName=string len=4 precision=0
retrieved field: name=wfc_wt type=QString typeName=String len=4 precision=0

Clearly I should just not use capital letters in a spatialite field name, but I use a variety of formats and would like to not have remind myself to check first.


#1 Updated by Giovanni Manghi almost 7 years ago

  • Easy fix? set to No
  • Regression? set to No

#2 Updated by Jürgen Fischer over 6 years ago

  • Category set to Unknown

#3 Updated by matteo ghetta about 5 years ago

  • Resolution set to fixed/implemented
  • Status changed from Open to Closed
  • Description updated (diff)

Tested in 3.5 and works.

Also available in: Atom PDF