db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yip Ng" <yipng...@gmail.com>
Subject Re: Is this a bug in EXISTS?
Date Thu, 22 Feb 2007 17:51:05 GMT
On 2/22/07, Dyre.Tjeldvoll@sun.com <Dyre.Tjeldvoll@sun.com> wrote:

> It seems like EXISTS on a SELECT returning zero rows returns false (as
> expected), but EXISTS on INTERSECT of two disjunct sets returns true,
> e.g EXISTS (values 1 intersect values 2).

select * from ( values 'BAD' ) as T where exists (values 1 intersect
values 2) should
return 0 row.  So its a bug.

Regards,
Yip Ng

Mime
View raw message