Re: is there limit on "in operator"?
Date: Thu, 17 Oct 2002 09:35:27 -0400
Message-ID: <3DAEBC9F.1080607_at_avialantic.com>
Joe D wrote:
> I have to use a select query using in operator where the in clause
> can not be a subquery since the conditions are not in the database.
> The query like:
> select * from mytable where mycolum in
> (very-long-concatenated-string-for-values);
>
> I am concerned that if there is limit on in, then if currently i do
> not run into trouble, sometime maybe.
>
> Can anyone help? Thanks
>
I thought I found a limit back in 7.1.x but the topic came up recently and I couldn't find any indication of a limit in any documentation thus far. Tried a few tests with very large strings and lots of elements and was not able to find a limit. Not very scientific I admit - didn't note how many elements or lengths of strings - was only interested in what we were likely to exceed on our project.
Am curious if this limit or lack thereof is documented somewhere.
fdp
Fred Pierce (DNRC)- fpierce_at_avialantic.com Mid-Atlantic Aviation on the Web - http://www.avialantic.com ** Mid Atlantic Air Museum WWII Weekend Airshow June 6-8 2003 - www.maam.org/maamwwii.html **
*** World Airshow News - www.worldairshownews.com **
Received on Thu Oct 17 2002 - 15:35:27 CEST