maxirobaina wrote:

> Thanks Ann:
>
> Only snoopy, You can tell me why of this limit ?
>

There's a limit on the size of a compiler scratch block and each part of
the IN uses a bit of it. The limit doesn't apply to queries like this:

select p.name from phones p where p.extension in
(select p1.extensions from phones p1)

just to queries like this:

select p.name from phones p where p.extension in
(0000, 0001, 0002, 0003, 0004, 0005, 0006, 0007,.... 1499)


The restriction may be lifted in V2, I don't remember.

Regards,


Ann