Cannot filter by number

[qgib]

Author Name: Jonathan Moules (Jonathan Moules)
Original Redmine Issue: 11628
Affected QGIS version: 2.6.0
Redmine category:attribute_table

---

Default install of 2.6 on Windows, no plugins beyond what comes with it plus OpenLayers. (Also evident in 2.2 and 2.4).

I'm connecting to an Oracle database, it has a column (SEED_ID) of type Number (20,0).

The contents of this column are of this form:
70410000000004734180
70410000000004734181
70410000000004734182

However, QGIS in the attribute table is showing:
7.04100000000047e+19
7.04100000000047e+19
7.04100000000047e+19

Which seems weird because that's just as many characters as the number it's supposed to be replacing, but anyway.
It's also 100% useless because as you can see, they all show exactly the same values.

Furthermore, if I do "Column Filter" -> "SEED_ID", and enter:
70410000000004734180

I get no results. The query it's doing is:
"SEED_ID" = '70410000000004734180'

I've tried a few variants:

The following all fail with no results, but they SHOULD work (give or take):
"SEED_ID" = '70410000000004734180'
"SEED_ID" = 70410000000004734180
"SEED_ID" like '70410000000004734180'
"SEED_ID" like '%0000000004734180'
"SEED_ID" like '%4180'

This return all features:
"SEED_ID" like 70410000000004734180
"SEED_ID" like '%00000000047e+19'

So basically, the filter isn't filtering actual content, but is instead filtering against scientific notation. And it's impossible to filter by such columns currently.

Should it be a blocker? Seems to be failing at a fundamental GIS feature.

(Same also applies to Query Builder for a feature subset).

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• easy_fix was configured as 0
• regression 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