[jira] [Created] (TRAFODION-1661) [MTDCS] ODBC: SQLNumResultCols returns wrong result set after prepare

["Gao, Rui-Xian (JIRA)" <ji...@apache.org>]

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

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


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)