28 Sep 2007 00:07
".. WHERE id IN (..1340 ids..)" => error
Michael P <mp11 <at> 1well.de>
2007-09-27 22:07:34 GMT
2007-09-27 22:07:34 GMT
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)
RSS Feed