Graduated symbol generator not recognizing real numbers properly

[qgib]

Author Name: Nate Wessel (Nate Wessel)
Original Redmine Issue: 14264
Affected QGIS version: 2.8.1
Redmine category:symbology

---

When using the style dialogue to generate a graduated color ramp, there is a failure to properly recognize real numbers. A color ramp will be generated, but it usually fails to see any negative values. If I wrap the variable in a toreal() function, all works as expected. The dataset I'm having problems with is stored in PostGIS and the column is definitely real. I've seen this happen on a number of different datasets.
The dangerous bit is that the error is very quiet, as the color ramp is still generated, and most of the map still renders as normal.

Using ubuntu 14.04 and QGIS 2.8.1

(this is my first time reporting a bug. please be easy on my errors and omissions)

---

• no_toreal__.png (Nate Wessel)
• with_toreal__.png (Nate Wessel)
• out.sql.7z (Nate Wessel)

[qgib]

Author Name: Nyall Dawson (@nyalldawson)

---

Can you share a sql dump of your dataset? Even a partial extract which demonstrates the issue will be useful.

---

• status_id was changed from Open to Feedback

[qgib]

Author Name: Nate Wessel (Nate Wessel)

---

Sample data attached!
I double checked, and this does indeed still cause the same problem for me.

---

• 9567 was configured as out.sql.7z

---

• out.sql.7z (Nate Wessel)

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• status_id was changed from Feedback to Open
• category_id was configured as Symbology

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• priority_id was changed from High to Normal

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

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

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

End of life notice: QGIS 2.18 LTR

Source:
http://blog.qgis.org/2019/03/09/end-of-life-notice-qgis-2-18-ltr/

---

• resolution was changed from to end of life
• status_id was changed from Open to Closed