Recursive EXECUTE STATEMENT works wrong
---------------------------------------
Key: CORE-2731
URL:
http://tracker.firebirdsql.org/browse/CORE-2731 Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 2.5 Beta 2, 2.5 Beta 1, 2.5 Alpha 1
Reporter: Vlad Khorsun
Test case
recreate table SQL_SOURCE(
SQL_SOURCE varchar(32000)
);
commit;
insert into SQL_SOURCE values(
'execute block as
declare variable SQL type of column SQL_SOURCE.SQL_SOURCE;
begin
select first(1) SQL_SOURCE from SQL_SOURCE into :SQL;
execute statement :SQL
-- YOUR DB
on external ''127.0.0.1:S:\X.fdb''
as user ''SYSDBA'' password ''masterkey'';
end'
);
commit;
execute block as
declare variable SQL type of column SQL_SOURCE.SQL_SOURCE;
begin
select first(1) SQL_SOURCE from SQL_SOURCE into :SQL;
execute statement :SQL;
end
SS and SC hungs, CS creates a lot of processes.
Yes, test case looks crazy, but recursion must be limited somehow.
--
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
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.
http://p.sf.net/sfu/bobj-julyFirebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
