You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Jian Jin (JIRA)" <ji...@apache.org> on 2015/12/07 05:17:11 UTC
[jira] [Updated] (TRAFODION-1661) [MTDCS] ODBC: SQLNumResultCols
returns wrong result set after prepare
[ https://issues.apache.org/jira/browse/TRAFODION-1661?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jian Jin updated TRAFODION-1661:
--------------------------------
Assignee: RuoYu Zuo
> [MTDCS] ODBC: SQLNumResultCols returns wrong result set after prepare
> ---------------------------------------------------------------------
>
> Key: TRAFODION-1661
> URL: https://issues.apache.org/jira/browse/TRAFODION-1661
> Project: Apache Trafodion
> Issue Type: Bug
> Components: client-odbc-linux
> Affects Versions: 2.0-incubating
> Environment: suse11
> Reporter: Gao, Rui-Xian
> Assignee: RuoYu Zuo
>
> When MultiThread DCS is on, SQLNumResultCols returns 0 after prepare but actually there are 29 columns.
> Here is the test step--
> SQLAllocStmt((SQLHANDLE)hdbc, &hstmt);
> SQLExecDirect(hstmt,(SQLTCHAR*)ExecDirStr[0],SQL_NTS); //cleanup
> SQLExecDirect(hstmt,(SQLTCHAR*)ExecDirStr[1],SQL_NTS); // create table
> SQLExecDirect(hstmt,(SQLTCHAR*)ExecDirStr[2],SQL_NTS); //insert into table
> SQLPrepare(hstmt,(SQLTCHAR*)ExecDirStr[3], SQL_NTS); //select from table
> SQLNumResultCols(hstmt, &numcol);
> Here are the sql queries it's actually running --
> 1. create table
> create table DTXMEHOWL8(AY0_B4PLCS CHAR(10) CHARACTER SET ISO88591,OWL8X0SIB_ VARCHAR(10) CHARACTER SET ISO88591,FTAYUNM65D DECIMAL(10,5),TXMEHOWL8X DECIMAL(5,2) UNSIGNED,SIB_BOWACN NUMERIC(10,5),KPLGYIRJ9J NUMERIC(5,2) UNSIGNED,QSUQR27KCZ SMALLINT,FHG1V3DZEV SMALLINT UNSIGNED,P4FTAYUNM6 INTEGER,R6ZVBCUFWV INTEGER UNSIGNED,GFDUWMDNXE REAL,EKOANMRHKH FLOAT,JTJZL513OG DOUBLE PRECISION,QIYXP2QIST DATE,ACNKPLGYIR TIME,J9JQSUQR27 TIMESTAMP,KCZFHG1V3D BIGINT,ZEVP4FTAYU LONG VARCHAR CHARACTER SET ISO88591,NM65DTXMEH NUMERIC(19,0),BOWACNKPLG NUMERIC(19,6),YIRJ9JQSUQ NUMERIC(128,0),R27KCZFHG1 NUMERIC(128,128),V3DZEVP4FT NUMERIC(128,64),AYUNM65DTX NUMERIC(10,5) UNSIGNED,MEHOWL8X0S NUMERIC(18,5) UNSIGNED,IB_BOWACNK NUMERIC(30,10) UNSIGNED,PLGYIRJ9JQ CHAR(10) CHARACTER SET UCS2,SUQR27KCZF VARCHAR(10) CHARACTER SET UCS2,HG1V3DZEVP LONG VARCHAR CHARACTER SET UCS2) NO PARTITION;
> 2. insert data
> insert into DTXMEHOWL8 values('2qIstay0|_','B}4pl:`C$#',-1234.567,987.12,-1234.567,987.12,-934,3520,-12000,56343,123.45E2,123.45E3,123.45E4,{d '1993-07-01'},{t '09:45:30'},{ts '1993-08-02 08:44:31.001'},456789,' AC\n:Kplg',1234567890123456789,1234567890123.456789,1234567890123456789012345678901234567890,0.123456789012345678901234567890123456789,1234567890.123456789012345678901234567890123456789,12345.56789,1234567890123.56789,12345678901234567890.0123456789,'YI$rj/9JQ?','suq`;R>27k','^cZf|]HG1"');
> 3. prepare --
> select AY0_B4PLCS,OWL8X0SIB_,FTAYUNM65D,TXMEHOWL8X,SIB_BOWACN,KPLGYIRJ9J,QSUQR27KCZ,FHG1V3DZEV,P4FTAYUNM6,R6ZVBCUFWV,GFDUWMDNXE,EKOANMRHKH,JTJZL513OG,QIYXP2QIST,ACNKPLGYIR,J9JQSUQR27,KCZFHG1V3D,ZEVP4FTAYU,NM65DTXMEH,BOWACNKPLG,YIRJ9JQSUQ,R27KCZFHG1,V3DZEVP4FT,AYUNM65DTX,MEHOWL8X0S,IB_BOWACNK,PLGYIRJ9JQ,SUQR27KCZF,HG1V3DZEVP from DTXMEHOWL8;
> 4. SQLNumResultCols(hstmt, &numcol);
> returns 0
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)