Bug report #13932
MSSQL Features Don't Draw when Multiple Geometry Columns are Present
| Status: | Closed | ||
|---|---|---|---|
| Priority: | Normal | ||
| Assignee: |  Nyall Dawson | ||
| Category: | Data Provider/MSSQL | ||
| Affected QGIS version: | 2.12.0 | Regression?: | No |
| Operating System: | Easy fix?: | No | |
| Pull Request or Patch supplied: | No | Resolution: | |
| Crashes QGIS or corrupts data: | No | Copied to github as #: | 21950 |
Description
In a table with multiple sptatial columns, it seems only one of the columns can be added and draw its features. Both columns appear when navigating through the "Add MSSQL Spatial Layer" menus. One of the layers will function properly, the other will add to the project, but will not draw any of its features on the map. Curiously, you can select the dysfunctional layer and save the layer to (Shapefile,TAB file, etc) and the features will draw properly in the newly created layer. Deleting one of the columns in the table, so that there is now only one spatial seems to fix the issue.
Associated revisions
[mssql] Fix handling of geometry column when multiple geometry/geography
columns are present
Fixes #13932
History
#1
Updated by Christian Frugard almost 9 years ago
Also, the tabular data in the layer seems to appear correctly.
#2
Updated by Christian Frugard almost 9 years ago
Also, I am finding that after some period of time, the "layer" that does work, stops functioning properly as well.
#3
Updated by Christian Frugard almost 9 years ago
- Assignee set to Tamas Szekeres
#4
Updated by Giovanni Manghi over 7 years ago
- Easy fix? set to No
- Regression? set to No
#5
Updated by Jürgen Fischer over 7 years ago
- Assignee deleted (
Tamas Szekeres)
#6
Updated by Nyall Dawson about 6 years ago
- Status changed from Open to In Progress
- Assignee set to Nyall Dawson
#7
Updated by Nyall Dawson about 6 years ago
- % Done changed from 0 to 100
- Status changed from In Progress to Closed
Applied in changeset qgis|da211938944cda270976244115f21fd4ef6c825f.