[
https://issues.apache.org/jira/browse/TRAFODION-2911?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16326931#comment-16326931
]
ASF GitHub Bot commented on TRAFODION-2911:
-------------------------------------------
GitHub user Weixin-Xu opened a pull request:
https://github.com/apache/trafodion/pull/1401
[TRAFODION-2911] Catalog Api gives wrong values about NON_UNIQUE column
Table TRAFODION.\"_MD_\".INDEXES only has column "is_unique", but the
output column is NON_UNIQUE.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/Weixin-Xu/incubator-trafodion T2911
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/trafodion/pull/1401.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #1401
----
----
> 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
> Priority: Major
> 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)
