MSSQL datetime field type error with memorylayer

[qgib]

Author Name: Nikolaus Batlogg (Nikolaus Batlogg)
Original Redmine Issue: 14368
Affected QGIS version: 2.8.4
Redmine category:unknown

---

Mssql Server fields of datetime type cannot be added to a memory layer. If QGSFIELD is a List (with members of Type QgsField), derived from a Mssql Server Table layer connected to QGIS,
the method

aMemoryLayer.QgsVectorDataProvider.addAttributes(QGSFIELD)

fails.

This is for both, tables that are connected using the MSSQL driver and tables that are connected over ODBC. However, the same procedure is successful, if the destination layer aMemoryLayer is a file based Shapefile. So it seems, that only Memory Layer Storage Types are affected by this bug.
The MSSQL Server Version is 2012.

[qgib]

Author Name: Nyall Dawson (@nyalldawson)

---

Fairly certain this is fixed in 2.13. Can you please download a nightly release and test?

---

• status_id was changed from Open to Feedback

[qgib]

Author Name: Nikolaus Batlogg (Nikolaus Batlogg)

---

Thanks for the prompt reply! Test successful - MSSQL Server datetime fields can be added to a memory layer without any problem. Tested Version: QGIS 2.13 Codeversion fab8dc2
Will there be a similar Fix for the current Long Term Release (2.8.X) too?

[qgib]

Author Name: Nyall Dawson (@nyalldawson)

---

The fix is quite intrusive and not suitable for backporting unfortunately.

---

• resolution was changed from to invalid
• status_id was changed from Feedback to Closed

[qgib]

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

---

• category_id was configured as Unknown