You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Gao, Rui-Xian (JIRA)" <ji...@apache.org> on 2015/12/08 04:03:11 UTC

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

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

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



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)