MSSQL: Add Multipolygon Feature creates wrong geometrytype

[qgib]

Author Name: Jan Lippmann (@j-lippmann)
Original Redmine Issue: 10793
Affected QGIS version: 3.0.0
Redmine category:data_provider/mssql
Assignee: Nyall Dawson

---

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 (Jan Lippmann)
• multipolygon_problem.7z (Jan Lippmann)

[qgib]

Author Name: Jan Lippmann (@j-lippmann)

---

I've added screencast which showing the problem.

---

• 7585 was configured as multipolygon_problem.7z

---

• multipolygon_problem.7z (Jan Lippmann)

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

• priority_id was changed from High to Normal

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

• category_id was changed from Digitising to Data Provider/MSSQL

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• regression was configured as 0
• easy_fix was configured as 0

[qgib]

Author Name: Jan Lippmann (@j-lippmann)

---

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

[qgib]

Author Name: Nyall Dawson (@nyalldawson)

---

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.

---

• description was changed from 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? to 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?

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• subject was changed from MSSQL- Add Multipolygon Feature creates wrong geometrytype to MSSQL: Add Multipolygon Feature creates wrong geometrytype
• version was changed from 2.4.0 to 3.0.0

[qgib]

Author Name: Nyall Dawson (@nyalldawson)

---

• status_id was changed from Open to In Progress
• assigned_to_id was configured as Nyall Dawson

[qgib]

Author Name: Nyall Dawson (@nyalldawson)

---

Applied in changeset 81db005.

---

• done_ratio was changed from 0 to 100
• status_id was changed from In Progress to Closed