[jira] [Created] (TRAFODION-2911) Catalog Api gives wrong values about NON_UNIQUE column

[XuWeixin (JIRA)]

XuWeixin created TRAFODION-2911:
-----------------------------------

             Summary: Catalog Api gives wrong values about NON_UNIQUE column
                 Key: TRAFODION-2911
                 URL: https://issues.apache.org/jira/browse/TRAFODION-2911
             Project: Apache Trafodion
          Issue Type: Bug
          Components: connectivity-mxosrvr
    Affects Versions: any
         Environment: Centos 6.7
            Reporter: XuWeixin
            Assignee: XuWeixin
             Fix For: 2.2-incubating


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



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)