Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
3.2.2
-
None
-
Windows 32 bit
Description
I have defined PRIMARY KEY on table, which consists of 4 columns.
When I call ODBC API SQLPrimaryKeys these 4 columns are returned in order how they appear in table definition, not in primary key definition.
SQLPrimaryKeys returns 4 rows, where 5th column - KEY_SEQ - return:
2,
5,
6,
9
But https://learn.microsoft.com/en-us/sql/odbc/reference/syntax/sqlprimarykeys-function states, that:
KEY_SEQ: "Column sequence number in key (starting with 1)"
So KEY_SEQ should be sequence in key not in table ...