Bug report #13932

MSSQL Features Don't Draw when Multiple Geometry Columns are Present

Added by Christian Frugard over 4 years ago. Updated almost 2 years ago.

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

Revision da211938
Added by Nyall Dawson almost 2 years ago

[mssql] Fix handling of geometry column when multiple geometry/geography
columns are present

Fixes #13932

History

#1 Updated by Christian Frugard over 4 years ago

Also, the tabular data in the layer seems to appear correctly.

#2 Updated by Christian Frugard over 4 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 over 4 years ago

  • Assignee set to Tamas Szekeres

#4 Updated by Giovanni Manghi about 3 years ago

  • Easy fix? set to No
  • Regression? set to No

#5 Updated by Jürgen Fischer about 3 years ago

  • Assignee deleted (Tamas Szekeres)

#6 Updated by Nyall Dawson almost 2 years ago

  • Status changed from Open to In Progress
  • Assignee set to Nyall Dawson

#7 Updated by Nyall Dawson almost 2 years ago

  • % Done changed from 0 to 100
  • Status changed from In Progress to Closed

Also available in: Atom PDF