Bug report #10793

MSSQL: Add Multipolygon Feature creates wrong geometrytype

Added by Jan Lippmann almost 10 years ago. Updated over 5 years ago.

Status:Closed
Priority:Normal
Assignee:Nyall Dawson
Category:Data Provider/MSSQL
Affected QGIS version:3.0.0 Regression?:No
Operating System:Windows Easy fix?:No
Pull Request or Patch supplied:No Resolution:
Crashes QGIS or corrupts data:No Copied to github as #:19174

Description

if i digitise a new multipolygonfeature in a MSSQL-Multipolygonlayer (with avoid intersections of new features) and force intersections while digitising,
the geometrytype of the new polygon is "Polygon" and not as expected "Multipolygon".

from this moment all other new added "Multipolygons" are "Polygons"

the problem occurs with the mssql provider and qgis 2.2 and 2.4
there are no problems under postgres provider.(oracle provider not tested)

snapping options and multipolygontable connection are in the screenshot

can anybody reproduce this problem?

connection_multipolygonlayer.png (22 KB) Jan Lippmann, 2014-07-03 04:46 AM

multipolygon_problem.7z (831 KB) Jan Lippmann, 2014-07-03 05:13 AM

Associated revisions

Revision 81db0052
Added by Nyall Dawson over 5 years ago

[mssql] Fix single geometry types are added to multi geometry type layers

Fixes #10793

History

#1 Updated by Jan Lippmann almost 10 years ago

I've added screencast which showing the problem.

#2 Updated by Jürgen Fischer almost 10 years ago

  • Priority changed from High to Normal

#3 Updated by Jürgen Fischer almost 9 years ago

  • Category changed from Digitising to Data Provider/MSSQL

#4 Updated by Giovanni Manghi almost 7 years ago

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

#5 Updated by Jan Lippmann about 6 years ago

this issue is still present in actual master 2.99. please give a feedback, if sample data needed.

#6 Updated by Nyall Dawson about 6 years ago

  • Description updated (diff)

As far as I'm aware no one is working on fixing this bug - if it's critical to you please consider sponsoring a fix or raising discussion on the qgis-dev list.

#7 Updated by Giovanni Manghi about 6 years ago

  • Subject changed from MSSQL- Add Multipolygon Feature creates wrong geometrytype to MSSQL: Add Multipolygon Feature creates wrong geometrytype
  • Affected QGIS version changed from 2.4.0 to 3.0.0

#8 Updated by Nyall Dawson over 5 years ago

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

#9 Updated by Nyall Dawson over 5 years ago

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

Also available in: Atom PDF