|
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 GroupAll rights reserved. |
Last updated: Fri Oct 24 07: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