#34414 [Bgs]: PDO_MYSQL: parameter in INSERT gives syntax error

ID: 34414 User updated by: Roland dot Bouman at interaccess dot nl Reported By: Roland dot Bouman at interaccess dot nl Status: Bogus Bug Type: PDO related Operating System: Win XP Professional SP2 PHP Version: 5.1.0RC1 New Comment: sniper, I don't want to bother you with duplicates, so sorry for the inconvenience. However, I can't seem to find the bug report you are referring to. (I searched all PDO-related bug reports). Could you give me a pointer? BTW, I posted 5.1.0RC1 as the version, but I did use the (then) latest snapshot: php5.1-win32-200509071830 Previous Comments: ------------------------------------------------------------------------ [2005-09-07 23:44:28] sniper@php.net Please do not submit the same bug more than once. An existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely to be the same. Thank you for your interest in PHP. ------------------------------------------------------------------------ [2005-09-07 22:40:02] Roland dot Bouman at interaccess dot nl Sorry, the last line of my reproduce code should read: print_r($ins->errorInfo()); //generate output not: print_r($ins->errorInfo()); --generate output ------------------------------------------------------------------------ [2005-09-07 22:37:29] Roland dot Bouman at interaccess dot nl Description: ------------ A PDO_MYSQL prepared INSERT statement fails to execute. The driver specific error message reports the value of the variable bound to the parameter as an unknown column. The error message suggests that the actual statement sent to mysql contains a syntax error because of some flaw in the way the parameter value is put into the sql statement No such behaviour is observed in a prepared SELECT statement. An equivalent INSERT statement with the quoted parametervalues hardcoded into the insert does execute as expected. Reproduce code: --------------- <?php $pdo = new PDO('mysql:host','usr','pwd'); $pdo->query('use test'); $pdo->exec('create table tmp( id int auto_increment primary key , flag enum(\'TRUE\',\'FALSE\') , name varchar(10))'); $ins = $pdo->prepare('insert into test.tmp( flag , name) values ( :flag , :name)'); $ins->bindParam(':flag',$flag,PDO_PARAM_STR); $ins->bindParam(':name',$name,PDO_PARAM_STR,20); $flag = 'TRUE'; $name = 'some name'; $ins->execute(); print_r($ins->errorInfo()); --generate output ?> Expected result: ---------------- Array ( [0] => ) or Array ( [0] => 00000 ) indicating successfull execution of the statement at the MySQL server. Actual result: -------------- Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'TRUE' in 'field list' ) ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=34414&edit=1