#41596 [Opn->Fbk]: crash. when sql syntax is invalid
ID: 41596
Updated by: tony2001@php.net
Reported By: develar at gmail dot com
-Status: Open
+Status: Feedback
Bug Type: PDO related
Operating System: Windows XP SP2
PHP Version: 5.2.3
New Comment:
Compare it to the backtrace here:
http://bugs.php.net/bugs-generating-backtrace-win32.php
Previous Comments:
------------------------------------------------------------------------
[2007-06-05 15:20:25] develar at gmail dot com
Call Stack: PHP_PDO! 00fb5323()
It what is necessary?
------------------------------------------------------------------------
[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
Thread (9 messages)