We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Submitted by: Andry Gordeev (andryg)
Relate to QA462
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 не обнуляется
Commits: 0ea7ae1 12b1853 3dd942c
The text was updated successfully, but these errors were encountered:
assignee: Dmitry Yemanov [ dimitr ]
Sorry, something went wrong.
Version: 2.5.1 [ 10333 ]
Version: 2.1.4 [ 10361 ]
Version: 2.5.0 [ 10221 ]
Version: 3.0 Initial [ 10301 ]
Version: 2.1.2 [ 10270 ]
Version: 2.1.1 [ 10223 ]
status: Open [ 1 ] => Resolved [ 5 ]
resolution: Fixed [ 1 ]
Fix Version: 2.1.5 [ 10420 ]
Fix Version: 2.5.2 [ 10450 ]
Fix Version: 3.0 Alpha 1 [ 10331 ]
summary: row_count do not clear before "insert" => ROW_COUNT is not cleared before the singleton INSERT statement
Link: This issue relate to QA462 [ QA462 ]
status: Resolved [ 5 ] => Closed [ 6 ]
status: Closed [ 6 ] => Closed [ 6 ]
QA Status: Done successfully
dyemanov
No branches or pull requests
Submitted by: Andry Gordeev (andryg)
Relate to QA462
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 не обнуляется
Commits: 0ea7ae1 12b1853 3dd942c
The text was updated successfully, but these errors were encountered: