Bug report #11786

Qgis categorized style classification interprets null as zero from Postgis table

Added by Rob Flemming about 9 years ago. Updated about 9 years ago.

Affected QGIS version:2.6.1 Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:
Crashes QGIS or corrupts data:No Copied to github as #:20013


I realize this is similar to an issue from over seven years ago that was closed #962, but i don't understand the solution given then and haven't been able to resolve the issue I am having now.

I have a Postgis table with a few null values in an int field and no zeros. When I style the layer with a categorized classification on that field, classes are added for both 0 and null, and on the map the nulls are rendered using the symbol for zero.
When I look at the attribute table, I see the NULLs where I expect them.
(In this case it's not a big deal, i can just change the label for the zero to 'null', but if I had actual zero's in my data, they would also be drawn with the same value.)

Thanks, Rob

qgis_null_as_zero.png (114 KB) Rob Flemming, 2014-12-03 11:55 AM

Associated revisions

Revision e3e42f02
Added by Jürgen Fischer about 9 years ago

fix support for null values in categories (fixes #11786)


#1 Updated by Giovanni Manghi about 9 years ago

  • Affected QGIS version changed from 2.4.0 to 2.6.1
  • OS version deleted (7)
  • Operating System deleted (Windows)
  • Priority changed from Normal to Severe/Regression

This was working as expected in previous QGIS releases (like 2.0.1).

#2 Updated by Jürgen Fischer about 9 years ago

  • Status changed from Open to Closed

Also available in: Atom PDF