Bug report #13932
MSSQL Features Don't Draw when Multiple Geometry Columns are Present
|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|
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.