Running "execute procedure sp_test(ce.x) returning_values(ce.y)", where 'ce'
is CURSOR, leads to crash.
--------------------------------------------------------------------------------------------------------
Key: CORE-4819
URL: http://tracker.firebirdsql.org/browse/CORE-4819
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0 Beta 2
Reporter: Pavel Zotov
Original discussion (in russian) can be found here:
http://www.sql.ru/forum/actualutils.aspx?action=gotomsg&tid=1158905&msg=17704102
Test:
====
create or alter procedure sp_test(a_x int) as begin end;
recreate table test(id int primary key, x int, y int);
insert into test values(1, 10, 11);
commit;
set term ^;
create or alter procedure sp_test(a_x int) returns(o_y int) as
begin
o_y = 2 * a_x;
suspend;
end
^
commit
^
execute block returns(old_y int, new_y int) as
begin
for
select x, y from test
as cursor ce
do begin
old_y = ce.y;
execute procedure sp_test(ce.x) returning_values(ce.y);
new_y = ce.y;
suspend;
end
end
^
rollback
^
Result in WI-T3.0.0.31845: message "internal Firebird consistency check
(EVL_assign_to: invalid operation (229), file: evl.cpp line: 205)" appeares in
firebird.log
--
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
------------------------------------------------------------------------------
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
