|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Request #77863 PDO firebird support type Boolean in input parameters
Submitted: 2019-04-07 11:42 UTC Modified: 2019-09-10 07:24 UTC
From: sim-mail at list dot ru Assigned: cmb (profile)
Status: Closed Package: PDO Firebird
PHP Version: 7.3.4 OS: any
Private report: No CVE-ID: None
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
Block user comment
Status: Assign to:
Bug Type:
From: sim-mail at list dot ru
New email:
PHP Version: OS:


 [2019-04-07 11:42 UTC] sim-mail at list dot ru
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

require '';
$db = new PDO('firebird:dbname='.$test_base, $user, $password) or die;
try { 

  $query = $db->prepare($sql);
  $query->bindValue('p', 0, PDO::PARAM_BOOL);
  $query->bindValue('p', 1, PDO::PARAM_BOOL);
  $query->bindValue('p', false, PDO::PARAM_BOOL);
  $query->bindValue('p', true, PDO::PARAM_BOOL);
  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"


Add a Patch

Pull Requests

Pull requests:

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2019-04-07 12:12 UTC]
The following pull request has been associated:

Patch Name:  Request #77863 Add support boolean datatype for PDO Firebird in input parameters
On GitHub:
 [2019-09-10 07:24 UTC]
-Status: Open +Status: Closed -Assigned To: +Assigned To: cmb
PHP Copyright © 2001-2021 The PHP Group
All rights reserved.
Last updated: Wed Apr 21 20:01:24 2021 UTC