Req #75662 [NEW]: pdo sqlite is not compiled with SQLITE_ENABLE_FTS3_PARENTHESIS

From: mesa57 at hotmail dot com Operating system: Any PHP version: Irrelevant Package: PDO SQLite Bug Type: Feature/Change Request Bug description:pdo sqlite is not compiled with SQLITE_ENABLE_FTS3_PARENTHESIS Description: ------------ pdo sqlite is not compiled with SQLITE_ENABLE_FTS3_PARENTHESIS Verify with sql : PRAGMA compile_options; Test script: --------------- <?php // Any SQLite3 database will do $dbh = new PDO('sqlite:d:/sqlite/spotweb.db'); $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $sql = 'PRAGMA compile_options;'; $stm = $dbh->query($sql); $lst = $stm->fetchAll(); var_dump($lst); ?> Actual result: -------------- For php 71 this outputs : array(7) { [0] => array(2) { 'compile_option' => string(18) "COMPILER=msvc-1900" [0] => string(18) "COMPILER=msvc-1900" } [1] => array(2) { 'compile_option' => string(22) "ENABLE_COLUMN_METADATA" [0] => string(22) "ENABLE_COLUMN_METADATA" } [2] => array(2) { 'compile_option' => string(11) "ENABLE_FTS3" [0] => string(11) "ENABLE_FTS3" } [3] => array(2) { 'compile_option' => string(11) "ENABLE_FTS4" [0] => string(11) "ENABLE_FTS4" } [4] => array(2) { 'compile_option' => string(11) "ENABLE_FTS5" [0] => string(11) "ENABLE_FTS5" } [5] => array(2) { 'compile_option' => string(13) "SYSTEM_MALLOC" [0] => string(13) "SYSTEM_MALLOC" } [6] => array(2) { 'compile_option' => string(12) "THREADSAFE=0" [0] => string(12) "THREADSAFE=0" } } -- Edit bug report at https://bugs.php.net/bug.php?id=75662&edit=1 -- Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=75662&r=trysnapshot54 Try a snapshot (PHP 5.5): https://bugs.php.net/fix.php?id=75662&r=trysnapshot55 Try a snapshot (trunk): https://bugs.php.net/fix.php?id=75662&r=trysnapshottrunk Fixed in SVN: https://bugs.php.net/fix.php?id=75662&r=fixed Fixed in release: https://bugs.php.net/fix.php?id=75662&r=alreadyfixed Need backtrace: https://bugs.php.net/fix.php?id=75662&r=needtrace Need Reproduce Script: https://bugs.php.net/fix.php?id=75662&r=needscript Try newer version: https://bugs.php.net/fix.php?id=75662&r=oldversion Not developer issue: https://bugs.php.net/fix.php?id=75662&r=support Expected behavior: https://bugs.php.net/fix.php?id=75662&r=notwrong Not enough info: https://bugs.php.net/fix.php?id=75662&r=notenoughinfo Submitted twice: https://bugs.php.net/fix.php?id=75662&r=submittedtwice register_globals: https://bugs.php.net/fix.php?id=75662&r=globals PHP 4 support discontinued: https://bugs.php.net/fix.php?id=75662&r=php4 Daylight Savings: https://bugs.php.net/fix.php?id=75662&r=dst IIS Stability: https://bugs.php.net/fix.php?id=75662&r=isapi Install GNU Sed: https://bugs.php.net/fix.php?id=75662&r=gnused Floating point limitations: https://bugs.php.net/fix.php?id=75662&r=float No Zend Extensions: https://bugs.php.net/fix.php?id=75662&r=nozend MySQL Configuration Error: https://bugs.php.net/fix.php?id=75662&r=mysqlcfg