Re: Please increase the default for SQLITE_MAX_VARIABLE_NUMBER
Scott Perry <[email protected]>
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <[email protected]> |
On Feb 4, 2020, at 12:26 PM, Simon Slavin <[email protected]> wrote: > > On 4 Feb 2020, at 7:13pm, Deon Brewis <[email protected]> wrote: > >> WHERE x IN (?1,?2,?3,?4...,?1000 ) > > People really do this ? Sheesh. It's a pretty common pattern. Sure, queries that are likely to use very large IN groups ought to be using carray or intarray but not everyone knows they exist :) Scott _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users