[ https://issues.apache.org/jira/browse/TRAFODION-1698?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15571726#comment-15571726 ]
ASF GitHub Bot commented on TRAFODION-1698: ------------------------------------------- GitHub user xwq opened a pull request: https://github.com/apache/incubator-trafodion/pull/762 [TRAFODION-1698]ODBC: trafodon doesn't support SQLForeginKeys Fix the error of the old implementation and add test cases for it. You can merge this pull request into a Git repository by running: $ git pull https://github.com/xwq/incubator-trafodion sqlforeginkey Alternatively you can review and apply these changes as the patch at: https://github.com/apache/incubator-trafodion/pull/762.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 #762 ---- commit 533b3834fd5b65028cdc812bf273eabe7de8ec35 Author: Weiqing Xu <weiqing...@esgyn.cn> Date: 2016-09-28T00:53:41Z [TRAFODION-1698]ODBC: trafodon doesn't support SQLForeginKeys Fix the error of the old implementation and add test cases for it. ---- > 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)