Edit report at https://bugs.php.net/bug.php?id=62593&edit=1
ID: 62593 Comment by: willfi...@php.net Reported by: mascione at sviluppo dot toscana dot it Summary: Emulate prepares behave strangely with PARAM_BOOL Status: Assigned Type: Bug Package: PDO related Operating System: Ubuntu 10.04 PHP Version: 5.3.14 Assigned To: willfitch Block user comment: N Private report: N New Comment: I have confirmed this. The issue with disabling emulation prepares for this purpose is that it sends the query through PQprepare, then PQexec. If you're using middleware such as pgbouncer, this won't work. Previous Comments: ------------------------------------------------------------------------ [2012-07-19 06:15:02] ploginoff at gmail dot com Yes! _Yesterday_ I have * with the same bug. Solution: install 5.3.13 or disable emulate prepares (but it is sometimes necessary). ------------------------------------------------------------------------ [2012-07-18 10:04:51] mascione at sviluppo dot toscana dot it Description: ------------ On postgresql when I use ATTR_EMULATE_PREPARES binding params or values with PARAM_BOOL behave strangely. Disabling ATTR_EMULATE_PREPARES resolve the problem. (driver specific PGSQL_ATTR_DISABLE_NATIVE_PREPARED_STATEMENT generates same problem) (Related to bug #38386 ?) Test script: --------------- $db = new PDO('pgsql:dbname=testdb;user=postgres'); $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, true); //$db->setAttribute(PDO::PGSQL_ATTR_DISABLE_NATIVE_PREPARED_STATEMENT, true); //CREATE TABLE t(a boolean, b boolean) $stmt = $db->prepare("INSERT INTO t(a,b) VALUES (true,false)"); $stmt->execute(); print_r($stmt->errorInfo()); $stmt = $db->prepare("INSERT INTO t(a,b) VALUES (:test,:test)"); $stmt->bindValue('test', false, PDO::PARAM_BOOL); $stmt->execute(); print_r($stmt->errorInfo()); $stmt = $db->prepare("SELECT * FROM t WHERE :test"); $stmt->bindValue('test', true, PDO::PARAM_BOOL); $stmt->execute(); print_r($stmt->errorInfo()); print_r($stmt->fetchAll()); Expected result: ---------------- Works without errors. Actual result: -------------- Array ( [0] => 00000 [1] => [2] => ) Array ( [0] => 42804 [1] => 7 [2] => ERROR: column "a" is of type boolean but expression is of type integer LINE 1: INSERT INTO t(a,b) VALUES (0,'0') ^ HINT: You will need to rewrite or cast the expression. ) Array ( [0] => 42804 [1] => 7 [2] => ERROR: argument of WHERE must be type boolean, not type integer LINE 1: SELECT * FROM t WHERE 1 ^ ) ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=62593&edit=1