[jira] [Created] (TRAFODION-1698) ODBC: trafodion doesn't support API SQLForeignKeys

["Gao, Rui-Xian (JIRA)" <ji...@apache.org>]

Gao, Rui-Xian created TRAFODION-1698:
----------------------------------------

             Summary: 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



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)