MSSQL tables - Primary Key with multiple columns Problem

[qgib]

Author Name: Maria G Saavedra (Maria G Saavedra)
Original Redmine Issue: 6381
Affected QGIS version: 1.8.0
Redmine category:data_provider/mssql

---

Adding a table with multiple columns as primary key, QGIS is not recognizing both primary key columns, only the first one, and when we edit a information/geometry or search in the attributes table, the data that is shown is incorrect, even we had updated information by mistake because of this.

MSSQL Server Standard Edition 2008 R2
QGIS 1.8.0-Lisboa
Windows 7 64 bits

---

Related issue(s): #15645 (duplicates)
Redmine related issue(s): 6387

---

[qgib]

Author Name: Pirmin Kalberer (Pirmin Kalberer)

---

• fixed_version_id was changed from Version 1.8.0 to Version 2.0.0

[qgib]

Author Name: Nathan Woodrow (@NathanW2)

---

• assigned_to_id was configured as Tamas Szekeres

[qgib]

Author Name: Nathan Woodrow (@NathanW2)

---

• os_version was changed from Windows 7 - 64bits to
• fixed_version_id was changed from Version 2.0.0 to Future Release - Nice to have
• operating_system was changed from Windows to

[qgib]

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

---

• assigned_to_id removed Tamas Szekeres

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

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

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

Please test with a recent QGIS release (2.18 or 3), if the issue/request is still valid change the affected version accordingly, if is fixed/implemented then close the ticket. Thanks!

---

• status_id was changed from Open to Feedback

[qgib]

Author Name: Nyall Dawson (@nyalldawson)

---

Closing due to lack of feedback

---

• status_id was changed from Feedback to Closed
• description was changed from Adding a table with multiple columns as primary key, QGIS is not recognizing both primary key columns, only the first one, and when we edit a information/geometry or search in the attributes table, the data that is shown is incorrect, even we had updated information by mistake because of this.

MSSQL Server Standard Edition 2008 R2
QGIS 1.8.0-Lisboa
Windows 7 64 bits
to Adding a table with multiple columns as primary key, QGIS is not recognizing both primary key columns, only the first one, and when we edit a information/geometry or search in the attributes table, the data that is shown is incorrect, even we had updated information by mistake because of this.

MSSQL Server Standard Edition 2008 R2
QGIS 1.8.0-Lisboa
Windows 7 64 bits