php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #53184 PDO_MySQL does not respect type of binded params used more than once in query
Submitted: 2010-10-27 17:02 UTC Modified: 2014-01-01 12:47 UTC
Votes:1
Avg. Score:5.0 ± 0.0
Reproduced:1 of 1 (100.0%)
Same Version:1 (100.0%)
Same OS:0 (0.0%)
From: an0nym at narod dot ru Assigned:
Status: Open Package: PDO MySQL
PHP Version: 5.3.3 OS: Windows Server 2008 R2 x64
Private report: No CVE-ID:
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: an0nym at narod dot ru
New email:
PHP Version: OS:

 

 [2010-10-27 17:02 UTC] 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. 

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2010-11-26 13:22 UTC] johannes@php.net
This either needs an API change with myslqnd or changes to PDO to use the "new" error mode settings.
 [2011-09-23 18:18 UTC] 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.
 [2011-09-23 18:24 UTC] morrison dot levi at gmail dot com
I meant bug https://bugs.php.net/bug.php?id=48856.  My apologies.
 [2014-01-01 12:47 UTC] felipe@php.net
-Package: PDO related +Package: PDO MySQL
 
PHP Copyright © 2001-2017 The PHP Group
All rights reserved.
Last updated: Fri Jul 28 18:01:37 2017 UTC