Bug report #11971
MSSQL data with Z and M where Z is NULL wont display
|Affected QGIS version:||2.6.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 #:||20178|
If the Z value is NULL in a MSSQL Linestring or Point geometry, the table will load but the data will not display. Since MSSQL must have a value for Z if you have a value for M because the format is POINT (X Y Z M), it is possible to use NULL for the Z when there is an unknown value.
This happens frequently, due to the fact that MSSQL is often used with ESRI products which writes NULL for Z when Z is unknown and M is known.
Example geometry data:
POINT (1199100.2299588919 880237.32388755679 NULL 4.2200000000011642)
Fix #11971 - Fix display of MS SQL layers with z and m values
Funded by TechnoglogyOne, Australia