#43457 [NEW]: prepared statement with incorrect parms doens't throw exception

From: pookey at pookey dot co dot uk Operating system: linux PHP version: 5.2CVS-2007-11-29 (CVS) PHP Bug Type: PostgreSQL related Bug description: prepared statement with incorrect parms doens't throw exception Description: ------------ no exception is thrown when using named params to a prepared statement, when you pass invalid names. Interestingly, is that count of the params doesnt' match, an exception is thrown. Using the code below, but using sqlite instead.. $pdo = new PDO('sqlite::memory:'); then you do get an exception # php ./test.php PDOException: SQLSTATE[HY000]: General error: 25 bind or column index out of range in /tmp/test.php on line 16 Call Stack: 0.0002 103296 1. {main}() /tmp/test.php:0 0.0014 106912 2. PDOStatement->execute() /tmp/test.php:16 I've not tested with other DBMSs. Reproduce code: --------------- $ cat ./test.php <?php error_reporting(E_ALL); $pdo = new PDO('pgsql:dbname=mmm user=mmm'); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $pdo->exec('CREATE TABLE test ( field1 varchar, field2 varchar)'); $stmt2 = $pdo->prepare('INSERT INTO test (field1, field2) VALUES (:param1, :param2)'); $pdo->beginTransaction(); $ret = $stmt2->execute( array( ':param1' => 'wibble', ':nonsense' => 1, )); var_dump($ret); var_dump($stmt2->errorInfo()); Expected result: ---------------- exception thrown Actual result: -------------- $ ~pookey/src/php5/sapi/cli/php ./test.php bool(false) array(3) { [0]=> string(5) "HY093" [1]=> int(7) [2]=> string(0) "" } -- Edit bug report at http://bugs.php.net/?id=43457&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=43457&r=trysnapshot44 Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=43457&r=trysnapshot52 Try a CVS snapshot (PHP 5.3): http://bugs.php.net/fix.php?id=43457&r=trysnapshot53 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=43457&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=43457&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=43457&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=43457&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=43457&r=needscript Try newer version: http://bugs.php.net/fix.php?id=43457&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=43457&r=support Expected behavior: http://bugs.php.net/fix.php?id=43457&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=43457&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=43457&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=43457&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=43457&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=43457&r=dst IIS Stability: http://bugs.php.net/fix.php?id=43457&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=43457&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=43457&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=43457&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=43457&r=mysqlcfg