[TRAFODION-2911] Catalog Api gives wrong values about NON_UNIQUE column

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: any
• Fix Version/s: 2.2.0
• Component/s: connectivity-mxosrvr
• Environment: Centos 6.7
• Assignee: XuWeixin
• Reporter: XuWeixin
• Due: 16/Jan/18
• Created: 16/Jan/18 09:28
• Updated: 15/Sep/18 07:30
• Resolved: 24/Jan/18 08:28

Description

CREATE TABLE TABLE1(C1 INT, C2 VARCHAR(20))

CREATE INDEX IDX1 ON TABLE1(C1 ASC)

CREATE UNIQUE INDEX IDX2 ON TABLE1(C1 ASC)

SQLStatistics(hstmt, "", SQL_NTS, "", SQL_NTS, "TABLE1", SQL_NTS, SQL_INDEX_ALL, SQL_QUICK)

SQLGetData(hstmt, 4, SQL_C_CHAR, uniqueValue, size, NULL)

output: IDX1 : 0, expected : 1

            IDX2 : 1, expected : 0

Issue Links

• links to: GitHub Pull Request #1401