[ 
https://issues.apache.org/jira/browse/TRAFODION-1698?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15586617#comment-15586617
 ] 

ASF GitHub Bot commented on TRAFODION-1698:
-------------------------------------------

Github user asfgit closed the pull request at:

    https://github.com/apache/incubator-trafodion/pull/762


> ODBC: trafodion doesn't support API SQLForeignKeys
> --------------------------------------------------
>
>                 Key: TRAFODION-1698
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-1698
>             Project: Apache Trafodion
>          Issue Type: Improvement
>          Components: connectivity-dcs
>    Affects Versions: 1.0 (pre-incubation), 2.0-incubating
>         Environment: client platform: windows7, windows8, centos6.7, suse11
>            Reporter: Gao, Rui-Xian
>            Assignee: Weiqing Xu
>
> API SQLForeignKeys returned error that the API  type is not supported.
> To reproduce --
> create table TDV5WYPAQVA (V5WYPAQVJJ  char(10) CHARACTER SET ucs2 not null 
> not droppable, PDO_6ERNAZ  char(10) CHARACTER SET ucs2, primary 
> key(V5WYPAQVJJ)) NO PARTITION
> create table TDV5WYPAQVB (LRO90EZUSH  char(10) CHARACTER SET ucs2 not null 
> not droppable, IKLI4HXBSC  char(10) CHARACTER SET ucs2, primary 
> key(LRO90EZUSH), foreign key (IKLI4HXBSC) references TDV5WYPAQVA(V5WYPAQVJJ)) 
> NO PARTITION
> create table TDV5WYPAQVC (BG1TCQFK2X  char(10) CHARACTER SET ucs2 not null 
> not droppable, W8UMGMNY7F  char(10) CHARACTER SET ucs2, primary 
> key(BG1TCQFK2X), foreign key (W8UMGMNY7F) references TDV5WYPAQVB(LRO90EZUSH)) 
> NO PARTITION
> ==========================
> SQLForeignKeys(hstmt, TRAFODION, 9, RACHEL_ODBCTEST_L, 17, TDV5WYPAQVA, 11, 
> TRAFODION, 9, RACHEL_ODBCTEST_L, 17, <empty>, 0)
> 10:46:03  ***ERROR: SQLForeignKeys: Expected: SQL_SUCCESS Actual: SQL_ERROR
>    File: ../../../../src/coast/coast_unified/src/forkeys.c   Line: 302
>    State: HYC00
>    Native Error: 1
>    Error: [Trafodion ODBC Driver][DCS Server] OPTIONAL FEATURE NOT 
> IMPLEMENTED.UNSUPPORTED INPUT SMD API TYPE



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to