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 13:20:10 UTC
[jira] [Created] (TRAFODION-1686) [MTDCS] ODBC: SQLParamdata ran
into error for date type columns
Gao, Rui-Xian created TRAFODION-1686:
----------------------------------------
Summary: [MTDCS] ODBC: SQLParamdata ran into error for date type columns
Key: TRAFODION-1686
URL: https://issues.apache.org/jira/browse/TRAFODION-1686
Project: Apache Trafodion
Issue Type: Bug
Components: connectivity-dcs
Affects Versions: 2.0-incubating
Environment: platform: suse11
connect info : 10.10.10.176:23400
esgynDB version :esgynDB-20151121_0900-bin
driver version: 1119
Reporter: Gao, Rui-Xian
When MTDCS is on, sqlparamdata will get error for date type columns.
Reproducible code --
SQLAllocStmt(hdbc, &hstmt);
SQLExecDirect(hstmt,(SQLTCHAR*)InsStr,SQL_NTS);
SQLPrepare(hstmt,(SQLTCHAR*)InsTab1,SQL_NTS);
SQLBindParameter(hstmt,(SWORD)(j+1),ParamType,CDataValueTOSQL1[i].CType,
CDataArgToSQL1.SQLType[j],CDataValueTOSQL1[i].ColPrec[j],
CDataValueTOSQL1[i].ColScale[j],NULL,NAME_LEN,
&InValue);
SQLExecute(hstmt);
SQLParamData(hstmt,&pToken);
***ERROR: SQLParamData failed
State: 22003
Native Error: 0
Error: [Trafodion ODBC Driver] NUMERIC VALUE OUT OF RANGE. Row: 1 Column: 10
The actual statement the above apis are running --
1. create table
CREATE TABLE OSD28DL_Z1(SK_PE9ETUK CHAR(10) CHARACTER SET ISO88591,JQJAAFUO4B VARCHAR(10) CHARACTER SET ISO88591,O4BQVTFXOS DECIMAL(10,5),D28DL_Z1HP NUMERIC(10,5),EK7XIK0RPU SMALLINT,LR5GT3YMEY INTEGER,CWBGHNZMVN REAL,SWI9CJQJAA FLOAT,FUO4BQVTFX DOUBLE PRECISION,QJZVF2ABMN DATE,QIGXW1HCDO TIME,VOWHPAC75R TIMESTAMP,L6DYIXRZJ3 LONG VARCHAR CHARACTER SET ISO88591,L0MSNYUGTF BIGINT,B8SK_PE9ET CHAR(10) CHARACTER SET UCS2,UKQJZVF2AB VARCHAR(10) CHARACTER SET UCS2,MN4QIGXW1H LONG VARCHAR CHARACTER SET UCS2,CDOVOWHPAC NUMERIC(19,0),RL6DYIXRZJ NUMERIC(19,6),QVTFXOSD28 NUMERIC(128,0),DL_Z1HPEK7 NUMERIC(128,128),XIK0RPULR5 NUMERIC(128,64),GT3YMEYCWB NUMERIC(10,5) UNSIGNED,GHNZMVN6SW NUMERIC(18,5) UNSIGNED,I9CJQJAAFU NUMERIC(30,10) UNSIGNED) NO PARTITION
2. prepare
INSERT INTO OSD28DL_Z1 (SK_PE9ETUK,JQJAAFUO4B,O4BQVTFXOS,D28DL_Z1HP,EK7XIK0RPU,LR5GT3YMEY,CWBGHNZMVN,SWI9CJQJAA,FUO4BQVTFX,QJZVF2ABMN,QIGXW1HCDO,VOWHPAC75R,L6DYIXRZJ3,L0MSNYUGTF,B8SK_PE9ET,UKQJZVF2AB,MN4QIGXW1H,CDOVOWHPAC,RL6DYIXRZJ,QVTFXOSD28,DL_Z1HPEK7,XIK0RPULR5,GT3YMEYCWB,GHNZMVN6SW,I9CJQJAAFU) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
3. bindparameter
SQLBindParameter, Column #1, SQL_C_TCHAR to SQL_CHAR.
SQLBindParameter, Column #2, SQL_C_TCHAR to SQL_VARCHAR.
SQLBindParameter, Column #3, SQL_C_TCHAR to SQL_DECIMAL.
SQLBindParameter, Column #4, SQL_C_TCHAR to SQL_NUMERIC.
SQLBindParameter, Column #5, SQL_C_TCHAR to SQL_SMALLINT.
SQLBindParameter, Column #6, SQL_C_TCHAR to SQL_INTEGER.
SQLBindParameter, Column #7, SQL_C_TCHAR to SQL_REAL.
SQLBindParameter, Column #8, SQL_C_TCHAR to SQL_FLOAT.
SQLBindParameter, Column #9, SQL_C_TCHAR to SQL_DOUBLE.
SQLBindParameter, Column #10, SQL_C_TCHAR to SQL_DATE.
SQLBindParameter, Column #11, SQL_C_TCHAR to SQL_TIME.
SQLBindParameter, Column #12, SQL_C_TCHAR to SQL_TIMESTAMP.
SQLBindParameter, Column #13, SQL_C_TCHAR to SQL_LONGVARCHAR.
SQLBindParameter, Column #14, SQL_C_TCHAR to SQL_BIGINT.
SQLBindParameter, Column #15, SQL_C_TCHAR to SQL_WCHAR.
SQLBindParameter, Column #16, SQL_C_TCHAR to SQL_WVARCHAR.
SQLBindParameter, Column #17, SQL_C_TCHAR to SQL_WLONGVARCHAR.
SQLBindParameter, Column #18, SQL_C_TCHAR to SQL_NUMERIC.
SQLBindParameter, Column #19, SQL_C_TCHAR to SQL_NUMERIC.
SQLBindParameter, Column #20, SQL_C_TCHAR to SQL_NUMERIC.
SQLBindParameter, Column #21, SQL_C_TCHAR to SQL_NUMERIC.
SQLBindParameter, Column #22, SQL_C_TCHAR to SQL_NUMERIC.
SQLBindParameter, Column #23, SQL_C_TCHAR to SQL_NUMERIC.
SQLBindParameter, Column #24, SQL_C_TCHAR to SQL_NUMERIC.
SQLBindParameter, Column #25, SQL_C_TCHAR to SQL_NUMERIC.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)