
|
If you were logged in you would be able to see more operations.
|
|
|
|
Environment:
|
windows XPSP3 Firebird 2.1.0
debian Firebird 2.1.3
windows XPSP3 Firebird 2.1.0
debian Firebird 2.1.3
|
|
Issue Links:
|
|
|
| Planning Status: |
Unspecified
|
|
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 не обнуляется
|
|
Description
|
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 не обнуляется |
Show » |
| There are no comments yet on this issue.
|
|