Tatsuo Ishii <[EMAIL PROTECTED]> writes:
>> It's not immediately obvious to me that these are equivalent, or
>> perhaps I should say it's not clear under what conditions is the
>> transformation legitimate.
> Could you tell me in what cases two of above are not equivalent?
It may well be OK, I j
On Thu, Jul 12, 2001 at 01:39:07PM +0900, Tatsuo Ishii wrote:
> > Christopher Masto <[EMAIL PROTECTED]> writes:
> > > I guess maybe I'm expecting too much magic optimization.
> >
> > You're expecting the system to transform
> >
> > (SELECT foo UNION SELECT bar) WHERE condition
> >
> > into
> Christopher Masto <[EMAIL PROTECTED]> writes:
> > I guess maybe I'm expecting too much magic optimization.
>
> You're expecting the system to transform
>
> (SELECT foo UNION SELECT bar) WHERE condition
>
> into
>
> (SELECT foo WHERE condition) UNION (SELECT bar WHERE condition)
>