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
|
