Michael P | 28 Sep 2007 00:07
Picon

".. WHERE id IN (..1340 ids..)" => error

Hi,

I use 1340 ids in the IN condition. The result is the error message:

#Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed
# General error;-1103 POS(1) Too complicated SQL statement

Is the number of ids or the length of the sql cmd measured in chars the 
problem? What are the limits. I use MaxDB 7.5.

Is there any chance to make it possible to use 1340 explicitely 
mentioned ids or even more?

Of course, when I use a subquery instead of the list of ids the error 
disappears.

Best wishes -- thanks for hints
Michael

- - - - -

SELECT   s_registrationno, p_id, p_name, p_firstname, p_sexcodeno, 
p_title1codeno, p_title2codeno, p_titleelse, p_title3codeno
FROM persons, students
WHERE p_fk_student_id = s_id
AND p_id IN (220,260,318,329,431,526,572,575,584,632,643,653,656,745,790,
853,861,867,874,875,876,885,886,891,894,902,903,916,923,930,
932,934,936,940,945,971,996,1011,1013,1014,1015,1016,1026,
1030,1041,1048,1060,1062,1089,1119,1129,1132,1133,1135,1136,
1137,1138,1139,1141,1142,1143,1144,1145,1146,1147,1149,1152,
(Continue reading)


Gmane