You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Anuradha Hegde (JIRA)" <ji...@apache.org> on 2016/05/12 20:12:12 UTC
[jira] [Updated] (TRAFODION-735) LP Bug: 1388930 - ODBC SQLRowCount
function returns wrong row number
[ https://issues.apache.org/jira/browse/TRAFODION-735?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Anuradha Hegde updated TRAFODION-735:
-------------------------------------
Fix Version/s: (was: 2.0-incubating)
2.1-incubating
> 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.1-incubating
>
>
> 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
(v6.3.4#6332)