Re: Please increase the default for SQLITE_MAX_VARIABLE_NUMBER
"J. King" <jking-EVdj5nudw4IsA/[email protected]>
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <[email protected]> |
On February 4, 2020 7:10:52 p.m. EST, Scott Perry <[email protected]> wrote: >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 :) Not everyone has access to carrays and intarrays, either, such as PHP users like myself. -- J. King _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users