What is the maximum number of literal values that can be put inside the IN ( )
list ?
select * from T where aColumn in (1,2,3,4,...)
I didn't see the answer here: http://www.sqlite.org/limits.html
My queries could have more than 255 values from time to time, which exceeds the
limit here on some databases I've worked with in the past.
BTW, the remote client is passing these explilcit values over the internet to
the server --i.e. the query cannot be rewritten as follows:
select * from T where aColumn in ( select values from T2 where...)
at least not without creating temporary tables to hold the value-list sent by
the client.
Thanks
Tim
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
