Field calculator error with spatialite layer

[qgib]

Author Name: Andrew McAninch (@spaceof7)
Original Redmine Issue: 16017
Affected QGIS version: 2.18.2
Redmine category:unknown

---

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.

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• easy_fix was configured as 0
• regression was configured as 0

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

• category_id was configured as Unknown

[qgib]

Author Name: matteo ghetta (@ghtmtt)

---

Tested in 3.5 and works.

---

• resolution was changed from to fixed/implemented
• status_id was changed from Open to Closed
• description was changed from 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.
to 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.