Req #77863 [NEW]: PDO firebird support type Boolean in input parameters

From: sim-mail at list dot ru Operating system: any PHP version: 7.3.4 Package: PDO Firebird Bug Type: Feature/Change Request Bug description:PDO firebird support type Boolean in input parameters 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 -- Edit bug report at https://bugs.php.net/bug.php?id=77863&edit=1 -- Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=77863&r=trysnapshot54 Try a snapshot (PHP 5.5): https://bugs.php.net/fix.php?id=77863&r=trysnapshot55 Try a snapshot (trunk): https://bugs.php.net/fix.php?id=77863&r=trysnapshottrunk Fixed in SVN: https://bugs.php.net/fix.php?id=77863&r=fixed Fixed in release: https://bugs.php.net/fix.php?id=77863&r=alreadyfixed Need backtrace: https://bugs.php.net/fix.php?id=77863&r=needtrace Need Reproduce Script: https://bugs.php.net/fix.php?id=77863&r=needscript Try newer version: https://bugs.php.net/fix.php?id=77863&r=oldversion Not developer issue: https://bugs.php.net/fix.php?id=77863&r=support Expected behavior: https://bugs.php.net/fix.php?id=77863&r=notwrong Not enough info: https://bugs.php.net/fix.php?id=77863&r=notenoughinfo Submitted twice: https://bugs.php.net/fix.php?id=77863&r=submittedtwice register_globals: https://bugs.php.net/fix.php?id=77863&r=globals PHP 4 support discontinued: https://bugs.php.net/fix.php?id=77863&r=php4 Daylight Savings: https://bugs.php.net/fix.php?id=77863&r=dst IIS Stability: https://bugs.php.net/fix.php?id=77863&r=isapi Install GNU Sed: https://bugs.php.net/fix.php?id=77863&r=gnused Floating point limitations: https://bugs.php.net/fix.php?id=77863&r=float No Zend Extensions: https://bugs.php.net/fix.php?id=77863&r=nozend MySQL Configuration Error: https://bugs.php.net/fix.php?id=77863&r=mysqlcfg