You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2016/06/01 07:02:12 UTC
[jira] [Commented] (TRAFODION-1684) ODBC: trafodion doesn't support
API SQLStatistics
[ https://issues.apache.org/jira/browse/TRAFODION-1684?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15309432#comment-15309432 ]
ASF GitHub Bot commented on TRAFODION-1684:
-------------------------------------------
GitHub user xwq opened a pull request:
https://github.com/apache/incubator-trafodion/pull/513
[TRAFODION-1684]ODBC:preliminary support SQLStatistics
[TRAFODION-1684]ODBC: trafodion doesn't support API SQLStatistics.
It's preliminary implementation for ODBC API SQLStatistics. Now, it
will ignore the parameter "Unique".
SQLStatistics returns information as a standard result set.
TABLE_CAT # support
TABLE_SCHEM # support
TABLE_NAME # support
NON_UNIQUE # support
INDEX_QUALIFIER # not support
INDEX_NAME # not support
TYPE # not support
ORDINAL_POSITION # support
ASC_OR_DESC # not support
CARDINALITY # support
PAGES # not support
FILTER_CONDITION # not support
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/xwq/incubator-trafodion master
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/513.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 #513
----
commit e1a612ee2ad2d9ae9c45386c44180a4a74f63d7f
Author: Weiqing Xu <we...@esgyn.cn>
Date: 2016-06-01T06:42:03Z
[TRAFODION-1684]ODBC:preliminary support SQLStatistics
[TRAFODION-1684]ODBC: trafodion doesn't support API SQLStatistics.
It's preliminary implementation for ODBC API SQLStatistics. Now, it
will ignore the parameter "Unique".
SQLStatistics returns information as a standard result set.
TABLE_CAT # support
TABLE_SCHEM # support
TABLE_NAME # support
NON_UNIQUE # support
INDEX_QUALIFIER # not support
INDEX_NAME # not support
TYPE # not support
ORDINAL_POSITION # support
ASC_OR_DESC # not support
CARDINALITY # support
PAGES # not support
FILTER_CONDITION # not support
----
> ODBC: trafodion doesn't support API SQLStatistics
> -------------------------------------------------
>
> Key: TRAFODION-1684
> URL: https://issues.apache.org/jira/browse/TRAFODION-1684
> Project: Apache Trafodion
> Issue Type: Improvement
> Components: connectivity-dcs
> Affects Versions: 1.0 (pre-incubation), 2.0-incubating
> Environment: client os: window7,windows8,linux(centos6.7, suse11)
> Reporter: Gao, Rui-Xian
> Assignee: RuoYu Zuo
>
> Test code--
> FullConnect
> SQLAllocStmt((SQLHANDLE)hdbc, &hstmt);
> SQLExecDirect(hstmt,(SQLTCHAR*)CreateTbl[t],SQL_NTS);
> SQLExecDirect(hstmt,(SQLTCHAR*)CreateIdx,SQL_NTS);
> SQLStatistics(hstmt,(SQLTCHAR*)TQualifier,(SWORD)_tcslen(TQualifier),(SQLTCHAR*)TOwner,(SWORD)_tcslen(TOwner),(SQLTCHAR*)TName,(SWORD)_tcslen(TName),Unique[idx],Accuracy[a]);
> The sql statement sqlexecdirect is running --
> create table WZDPCMJFIV (V6COTKFLZS char(10) CHARACTER SET ISO88591 NOT NULL,primary key(V6COTKFLZS));
> create unique index KBROLZG1HL on WZDPCMJFIV (V6COTKFLZS ASC);
> Then sqlstatistics will return error that the api type is unsupported --
> 09:43:34 ***ERROR: SQLStatistics: Expected: SQL_SUCCESS Actual: SQL_ERROR
> File: ../../../../src/coast/coast_unified/src/stat.c Line: 351
> 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)