#34233 [Opn->Asn]: PDO ignores parameters when surrounded by closed quotes

ID: 34233 Updated by: sniper@php.net Reported By: php at sagi dot org -Status: Open +Status: Assigned Bug Type: PDO related Operating System: Linux PHP Version: 5.1.0RC1 -Assigned To: +Assigned To: wez 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