ID: 34233
User updated by: php at sagi dot org
-Summary: PDO misquotes/miscasts bool(false)
Reported By: php at sagi dot org
Status: Open
Bug Type: PDO related
Operating System: Linux
PHP Version: 5.1.0RC1
New Comment:
Fixing subject, the bug system somehow changed it to a subject of a
previous bug that I've reported.
Previous Comments:
------------------------------------------------------------------------
[2005-08-24 13:23:57] php at sagi dot org
Description:
------------
Running PHP5.1.0RC1, postgresql 8 server with v7.4.7 client libs
(pretty sure native prepared statements are disabled).
When trying to execute this query:
$stmt = $db->prepare("SELECT ('0' || :param || '0')");
$stmt->execute(array(':param' => 123));
PDO actually executes this SQL statement: SELECT ('0' || :param ||
'0'), without replacing :param.
It seems like the parser thinks the whole "0' || :param || '0" part is
quoted, though its not.
The query "SELECT (0 || :param || 0)" works as expected.
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=34233&edit=1
