Uploaded image for project: 'MariaDB Connector/ODBC'
  1. MariaDB Connector/ODBC
  2. ODBC-435

SQLPrimaryKeys call returns incorrect KEY_SEQ field

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 3.2.2
    • 3.2.3
    • General
    • 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 ...

      Attachments

        Activity

          People

            Lawrin Lawrin Novitsky
            LacaK Ladislav
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.