From: develar at gmail dot com Operating system: Debian 3 PHP version: 5.2.0 PHP Bug Type: PDO related Bug description: No cast of logic type and silence
Description: ------------ PDO does not cast a variable with boolean type in bindValue, does not do execute and is silent. I should cast manually - (int). Reproduce code: --------------- CREATE TABLE `test` ( `test` tinyint(1) NOT NULL default '0' ) ENGINE=MyISAM DEFAULT CHARSET=utf8; $Db = new PDO('mysql:host=localhost;dbname=test', 'root', ''); $Db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $Db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC); $boolean = 1; $Pdo = $Db->prepare('INSERT INTO test VALUES (:boolean)'); $Pdo->bindValue(':boolean', isset($boolean), PDO::PARAM_INT); $Pdo->execute(); Expected result: ---------------- array(1) { [0]=> array(1) { ["test"]=> string(1) "1" } } Actual result: -------------- array(0) { } -- Edit bug report at http://bugs.php.net/?id=39398&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=39398&r=trysnapshot44 Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=39398&r=trysnapshot52 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=39398&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=39398&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=39398&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=39398&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=39398&r=needscript Try newer version: http://bugs.php.net/fix.php?id=39398&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=39398&r=support Expected behavior: http://bugs.php.net/fix.php?id=39398&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=39398&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=39398&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=39398&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=39398&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=39398&r=dst IIS Stability: http://bugs.php.net/fix.php?id=39398&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=39398&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=39398&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=39398&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=39398&r=mysqlcfg