Save as shapefile fails on PostGIS layer with joined MSSQL Table

[qgib]

Author Name: Olivier Monod (Olivier Monod)
Original Redmine Issue: 12841
Affected QGIS version: master

---

When exporting a PostGIS layer with a joined MSSQL table, the exports fails due to an invalid type issue on uint on QGIS 2.8.1, 2.8.2 and 2.9.0-master

---

Related issue(s): #19316 (relates)
Redmine related issue(s): 10970

---

[qgib]

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

---

Please provide more information about the involved tables and how they are joined and possibly the verbatim error message you get.

---

• status_id was changed from Open to Feedback

[qgib]

Author Name: Olivier Monod (Olivier Monod)

---

Join is done on integer field on postgres' side (target layer) and on numeric(10,0) field type on MSSQL's side (joined table).

The verbose error message (french, sorry):

Type invalide pour le champ Divisions_DIV_HORS_INVENTAIRE[23]: réception de uint avec le type 0
Type invalide pour le champ Divisions_DIV_HORS_INVENTAIRE[23]: réception de uint avec le type 1

Looking into the joined layer's structure, the field @Divisions_DIV_HORS_INVENTAIRE[23]@ is of type "(bit,null)":https://msdn.microsoft.com/en-us/library/ms177603.aspx which is used as a boolean.

So, it looks like the shapefile export procedure fails to convert the bit value into FTLogical which is the "xBase logical":http://shapelib.maptools.org/dbf_api.html field type.

Hope it helps!

[qgib]

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

---

Fixed in changeset "8d0c28117641c6d9826bf31ce614994ffdb00287".

---

• status_id was changed from Feedback to Closed