[ https://issues.apache.org/jira/browse/TRAFODION-735?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Pierre Smits updated TRAFODION-735: ----------------------------------- Fix Version/s: (was: 2.1-incubating) 2.2.0 > LP Bug: 1388930 - ODBC SQLRowCount function returns wrong row number > -------------------------------------------------------------------- > > Key: TRAFODION-735 > URL: https://issues.apache.org/jira/browse/TRAFODION-735 > Project: Apache Trafodion > Issue Type: Bug > Components: client-odbc-linux > Reporter: JiepingZhang > Assignee: Daniel Lu > Priority: Critical > Fix For: 2.2.0 > > > In the rowset update test, 10 rows were inserted to the table, hence 10 rows > were expected to be updated, but SQLRowCount returned 55 rows instead. > > Binding parameters. > >> Freeing the statement bind parameter buffers. > > Updating rows. > >> ERROR: The number of expected good rows processed [10] does not match the > SQLRowCount() [55] at line 3457. > tableType[100]: REGULAR > tableFeature[1]: STANDARD > mode[1]: STANDARD > feature[1]: STANDARD > operation[20]: PREPARE_EXECUTE > action[32]: UPDATE > bindOrientation[40]: ROW > injectionType[60]: NO_ERRORS > numberOfRows: 10 > rowsetSize: 10 > commitRate: 1000 > [1] 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 1234567890123456789 > 1234567890123456789 > [2] 2 2 2 2 2 2 2 2 1 2 1 1 1 1 1 1 2 2 2 2 2 2 1234567890123456789 > 1234567890123456789 > [3] 3 3 3 3 3 3 3 3 1 3 1 1 1 1 1 1 3 3 3 3 3 2 1234567890123456789 > 1234567890123456789 > [4] 4 4 4 4 4 4 4 4 1 4 1 1 1 1 1 1 4 4 4 4 4 2 1234567890123456789 > 1234567890123456789 > [5] 5 5 5 5 5 5 5 5 1 5 1 1 1 1 1 1 5 5 5 5 5 2 1234567890123456789 > 1234567890123456789 > [6] 6 6 6 6 6 6 6 6 1 6 1 1 1 1 1 1 6 6 6 6 6 2 1234567890123456789 > 1234567890123456789 > [7] 7 7 7 7 7 7 7 7 1 7 1 1 1 1 1 1 7 7 7 7 7 2 1234567890123456789 > 1234567890123456789 > [8] 8 8 8 8 8 8 8 8 1 8 1 1 1 1 1 1 8 8 8 8 8 2 1234567890123456789 > 1234567890123456789 > [9] 9 9 9 9 9 9 9 9 1 9 1 1 1 1 1 1 9 9 9 9 9 2 1234567890123456789 > 1234567890123456789 > [10] 10 10 10 10 10 10 10 10 1 10 1 1 1 1 1 1 10 10 10 10 10 2 > 1234567890123456789 1234567890123456789 > ....FAILED!.... > > Free handles. > >>showddl rowset_table; > CREATE TABLE TRAFODION.ODBCTEST.ROWSET_TABLE > ( > C01 CHAR(20) CHARACTER SET ISO88591 COLLATE > DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE > , C02 CHAR(20) CHARACTER SET UCS2 COLLATE > DEFAULT DEFAULT NULL > , C03 VARCHAR(20) CHARACTER SET ISO88591 > COLLATE > DEFAULT DEFAULT NULL > , C04 VARCHAR(20) CHARACTER SET UCS2 COLLATE > DEFAULT DEFAULT NULL > , C05 VARCHAR(20) CHARACTER SET ISO88591 > COLLATE > DEFAULT DEFAULT NULL > , C06 VARCHAR(20) CHARACTER SET UCS2 COLLATE > DEFAULT DEFAULT NULL > , C07 CHAR(20) CHARACTER SET UCS2 COLLATE > DEFAULT DEFAULT NULL > , C08 VARCHAR(20) CHARACTER SET UCS2 COLLATE > DEFAULT DEFAULT NULL > , C09 DECIMAL(8, 0) DEFAULT NULL > , C10 DECIMAL(8, 0) UNSIGNED DEFAULT NULL > , C11 NUMERIC(8, 0) DEFAULT NULL > , C12 NUMERIC(8, 0) UNSIGNED DEFAULT NULL > , C13 SMALLINT DEFAULT NULL > , C14 SMALLINT UNSIGNED DEFAULT NULL > , C15 SMALLINT DEFAULT NULL > , C16 SMALLINT UNSIGNED DEFAULT NULL > , C17 INT NO DEFAULT NOT NULL NOT DROPPABLE > , C18 INT UNSIGNED DEFAULT NULL > , C19 LARGEINT NO DEFAULT NOT NULL NOT > DROPPABLE > , C20 REAL DEFAULT NULL > , C21 DOUBLE PRECISION DEFAULT NULL > , C22 DOUBLE PRECISION DEFAULT NULL > , C23 DATE DEFAULT NULL > , C24 TIME(0) DEFAULT NULL > , C25 TIMESTAMP(6) DEFAULT NULL > , C26 INTERVAL YEAR(2) DEFAULT NULL > , C27 INTERVAL MONTH(2) DEFAULT NULL > , C28 INTERVAL DAY(2) DEFAULT NULL > , C29 INTERVAL HOUR(2) DEFAULT NULL > , C30 INTERVAL MINUTE(2) DEFAULT NULL > , C31 INTERVAL SECOND(2,6) DEFAULT NULL > , C32 INTERVAL YEAR(2) TO MONTH DEFAULT NULL > , C33 INTERVAL DAY(2) TO HOUR DEFAULT NULL > , C34 INTERVAL DAY(2) TO MINUTE DEFAULT NULL > , C35 INTERVAL DAY(2) TO SECOND(6) DEFAULT NULL > , C36 INTERVAL HOUR(2) TO MINUTE DEFAULT NULL > , C37 INTERVAL HOUR(2) TO SECOND(6) DEFAULT > NULL > , C38 INTERVAL MINUTE(2) TO SECOND(6) DEFAULT > NULL > , C39 NUMERIC(19, 0) DEFAULT NULL > , C40 NUMERIC(19, 0) UNSIGNED DEFAULT NULL > , PRIMARY KEY (C19 ASC) > ) > ; > ALTER TABLE TRAFODION.ODBCTEST.ROWSET_TABLE ADD CONSTRAINT > TRAFODION.ODBCTEST.C17C CHECK (TRAFODION.ODBCTEST.ROWSET_TABLE.C17 < 50000) > --- SQL operation complete. > >>select count(*) from rowset_table; > (EXPR) > -------------------- > 10 > --- 1 row(s) selected. > >> -- This message was sent by Atlassian JIRA (v7.6.3#76005)