PSQL cursor doesn't see inserted record
---------------------------------------
Key: CORE-5773
URL: http://tracker.firebirdsql.org/browse/CORE-5773
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0.3, 3.0.4
Reporter: Dmitriy Starodubov
Following script returns 0, i.e. PSQL cursor doesn't see the record that was
inserted before cursor was opened.
create table test_table (id bigint);
set term ^;
create or alter procedure test_cursor
returns (
rowcount integer
)
as
declare variable id bigint;
declare crsr cursor for (
select id from test_table
);
begin
insert into test_table(id) values(1);
-- suspend;
open crsr;
fetch crsr into :id;
rowcount = row_count;
suspend;
close crsr;
end^
set term ;^
select * from test_cursor;
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
