[
https://issues.apache.org/jira/browse/TRAFODION-1686?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Gao, Rui-Xian updated TRAFODION-1686:
-------------------------------------
Environment:
platform: suse11
connect info : 10.10.10.176:23400
build : 20151121_0900-bin
driver version: 1119
was:
platform: suse11
connect info : 10.10.10.176:23400
esgynDB version :esgynDB-20151121_0900-bin
driver version: 1119
> [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
> build : 20151121_0900-bin
> driver version: 1119
> Reporter: Gao, Rui-Xian
> Assignee: Weiqing Xu
> Priority: Major
>
> 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
(v7.6.3#76005)
