[
http://tracker.firebirdsql.org/browse/CORE-2731?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pavel Zotov reopened CORE-2731:
-------------------------------
Fix Version/s: 4.0 Alpha 1
3.0.3
2.5.8
All of following: 2.5.8, 3.0.3, 4.0.0 - do NOT finish test script when working
in Classic mode.
> 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 Alpha 1, 2.5 Beta 1, 2.5 Beta 2
> Reporter: Vlad Khorsun
> Assignee: Vlad Khorsun
> Fix For: 4.0 Alpha 1, 3.0.3, 2.5.8, 2.5 RC1, 3.0 Alpha 1
>
>
> 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
------------------------------------------------------------------------------
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
