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

Edit report at https://bugs.php.net/bug.php?id=74217&edit=1 ID: 74217 Updated by: cmb@php.net Reported by: remo dot laubacher at ortic dot com Summary: Allow creation of deterministic sqlite functions Status: Closed Type: Feature/Change Request Package: SQLite related Operating System: any PHP Version: 7.1.3RC1 Assigned To: nikic Block user comment: N Private report: N New Comment: JFTR: documented with <http://svn.php.net/viewvc?view=revision&revision=342155>. Previous Comments: ------------------------------------------------------------------------ [2017-03-12 19:25:52] remo dot laubacher at ortic dot com Thanks guys, I'm impressive about how smooth this went! ------------------------------------------------------------------------ [2017-03-12 17:30:19] nikic@php.net PR merged into 7.1. ------------------------------------------------------------------------ [2017-03-10 18:02:41] cmb@php.net The PR targets PDO_sqlite as well as sqlite3, so I'm changing the package back to "SQLite related". ------------------------------------------------------------------------ [2017-03-10 17:37:52] andrew dot nester dot dev at gmail dot com thanks! I just added PR to added desired behaviour but suppose that it requires proper RFC. ------------------------------------------------------------------------ [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