[TRAFODION-1684] ODBC: trafodion doesn't support API SQLStatistics

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.0 (pre-incubation), 2.0-incubating
• Fix Version/s: 2.1-incubating
• Component/s: connectivity-dcs
• Environment: client os: window7,windows8,linux(centos6.7, suse11)
• Assignee: Weiqing Xu
• Reporter: Gao, Rui-Xian
• Created: 08/Dec/15 03:02
• Updated: 15/Sep/18 07:31
• Resolved: 20/Jun/16 05:35

Description

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

Issue Links

• links to: GitHub Pull Request #513