#41596 [NEW]: crash. when sql syntax is invalid

From: Date: Tue, 05 Jun 2007 10:48:12 +0000
Subject: #41596 [NEW]: crash. when sql syntax is invalid
Groups: php.bugs 
Request: Send a blank email to php-bugs+get-113401@lists.php.net to get a copy of this message
From: develar at gmail dot com Operating system: Windows XP SP2 PHP version: 5.2.3 PHP Bug Type: PDO related Bug description: crash. when sql syntax is invalid Description: ------------ 'delete from users."users where id = :id' is wrong, must be 'delete from users."users" where id = :id', but why pdo crash. Reproduce code: --------------- <?php $Db = new PDO('pgsql:host=192.168.0.66;dbname=test', 'postgres', 'password'); $Db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC); $Db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING); $Pdo = $Db->prepare('delete from users."users where id = :id'); $Pdo->bindValue(':id', 45, PDO::PARAM_INT); $Pdo->execute(); ?> Expected result: ---------------- not crash Actual result: -------------- crash -- Edit bug report at http://bugs.php.net/?id=41596&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=41596&r=trysnapshot44 Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=41596&r=trysnapshot52 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=41596&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=41596&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=41596&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=41596&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=41596&r=needscript Try newer version: http://bugs.php.net/fix.php?id=41596&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=41596&r=support Expected behavior: http://bugs.php.net/fix.php?id=41596&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=41596&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=41596&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=41596&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=41596&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=41596&r=dst IIS Stability: http://bugs.php.net/fix.php?id=41596&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=41596&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=41596&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=41596&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=41596&r=mysqlcfg

« previous php.bugs (#113401) next »