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"
  }
}