Bug report #6381

MSSQL tables - Primary Key with multiple columns Problem

Added by Maria G Saavedra over 11 years ago. Updated over 5 years ago.

Category:Data Provider/MSSQL
Affected QGIS version:1.8.0 Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:
Crashes QGIS or corrupts data:No Copied to github as #:15641


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 issues

Duplicated by QGIS Application - Bug report #6387: MSSQL tables - Primary Key with multiple columns Problem Rejected 2012-09-20


#1 Updated by Pirmin Kalberer over 11 years ago

  • Target version changed from Version 1.8.0 to Version 2.0.0

#2 Updated by Nathan Woodrow over 11 years ago

  • Assignee set to Tamas Szekeres

#3 Updated by Nathan Woodrow almost 10 years ago

  • OS version deleted (Windows 7 - 64bits)
  • Target version changed from Version 2.0.0 to Future Release - Nice to have
  • Operating System deleted (Windows)

#4 Updated by Jürgen Fischer almost 8 years ago

  • Assignee deleted (Tamas Szekeres)

#5 Updated by Giovanni Manghi almost 7 years ago

  • Regression? set to No
  • Easy fix? set to No

#6 Updated by Giovanni Manghi about 6 years ago

  • Status changed from Open to Feedback

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!

#7 Updated by Nyall Dawson over 5 years ago

  • Status changed from Feedback to Closed
  • Description updated (diff)

Closing due to lack of feedback

Also available in: Atom PDF