Bug report #11786
Qgis categorized style classification interprets null as zero from Postgis table
|Affected QGIS version:
|Pull Request or Patch supplied:
|Crashes QGIS or corrupts data:
|Copied to github as #:
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.)