QGIS saves integer field when I create a new real field through field calculator (Update field works as intended)

[qgib]

Author Name: Stefan Newluck (Stefan Newluck)
Original Redmine Issue: 19050
Affected QGIS version: 2.18.2
Redmine category:attribute_table
Assignee: Alessandro Pasotti

---

Problem:

When I create a new real field from within field calculator and calculate a decimal value, it is displayed correctly until I hit save. After save the field is saved as integer.

Please see the attached screenshot for an illustration.

What should happen:

The field should of course stay real.

Workaround:

Hit "Create field" and create a real field there. Then open field calculator and calculate decimal values into that field by updating it. Hit save and the field stays real.

Steps to reproduce:

0. Download this open data shapefile that I just use to confirm this bug: http://data.statistik.gv.at/data/OGDEXT_POLBEZ_1_STATISTIK_AUSTRIA_20180101.zip
1. Open the shapefile's attribute table and start editing
2. Create a dummy integer field
3. Open field calculator and calculate a new field with the ratio of the two integer fields
4. Save the table
5. The real field turns into integer.

---

• QGIS_bug.PNG (Stefan Newluck)

[qgib]

Author Name: Alessandro Pasotti (@elpaso)

---

I reproduced the issue, it looks like this is due to the "Output field length" value which is set to 0 by default when adding the field from "Create field" while the default is 10 when created from the calculator.

Can you please confirm my findings?

---

• assigned_to_id was configured as Alessandro Pasotti

[qgib]

Author Name: Alessandro Pasotti (@elpaso)

---

Requires backport

#7143

---

• regression was changed from 0 to 1
• resolution was changed from to fixed/implemented
• pull_request_patch_supplied was changed from 0 to 1
• status_id was changed from Open to In Progress

[qgib]

Author Name: Stefan Newluck (Stefan Newluck)

---

Alessandro Pasotti wrote:

I reproduced the issue, it looks like this is due to the "Output field length" value which is set to 0 by default when adding the field from "Create field" while the default is 10 when created from the calculator.

Can you please confirm my findings?

Exactly this is the difference. If I set the "Output field length" to 0 in field calculator, decimal values are stored correctly upon save.

Thank you for looking into it! I'm looking forward to testing the fix. :)

[qgib]

Author Name: Anónimo (Anónimo)

---

Applied in changeset 033071a.

---

• status_id was changed from In Progress to Closed
• done_ratio was changed from 0 to 100