#41596 [Fbk->Opn]: crash. when sql syntax is invalid
| From: | develar at gmail dot com | Date: | Tue, 05 Jun 2007 15:20:25 +0000 |
| Subject: | #41596 [Fbk->Opn]: crash. when sql syntax is invalid | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-113415@lists.php.net to get a copy of this message | ||
ID: 41596
User updated by: develar at gmail dot com
Reported By: develar at gmail dot com
-Status: Feedback
+Status: Open
Bug Type: PDO related
Operating System: Windows XP SP2
PHP Version: 5.2.3
New Comment:
Call Stack: PHP_PDO! 00fb5323()
It what is necessary?
Previous Comments:
------------------------------------------------------------------------
[2007-06-05 11:29:17] tony2001@php.net
Thank you for this bug report. To properly diagnose the problem, we
need a backtrace to see what is happening behind the scenes. To
find out how to generate a backtrace, please read
http://bugs.php.net/bugs-generating-backtrace.php
for *NIX and
http://bugs.php.net/bugs-generating-backtrace-win32.php
for Win32
Once you have generated a backtrace, please submit it to this bug
report and change the status back to "Open". Thank you for helping
us make PHP better.
------------------------------------------------------------------------
[2007-06-05 11:03:29] develar at gmail dot com
Apache die.
Server API: Apache 2.0 Handler.
Apache Version: Apache/2.0.59 (Win32).
------------------------------------------------------------------------
[2007-06-05 10:56:50] tony2001@php.net
Please define "crash".
------------------------------------------------------------------------
[2007-06-05 10:48:12] develar at gmail dot com
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 this bug report at http://bugs.php.net/?id=41596&edit=1