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

From: Date: Fri, 26 Nov 2010 12:22:27 +0000
Subject: Bug #53184 [Opn]: PDO_MySQL does not respect type of binded params used more than once in query
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-156482@lists.php.net to get a copy of this message 
Edit report at http://bugs.php.net/bug.php?id=53184&edit=1

 ID:                 53184
 Updated by:         johannes@php.net
 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:

This either needs an API change with myslqnd or changes to PDO to use
the "new" error mode settings.


Previous Comments:
------------------------------------------------------------------------
[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 http://bugs.php.net/bug.php?id=53184&edit=1

Thread (6 messages)

« previous php.bugs (#156482) next »