[Firebird-devel] [ firebird-Bugs-509986 ] Optimization of subselect IN clause

[<no...@so...>]

Bugs item #509986, was opened at 2002-01-28 18:05
You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=109028&aid=509986&group_id=9028

Category: Core Engine
Group: Confirmed Bug
>Status: Deleted
>Resolution: Duplicate
Priority: 5
Submitted By: Sean Leyne (seanleyne)
Assigned to: Nobody/Anonymous (nobody)
Summary: Optimization of subselect IN clause

Initial Comment:
From Ann H.

Starting in version 5 (I think) subselects were 
analyzed in cmp.c to identify the ones that are loop 
invariants.  The invariant subqueries were moved to a 
separate part of the execution tree so they would run 
once rather than once per iteration of the outer 
select.

When this was done, one construct was omitted - a 
subselect in an IN clause.  There is a comment in the 
code that says that the omission was deliberate, but I 
don't know why.

----------------------------------------------------------------------

>Comment By: Sean Leyne (seanleyne)
Date: 2002-02-16 11:20

Message:
Logged In: YES 
user_id=71163

Item had previously been logged, see tracker entry #447002.

----------------------------------------------------------------------

You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=109028&aid=509986&group_id=9028