[FB-Tracker] Created: (CORE-2731) Recursive EXECUTE STATEMENT works wrong

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[FB-Tracker] Created: (CORE-2731) Recursive EXECUTE STATEMENT works wrong

JIRA tracker@firebirdsql.org
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-july
Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[FB-Tracker] Reopened: (CORE-2731) Recursive EXECUTE STATEMENT works wrong

JIRA tracker@firebirdsql.org

     [ 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
Loading...