Req #74217 [Com]: Allow creation of deterministic sqlite functions

Edit report at https://bugs.php.net/bug.php?id=74217&edit=1 ID: 74217 Comment by: andrew dot nester dot dev at gmail dot com Reported by: remo dot laubacher at ortic dot com Summary: Allow creation of deterministic sqlite functions Status: Open Type: Feature/Change Request Package: SQLite related Operating System: any PHP Version: 7.1.3RC1 Block user comment: N Private report: N New Comment: thanks! I just added PR to added desired behaviour but suppose that it requires proper RFC. Previous Comments: ------------------------------------------------------------------------ [2017-03-07 14:19:58] remo dot laubacher at ortic dot com Description: ------------ SQLite has an option to define a custom function as deterministic, and by that allowing it to be indexed. This obviously has a huge impact on the performance. Adding SQLITE_DETERMINISTIC (0x800) to the 4th parameter does the trick, check this for more information: https://www.sqlite.org/c3ref/create_function.html From what my basic C skills tell me, it's currently hard-coded in PHP: https://github.com/php/php-src/blob/master/ext/sqlite3/sqlite3.c#L933 Exposing the 4th parameter would give us this flexibility. ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=74217&edit=1