PostGIS layer does not classify boolean for categorized style

[qgib]

Author Name: Mike Taves (Mike Taves)
Original Redmine Issue: 12346
Affected QGIS version: 2.8.1

---

A PostGIS layer cannot be properly classified according to a boolean column for the categorized style.

For example, consider the example table:

create table qgistest (id serial, geom geometry, enabled boolean);
insert into qgistest (geom, enabled) values ('POINT(1 2)', true);
insert into qgistest (geom, enabled) values ('POINT(3 4)', false);

Add the layer to QGIS, and in the Layer Properties, change the Style to "Categorized", change Column to "enabled", and click "Classify". The results show 1 symbol without Value or Legend.

The expected result is to have at least two symbols with t and f values, which is the result by saving this layer to a Shapefile and repeating the above steps.

This is possibly related to #20484 where it may have been fixed. I don't have a trunk version, so I cannot test to see if this issue is fixed.

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

Fixed in changeset "f04c40c28330708e394f598f27c26bf0e78dea7c".

---

• status_id was changed from Open to Closed