Bug report #21920

Points Geometry Become Cluster

Added by Furqan Saeed 7 months ago. Updated 7 months ago.

Status:Feedback
Priority:High
Assignee:-
Category:Data Provider/MSSQL
Affected QGIS version:3.4.5 Regression?:No
Operating System:Windows 7 64 bit Easy fix?:No
Pull Request or Patch supplied:No Resolution:
Crashes QGIS or corrupts data:No Copied to github as #:29735

Description

I am connected to same sql db both in QGIS 2.18.3 and QGIS 3.4.5. As seen in the photo below, points geometries in QGIS 2.18.3 are absolutely correct but in QGIS 3.4.5, same points become cluster.

Also "geog" column in QGIS 2.18.3 attribute table is hidden by default, I don't even find it in layer properties. However in QGIS 3.4.5, there is "geog" column in attribute table which shows special character in it.

Another issue is when I add new point feature in QGIS 3.4.5 it only saves attribute not geometry.

QGIS 2.18.3_Identify.jpg - Single Feature Attribute (288 KB) Furqan Saeed, 2019-04-24 02:07 PM

QGIS 2.18.3.jpg - Correct Geometry (500 KB) Furqan Saeed, 2019-04-24 02:07 PM

QGIS 3.4.5_Identify.jpg - Multiple Features Attributes (308 KB) Furqan Saeed, 2019-04-24 02:07 PM

QGIS 3.4.5-Madeira.jpg - Cluster Geometry (442 KB) Furqan Saeed, 2019-04-24 02:07 PM

History

#1 Updated by Giovanni Manghi 7 months ago

  • Easy fix? changed from Yes to No
  • Status changed from Open to Feedback
  • Crashes QGIS or corrupts data changed from Yes to No

Is the database Oracle?

#2 Updated by Furqan Saeed 7 months ago

No, MS SQL Server database.

#3 Updated by Jürgen Fischer 7 months ago

  • Status changed from Feedback to Open

#4 Updated by Giovanni Manghi 7 months ago

  • Status changed from Open to Feedback
  • Category changed from Geometry to Data Provider/MSSQL

Does it happen if you use another backend (i.e. PostGIS)?

Also available in: Atom PDF