#39483 [Fbk->Opn]: Problem with using placeholders and string constants in PDO MySQL

ID: 39483 User updated by: suhachov at gmail dot com Reported By: suhachov at gmail dot com -Status: Feedback +Status: Open Bug Type: PDO related Operating System: Linux PHP Version: 5.2.0 New Comment: I've tried it with: 5.0.26 4.1.15 Previous Comments: ------------------------------------------------------------------------ [2006-11-12 17:56:36] iliaa@php.net which version of MySQL are you using? ------------------------------------------------------------------------ [2006-11-12 16:23:41] suhachov at gmail dot com Description: ------------ It seems that PDO sql parser is broken and tries to look for placeholders within string constants. $dbh = new PDO('mysql:...','...','...'); $sth = $dbh->prepare('SELECT my_udf(\'\0:D\0\'),?'); $sth->execute(array(1)); This code triggers an error: PDO::prepare(): SQLSTATE[HY093]: Invalid parameter number: mixed named and positional parameters And I can't replace string constant with placeholder, because MySQL doesn't allows to use placeholders with UDFs. Reproduce code: --------------- see above. You even don't need any installed UDF. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=39483&edit=1