You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Jian Jin (JIRA)" <ji...@apache.org> on 2016/06/20 06:00:13 UTC
[jira] [Updated] (TRAFODION-1698) ODBC: trafodion doesn't support
API SQLForeignKeys
[ https://issues.apache.org/jira/browse/TRAFODION-1698?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jian Jin updated TRAFODION-1698:
--------------------------------
Assignee: Weiqing Xu (was: Jian Jin)
> 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)