Issue Details (XML | Word | Printable)

Key: CORE-2731
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Vlad Khorsun
Reporter: Vlad Khorsun
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Recursive EXECUTE STATEMENT works wrong

Created: 05/Nov/09 03:13 AM   Updated: 05/Nov/09 10:53 AM
Return to search
Component/s: Engine
Affects Version/s: 2.5 Alpha 1, 2.5 Beta 1, 2.5 Beta 2
Fix Version/s: 2.5 RC1, 3.0 Alpha 1

Time Tracking:
Not Specified

Planning Status: Unspecified


 Description  « Hide
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.

 All   Comments   Work Log   Change History   Version Control      Sort Order: Ascending order - Click to sort in descending order
Vlad Khorsun made changes - 05/Nov/09 03:13 AM
Field Original Value New Value
Assignee Vlad Khorsun [ hvlad ]
Vlad Khorsun made changes - 05/Nov/09 04:15 AM
Fix Version/s 2.5 RC2 [ 10372 ]
Status Open [ 1 ] Resolved [ 5 ]
Fix Version/s 3.0 Alpha 1 [ 10331 ]
Resolution Fixed [ 1 ]
Dmitry Yemanov made changes - 05/Nov/09 10:53 AM
Fix Version/s 2.5 RC1 [ 10362 ]
Fix Version/s 2.5 RC2 [ 10372 ]