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

From:	remo dot laubacher at ortic dot com	Date:	Tue, 07 Mar 2017 14:20:01 +0000
Subject:	Req #74217 [NEW]: Allow creation of deterministic sqlite functions
Groups:	php.bugs
Request:	Send a blank email to php-bugs+get-207720@lists.php.net to get a copy of this message

From:             remo dot laubacher at ortic dot com
Operating system: any
PHP version:      7.1.3RC1
Package:          SQLite related
Bug Type:         Feature/Change Request
Bug description:Allow creation of deterministic sqlite functions

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 bug report at https://bugs.php.net/bug.php?id=74217&edit=1
-- 
Try a snapshot (PHP 5.4):   https://bugs.php.net/fix.php?id=74217&r=trysnapshot54
Try a snapshot (PHP 5.5):   https://bugs.php.net/fix.php?id=74217&r=trysnapshot55
Try a snapshot (trunk):     https://bugs.php.net/fix.php?id=74217&r=trysnapshottrunk
Fixed in SVN:               https://bugs.php.net/fix.php?id=74217&r=fixed
Fixed in release:           https://bugs.php.net/fix.php?id=74217&r=alreadyfixed
Need backtrace:             https://bugs.php.net/fix.php?id=74217&r=needtrace
Need Reproduce Script:      https://bugs.php.net/fix.php?id=74217&r=needscript
Try newer version:          https://bugs.php.net/fix.php?id=74217&r=oldversion
Not developer issue:        https://bugs.php.net/fix.php?id=74217&r=support
Expected behavior:          https://bugs.php.net/fix.php?id=74217&r=notwrong
Not enough info:            https://bugs.php.net/fix.php?id=74217&r=notenoughinfo
Submitted twice:            https://bugs.php.net/fix.php?id=74217&r=submittedtwice
register_globals:           https://bugs.php.net/fix.php?id=74217&r=globals
PHP 4 support discontinued: https://bugs.php.net/fix.php?id=74217&r=php4
Daylight Savings:           https://bugs.php.net/fix.php?id=74217&r=dst
IIS Stability:              https://bugs.php.net/fix.php?id=74217&r=isapi
Install GNU Sed:            https://bugs.php.net/fix.php?id=74217&r=gnused
Floating point limitations: https://bugs.php.net/fix.php?id=74217&r=float
No Zend Extensions:         https://bugs.php.net/fix.php?id=74217&r=nozend
MySQL Configuration Error:  https://bugs.php.net/fix.php?id=74217&r=mysqlcfg



   

Thread (8 messages)

• remo dot laubacher at ortic dot comTue, 07 Mar 2017 14:20:01 +0000
  • andrew dot nester dot dev at gmail dot comFri, 10 Mar 2017 17:37:53 +0000Req #74217 [Com]: Allow creation of deterministic sqlite functions
  • cmb@php.netFri, 10 Mar 2017 18:02:42 +0000Req #74217 [Opn]: Allow creation of deterministic sqlite functions
  • nikic@php.netSun, 12 Mar 2017 17:30:20 +0000Req #74217 [Opn->Csd]: Allow creation of deterministic sqlite functions
  • remo dot laubacher at ortic dot comSun, 12 Mar 2017 19:25:52 +0000Req #74217 [Csd]: Allow creation of deterministic sqlite functions
  • cmb@php.netFri, 17 Mar 2017 14:08:24 +0000Req #74217 [Csd]: Allow creation of deterministic sqlite functions
  • remi@php.netWed, 29 Mar 2017 05:21:10 +0000Req #74217 [Csd]: Allow creation of deterministic sqlite functions
  • remi@php.netWed, 29 Mar 2017 05:29:44 +0000Req #74217 [Com]: Allow creation of deterministic sqlite functions