limit in length of sql string V4MD 4.3 on PC

[Ruslan Zasukhin]

On 11/24/09 9:39 PM, "Christian - ChrisKatDev.com"
<christian at chriskatdev.com> wrote:

>>> I have crash on pc, but not on mac, with a request very long (with very big
>>> "IN")
>>> => I have 95660 car in my request...
>>> 
>>> have you a limit ?
>>> 
>>> exemple : 
>>> "SELECT idPhoto FROM user_bloc_photos WHERE (idprojet = 2) AND (idPhoto IN
>>> (1,
>>> 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, .....,
>>> 15241,
>>> 15242))"
>> 
>> Please report this to mantis.
> Ruslan,
> 
> it's a question... :
> Have you a limit ?
> Or is-it a bug ?

I think bug, because we have remove any artificial limits few years ago ...

At least for local db

I not remember now if we have any limits for client/server.
It seems we don't 




-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]