Here's the page with the limits for what you can give SQLite https://www.sqlite.org/limits.html
Depending on what your statement ended up looking like that could be the "Maximum Length of an SQL Statement" of 1,000,000 or maybe Maximum Number of Columns of 2,000? Check to see if you're violating one of the things in there, and if not then give us some more info on just how many items are in the list, and how large the statement text ended up as. And if it exits without any error code, why do you say it's broken? -----Original Message----- From: sqlite-users [mailto:[email protected]] On Behalf Of Mohd Radzi Ibrahim Sent: Wednesday, February 13, 2019 8:35 AM To: [email protected] Subject: [sqlite] Problem with clause "where X in (...)" Hi, I thought that I hit a bug with SQLite 3.28.0 and 3.27.1 when my in-list contains too many items the code breaks here: The sqlite3_step just exit without returning any error code. best regards, Radzi _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
