Re: [Firebird-test] [FB-Tracker] Resolved: (CORE-3306) Invariant sub-query is treated as variant thus causing multiple invokations of a nested stored procedure

[Jean-Baptiste S. \(C. IT S. SA\) <jb....@cs...>]

Thank you for the super fast answer !

What is the time schedule for release V2.5.1?

Cordiales salutations

Jean-Baptiste Simmen

CSE IT Solutions SA, Alte Lyssstrasse 2, 3270 Aarberg
téléphone: 032/387 19 20, téléfax: 032/387 19 98
jb....@cs..., www.cse.ch


-----Ursprüngliche Nachricht-----
Von: Adriano dos Santos Fernandes (JIRA) [mailto:tr...@fi...]
Gesendet: Mittwoch, 12. Januar 2011 01:18
An: jb....@cs...
Betreff: [FB-Tracker] Resolved: (CORE-3306) Invariant sub-query is treated 
as variant thus causing multiple invokations of a nested stored procedure


     [ 
http://tracker.firebirdsql.org/browse/CORE-3306?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Adriano dos Santos Fernandes resolved CORE-3306.
------------------------------------------------

    Fix Version/s: 2.5.1
                   3.0 Alpha 1
       Resolution: Fixed

> Invariant sub-query is treated as variant thus causing multiple 
> invokations of a nested stored procedure
> --------------------------------------------------------------------------------------------------------
>
>                 Key: CORE-3306
>                 URL: http://tracker.firebirdsql.org/browse/CORE-3306
>             Project: Firebird Core
>          Issue Type: Bug
>          Components: Engine
>    Affects Versions: 2.5.0
>         Environment: Found and Tested on MS Windows XP 
> (Firebird-2.5.0.26074_1_Win32) and Server 2008 
> (Firebird-2.5.0.26074_1_x64 )
>            Reporter: Jean-Baptiste Simmen
>            Assignee: Adriano dos Santos Fernandes
>             Fix For: 2.5.1, 3.0 Alpha 1
>
>
> The Behaviour about a where statement with static content have change from 
> Firebird 1.5/2.1 to 2.5 and have a massiv impact in our case. The static 
> statement like (select sValue From spr_test('SIMSIM')) is evaluated 1 time 
> in firebird 1.5 and 2.1, the number of row in the from-clause with 
> firebird 2.5 (about 45'000 in our case).
> You can test it with the following script:
> -------------------------------------------------------------------------------
> -- Init
> -------------------------------------------------------------------------------
> Create Table tt_table(Field1 varchar(100));
> go
> Create Or Alter PROCEDURE SPR_TEST (pName Varchar(2000)) RETURNS (sValue 
> Varchar(255)) AS
> BEGIN
>   Insert Into tt_table(field1) values(:pName);
>   sValue=:pName;
>   suspend;
> End
> go
> -------------------------------------------------------------------------------
> -- Call procedure
> -------------------------------------------------------------------------------
> Select count(*)
> from rdb$types
> where rdb$field_name like (select sValue From spr_test('SIMSIM'))
> go
> -------------------------------------------------------------------------------
> -- Result is 1 with Firebird 1.5 and 2.1, 225 with Firebird 2.5
> -------------------------------------------------------------------------------
> Select count(*) From tt_table
> go
> -------------------------------------------------------------------------------
> -- Clean
> -------------------------------------------------------------------------------
> Drop Procedure spr_test
> go
> Drop Table tt_table
> go
> Thank you for your big work with Firebird, its a very good thing!

-- 
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