Bug report #6772
Categorized Style: if column is "character" and too long in PostGIS then style takes on null value
| Status: | Closed | ||
|---|---|---|---|
| Priority: | Normal | ||
| Assignee: | - | ||
| Category: | Data Provider/PostGIS | ||
| Affected QGIS version: | 1.8.0 | Regression?: | No |
| Operating System: | Easy fix?: | No | |
| Pull Request or Patch supplied: | No | Resolution: | not reproducable |
| Crashes QGIS or corrupts data: | No | Copied to github as #: | 15923 |
Description
On creating a categorized style on a layer coming out of PostGIS, the column I select is of a 'character' datatype and the character length in PosgreSQL is longer than the number of characters in the data. The result is all features take on a style of the null value. If you store varying length characters in the field it has the same effect.
It may not be good practice store data with less characters than the defined character length in a character field however it can happen and it took me sometime work out the problem, so a fix in QGIS would be ideal.
History
#1
Updated by Giovanni Manghi almost 7 years ago
- Easy fix? set to No
- Regression? set to No
#2
Updated by Giovanni Manghi about 6 years ago
- Status changed from Open to Feedback
Please test with a recent QGIS release (2.18 or 3), if the issue/request is still valid change the affected version accordingly, if is fixed/implemented then close the ticket. Thanks!
#3
Updated by Giovanni Manghi over 5 years ago
- Resolution set to not reproducable
- Status changed from Feedback to Closed
- Description updated (diff)
Closing for lack of feedback.