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

From: Operating system: Windows Server 2008 R2 x64 PHP version: 5.3.3 Package: PDO related Bug Type: Bug Bug description:PDO_MySQL does not respect type of binded params used more than once in query 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 bug report at http://bugs.php.net/bug.php?id=53184&edit=1 -- Try a snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=53184&r=trysnapshot52 Try a snapshot (PHP 5.3): http://bugs.php.net/fix.php?id=53184&r=trysnapshot53 Try a snapshot (trunk): http://bugs.php.net/fix.php?id=53184&r=trysnapshottrunk Fixed in SVN: http://bugs.php.net/fix.php?id=53184&r=fixed Fixed in SVN and need be documented: http://bugs.php.net/fix.php?id=53184&r=needdocs Fixed in release: http://bugs.php.net/fix.php?id=53184&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=53184&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=53184&r=needscript Try newer version: http://bugs.php.net/fix.php?id=53184&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=53184&r=support Expected behavior: http://bugs.php.net/fix.php?id=53184&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=53184&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=53184&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=53184&r=globals PHP 4 support discontinued: http://bugs.php.net/fix.php?id=53184&r=php4 Daylight Savings: http://bugs.php.net/fix.php?id=53184&r=dst IIS Stability: http://bugs.php.net/fix.php?id=53184&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=53184&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=53184&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=53184&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=53184&r=mysqlcfg