On 1/12/2010 5:36 PM, Kees Nuyt wrote: > There is a maximum list size the parser can cope with. > Internally "id IN (val1,val2,...valN)" > is converted to > "WHERE id = val1 OR id = val2 OR .... id = valN" > > http://www.sqlite.org/limits.html > > I think here > 5. Maximum Depth Of An Expression Tree > applies, which defaults to 1000. > > Experiment to verify ;) > >
thank you very much for all the insightful comments. The suggested syntax also worked nicely. Qianqian _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
