Bug report #11786
Qgis categorized style classification interprets null as zero from Postgis table
|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.)