Bug report #11628

Cannot filter by number

Added by Jonathan Moules almost 6 years ago. Updated over 1 year ago.

Category:Attribute table
Affected QGIS version:2.6.0 Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:end of life
Crashes QGIS or corrupts data:No Copied to github as #:19881


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:

However, QGIS in the attribute table is showing:

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:

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).


#1 Updated by Giovanni Manghi over 3 years ago

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

#2 Updated by Giovanni Manghi over 1 year ago

  • Resolution set to end of life
  • Status changed from Open to Closed

Also available in: Atom PDF