Issue Details (XML | Word | Printable)

Key: CORE-3092
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: Andry Gordeev
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

ROW_COUNT is not cleared before the singleton INSERT statement

Created: 31/Jul/10 08:31 PM   Updated: 16/May/12 01:48 PM
Component/s: None
Affects Version/s: 2.1.0, 2.1.1, 2.1.2, 2.1.3, 3.0 Initial, 2.5.0, 2.1.4, 2.5.1
Fix Version/s: 2.1.5, 2.5.2, 3.0 Alpha 1

Time Tracking:
Not Specified

Environment:
windows XPSP3 Firebird 2.1.0
debian Firebird 2.1.3
Issue Links:
Relate
 

Planning Status: Unspecified


 Description  « Hide
CREATE TABLE DELME (
    A INTEGER,
    B INTEGER
);

INSERT INTO DELME (A, B)
           VALUES (1, 11);
INSERT INTO DELME (A, B)
           VALUES (2, 22);
INSERT INTO DELME (A, B)
           VALUES (3, 33);

create procedure uui
returns (
    result varchar(250))
as
begin
  result = 'Version: '||RDB$GET_CONTEXT('SYSTEM','ENGINE_VERSION')||'; ';

  update delme set
    b = 111
    where a = 1;
  result = result||'update-1 '||row_count||'; ';

  update delme set
    b = 222
    where a = 2;
  result = result||'update-2 '||row_count||'; ';

  insert into delme(a,b)
    values(4,44);
  result = result||'insert-1 '||row_count||'; ';
end

execute procedure uui;
 -- RESULT = Version: 2.1.0; update-1 1; update-2 1; insert-1 2;

 Перед выполнением insert запроса переменная row_count не обнуляется

 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.