|   | php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login | 
| 
 PatchesPull Requests
Pull requests: HistoryAllCommentsChangesGit/SVN commits              [2019-04-07 12:12 UTC] 
  [2019-09-10 07:24 UTC] cmb@php.net
 
-Status:      Open
+Status:      Closed
-Assigned To:
+Assigned To: cmb
  [2019-09-10 07:24 UTC] cmb@php.net
 | |||||||||||||||||||||||||||
|  Copyright © 2001-2025 The PHP Group All rights reserved. | Last updated: Fri Oct 31 01:00:01 2025 UTC | 
Description: ------------ PDO firebird does not support type Boolean in input parameters Test script: --------------- $sql = <<<SQL with t(b, s) as ( select true, 'true' from rdb\$database union all select false, 'false' from rdb\$database union all select unknown, 'unknown' from rdb\$database ) select trim(s) as s from t where b is not distinct from :p SQL; require 'testdb.inc'; $db = new PDO('firebird:dbname='.$test_base, $user, $password) or die; try { // PDO::PARAM_BOOL $query = $db->prepare($sql); $query->bindValue('p', 0, PDO::PARAM_BOOL); $query->execute(); var_dump($query->fetchColumn(0)); $query->bindValue('p', 1, PDO::PARAM_BOOL); $query->execute(); var_dump($query->fetchColumn(0)); $query->bindValue('p', false, PDO::PARAM_BOOL); $query->execute(); var_dump($query->fetchColumn(0)); $query->bindValue('p', true, PDO::PARAM_BOOL); $query->execute(); var_dump($query->fetchColumn(0)); echo "OK\n"; } catch(Exception $e) { echo $e->getMessage() . '<br>'; echo $e->getTraceAsString(); } Expected result: ---------------- string(5) "false" string(4) "true" string(5) "false" string(4) "true" OK