FS#52382 - [sqlite] Default value for SQLITE_MAX_VARIABLE_NUMBER is to low for many applications

Attached to Project: Arch Linux
Opened by Open Media Library (openmedialibrary) - Thursday, 05 January 2017, 21:58 GMT
Last edited by Andreas Radke (AndyRTR) - Friday, 06 January 2017, 21:31 GMT
Task Type Feature Request
Category Packages: Core
Status Closed
Assigned To Andreas Radke (AndyRTR)
Architecture All
Severity Low
Priority Normal
Reported Version
Due in Version Undecided
Due Date Undecided
Percent Complete 100%
Votes 1
Private No

Details

sqlite sets SQLITE_MAX_VARIABLE_NUMBER to 999 by default,
Apple ships with SQLITE_MAX_VARIABLE_NUMBER set to 500000
Ubuntu/Debian set it to 250000[1]
Brew also sets this to 250000[2]

would be helpful raise this value to 250000 on arch too.
patch attached

https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=717900
https://github.com/Homebrew/legacy-homebrew/pull/49423
   sqlite_SQLITE_MAX_VARIABLE_NU... (0.5 KiB)
This task depends upon

Closed by  Andreas Radke (AndyRTR)
Friday, 06 January 2017, 21:31 GMT
Reason for closing:  Implemented
Additional comments about closing:  3.16.2-1
Comment by Erik Stein (eriks) - Friday, 06 January 2017, 08:41 GMT
See here for a comparison to competing RDBMs:

http://stackoverflow.com/questions/6581573/what-are-the-max-number-of-allowable-parameters-per-database-provider-type#6582902
Comment by Erik Stein (eriks) - Friday, 06 January 2017, 08:46 GMT
This is needed for common queries using the IN operator, like "SELECT * FROM table WHERE id IN (1, 2, 3 ... 40000)".

Loading...