Package: libsqlite3-0 Version: 3.7.17-1 Severity: wishlist http://www.sqlite.org/limits.html#max_variable_number
Upstream document this compile-time limit. But 999 is ridiculously low by today's standard of memory size. This limit can be increased to something bigger. FWIW Apple has increased this limit to 500000 apparently: http://stackoverflow.com/questions/10332668/sqlite-max-query-parameters-differs-on-snow-leopard In my use case, I have queries that embed all the Debian package names so I need several dozens of thousands of variables. This is for a query that Django generates and it's similar to something like this: SELECT * FROM packageinfos WHERE name in (?,?,?,…). Cheers, -- System Information: Debian Release: jessie/sid APT prefers unstable APT policy: (500, 'unstable'), (500, 'stable'), (1, 'experimental') Architecture: amd64 (x86_64) Foreign Architectures: i386 Kernel: Linux 3.9-1-amd64 (SMP w/4 CPU cores) Locale: LANG=fr_FR.UTF-8, LC_CTYPE=fr_FR.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/dash -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
