MS SQL uniqueidentifier data type is not supported

[qgib]

Author Name: Ali Diba (Ali Diba)
Original Redmine Issue: 9007
Affected QGIS version: 2.0.1
Redmine category:data_provider/mssql
Assignee: Nathan Woodrow

---

If a MS SQL Spatial layer uses data type then layer attribute table displays as all nulls and the feature selection selects all features at all time (even if you select a single feature). In my test the was the PK of the attribute table. Incidentally the this SQL Spatial layer originated from ESRI where the datatype GUID (global id) was use to create it.

I have attached a script to help you recreate this problem. It creates a SQL Spatial table and loads it with some data.

---

• test.sql (Ali Diba)

---

Related issue(s): #19299 (relates), #20502 (relates)
Redmine related issue(s): 10946, 12324

---

[qgib]

Author Name: Nathan Woodrow (@NathanW2)

---

It seems QGIS only support int primary keys. I will do some more follow up.

---

• assigned_to_id was configured as Nathan Woodrow

[qgib]

Author Name: Nathan Woodrow (@NathanW2)

---

• status_id was changed from Open to Feedback

[qgib]

Author Name: Ali Diba (Ali Diba)

---

Brighton desktop crashes when you display the attribute table for a SQL Server Spatial layers that has a GUID field. Minidump is attached for your consideration.

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• status_id was changed from Feedback to Open

[qgib]

Author Name: Nathan Woodrow (@NathanW2)

---

Closing in favor of #19299 as it will do the same thing once added.

---

• resolution was changed from to duplicate
• status_id was changed from Open to Closed