|
From: <no...@so...> - 2002-02-16 19:20:18
|
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 |