Edit report at https://bugs.php.net/bug.php?id=48856&edit=1
ID: 48856
Updated by: [email protected]
Reported by: dhammari at q90 dot com
Summary: emulated prepared statements allow multiple
parameters of the same name
-Status: Open
+Status: Closed
-Type: Bug
+Type: Documentation Problem
Package: PDO related
Operating System: Linux 2.6.27-gentoo-r8
PHP Version: 5.2.10
-Assigned To:
+Assigned To: cmb
Block user comment: N
Private report: N
New Comment:
> You're allowed to reuse parameters with emulated prepares. I
> believe that's specifically what's being called out here. The
> easiest thing to do, honestly, would be to update the
> documentation to that end.
I aggre. The documentation now says[1]:
| You cannot use a named parameter marker of the same name more
| than once in a prepared statement, unless emulation mode is on.
So this is resolved. See also feature request #76647 regarding
implementation improvements.
[1] <https://www.php.net/manual/en/pdo.prepare.php>
Previous Comments:
------------------------------------------------------------------------
[2021-09-28 10:41:09] [email protected]
Related To: Bug #69257
------------------------------------------------------------------------
[2017-10-24 18:51:48] [email protected]
You're allowed to reuse parameters with emulated prepares. I believe that's specifically what's being called out here. The easiest thing to do, honestly, would be to update the documentation to that end. Otherwise, this would have be changed for the next minor rev since it would technically be a BC break. Other drivers have built-in inflexibility here, so I wouldn't suggest making any other changes.
Moving this to PDO Core since that's where the emulation code lives.
------------------------------------------------------------------------
[2015-09-26 01:33:33] a791446794 at 163 dot com
I want this feature too!
When sql has subquey with the same condition,it is fairly that use the same :token will be maintainable and efficient.
------------------------------------------------------------------------
[2009-11-16 13:42:59] [email protected]
I've referred this bug to the PDO discussion list, as there are ongoing discussions about the future design of PDO and this bug seems to be pertinent to that discussion.
------------------------------------------------------------------------
[2009-09-24 02:59:16] [email protected]
Yes, it was a limitation back then - and while it might work for some PDO drivers, I believe the problem was that it was not guaranteed to work with all PDO drivers - and therefore discouraged. It would be best for us to talk to a current PDO developer to get the real deal on the current situation.
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
https://bugs.php.net/bug.php?id=48856
--
Edit this bug report at https://bugs.php.net/bug.php?id=48856&edit=1
lmpx.com only provides a reader for public news (NNTP) servers. It is not
affiliated with the servers or forums shown here and is not responsible for
the content of articles, which is written by their respective authors.