Bug #53184 [Com]: PDO_MySQL does not respect type of binded params used more than once in query

Edit report at https://bugs.php.net/bug.php?id=53184&edit=1 ID: 53184 Comment by: morrison dot levi at gmail dot com Reported by: an0nym at narod dot ru Summary: PDO_MySQL does not respect type of binded params used more than once in query Status: Open Type: Bug Package: PDO related Operating System: Windows Server 2008 R2 x64 PHP Version: 5.3.3 Block user comment: N Private report: N New Comment: I meant bug https://bugs.php.net/bug.php?id=48856. My apologies. Previous Comments: ------------------------------------------------------------------------ [2011-09-23 18:18:53] morrison dot levi at gmail dot com See bug https://bugs.php.net/bug.php?id=47615 . You shouldn't* be using a parameter more than once. ------------------------------------------------------------------------ [2010-11-26 13:22:26] johannes@php.net This either needs an API change with myslqnd or changes to PDO to use the "new" error mode settings. ------------------------------------------------------------------------ [2010-10-27 17:02:52] an0nym at narod dot ru Description: ------------ PDO_MySQL does not respect type of binded params that are used more than once in query. Test script: --------------- <?php $DB = new PDO("mysql:host=localhost", "root", ""); $statement = $DB->prepare("SELECT SLEEP(50), :bind, :bind"); $bind = 1; $statement->bindParam(":bind", $bind, PDO::PARAM_INT); $statement->execute(); Expected result: ---------------- SELECT SLEEP(50), 1, 1 Actual result: -------------- If you review SHOW PROCESSLIST while test script is waiting for response, you'll see SELECT SLEEP(50), 1, '1' instead of expected result. ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=53184&edit=1