Bug #53960 [Bgs]: Invalid parameter number for multiple params equals in query
Edit report at http://bugs.php.net/bug.php?id=53960edit=1
ID: 53960
User updated by:contato at andersonfraga dot net
Reported by:contato at andersonfraga dot net
Summary:Invalid parameter number for multiple params
equals in query
Status: Bogus
Type: Bug
Package:PDO related
Operating System: Windows
PHP Version:5.3.5
Block user comment: N
Private report: N
New Comment:
Okay then...
Could put some 'warning' in the doc? Please ... ;)
Previous Comments:
[2011-05-11 11:05:37] johan...@php.net
The old behavior is clearly wrong. You have explicit names and they are
ignored
[2011-05-10 17:58:00] contato at andersonfraga dot net
Anyway...
I think it should work, right?
'Even more because' it works in 5.2.14..
[2011-05-10 10:03:11] u...@php.net
SQL - 2x hash_1:
AND (NOME_CLIENTE LIKE :hash_1
OR ENDERECO_CLIENTE LIKE :hash_1)
PHP bind - 1x hash_1, 1x hash_2:
$statement-execute(Array(
':hash_1' = '%Anderson%',
':hash_2' = 0,
[2011-02-08 17:27:49] contato at andersonfraga dot net
Description:
This error is occurring when I use the same parameter several times in
the query.
In PHP 5.2.14, using Gentoo, it works perfectly. Already in versions
5.3.0 and 5.3.3 (using Windows on both), returns an exception.
Bug or 'feature'?
Test script:
---
?php
try {
$dbh = new PDO('mysql:/*irrelevant*/', Array(
PDO::ATTR_ERRMODE = PDO::ERRMODE_EXCEPTION,
PDO::ATTR_EMULATE_PREPARES = false,
));
$select = SELECT * FROM PR_CLIENTE
WHERE DELETADO = 'N'
AND (NOME_CLIENTE LIKE :hash_1
OR ENDERECO_CLIENTE LIKE :hash_1)
ORDER BY ID_CLIENTE DESC
LIMIT :hash_2;;
$statement = $dbh-prepare($select);
$statement-execute(Array(
':hash_1' = '%Anderson%',
':hash_2' = 0,
));
$fetch = $statement-fetchAll(PDO::FETCH_ASSOC);
print_r($fetch);
}
catch(PDOException $e) {
print_r($e-getMessage());
}
?
Expected result:
Array
(
[0] = Array
(
[ID_CLIENTE] = 29
(...)
)
)
Actual result:
--
SQLSTATE[HY093]: Invalid parameter number
--
Edit this bug report at http://bugs.php.net/bug.php?id=53960edit=1
Bug #53960 [Bgs]: Invalid parameter number for multiple params equals in query
Edit report at http://bugs.php.net/bug.php?id=53960edit=1
ID: 53960
User updated by:contato at andersonfraga dot net
Reported by:contato at andersonfraga dot net
Summary:Invalid parameter number for multiple params
equals in query
Status: Bogus
Type: Bug
Package:PDO related
Operating System: Windows
PHP Version:5.3.5
Block user comment: N
Private report: N
New Comment:
Anyway...
I think it should work, right?
'Even more because' it works in 5.2.14..
Previous Comments:
[2011-05-10 10:03:11] u...@php.net
SQL - 2x hash_1:
AND (NOME_CLIENTE LIKE :hash_1
OR ENDERECO_CLIENTE LIKE :hash_1)
PHP bind - 1x hash_1, 1x hash_2:
$statement-execute(Array(
':hash_1' = '%Anderson%',
':hash_2' = 0,
[2011-02-08 17:27:49] contato at andersonfraga dot net
Description:
This error is occurring when I use the same parameter several times in
the query.
In PHP 5.2.14, using Gentoo, it works perfectly. Already in versions
5.3.0 and 5.3.3 (using Windows on both), returns an exception.
Bug or 'feature'?
Test script:
---
?php
try {
$dbh = new PDO('mysql:/*irrelevant*/', Array(
PDO::ATTR_ERRMODE = PDO::ERRMODE_EXCEPTION,
PDO::ATTR_EMULATE_PREPARES = false,
));
$select = SELECT * FROM PR_CLIENTE
WHERE DELETADO = 'N'
AND (NOME_CLIENTE LIKE :hash_1
OR ENDERECO_CLIENTE LIKE :hash_1)
ORDER BY ID_CLIENTE DESC
LIMIT :hash_2;;
$statement = $dbh-prepare($select);
$statement-execute(Array(
':hash_1' = '%Anderson%',
':hash_2' = 0,
));
$fetch = $statement-fetchAll(PDO::FETCH_ASSOC);
print_r($fetch);
}
catch(PDOException $e) {
print_r($e-getMessage());
}
?
Expected result:
Array
(
[0] = Array
(
[ID_CLIENTE] = 29
(...)
)
)
Actual result:
--
SQLSTATE[HY093]: Invalid parameter number
--
Edit this bug report at http://bugs.php.net/bug.php?id=53960edit=1
[PHP-BUG] Bug #53960 [NEW]: Invalid parameter number for multiple params equals in query
From:
Operating system: Windows
PHP version: 5.3.5
Package: PDO related
Bug Type: Bug
Bug description:Invalid parameter number for multiple params equals in query
Description:
This error is occurring when I use the same parameter several times in the
query.
In PHP 5.2.14, using Gentoo, it works perfectly. Already in versions 5.3.0
and 5.3.3 (using Windows on both), returns an exception.
Bug or 'feature'?
Test script:
---
?php
try {
$dbh = new PDO('mysql:/*irrelevant*/', Array(
PDO::ATTR_ERRMODE = PDO::ERRMODE_EXCEPTION,
PDO::ATTR_EMULATE_PREPARES = false,
));
$select = SELECT * FROM PR_CLIENTE
WHERE DELETADO = 'N'
AND (NOME_CLIENTE LIKE :hash_1
OR ENDERECO_CLIENTE LIKE :hash_1)
ORDER BY ID_CLIENTE DESC
LIMIT :hash_2;;
$statement = $dbh-prepare($select);
$statement-execute(Array(
':hash_1' = '%Anderson%',
':hash_2' = 0,
));
$fetch = $statement-fetchAll(PDO::FETCH_ASSOC);
print_r($fetch);
}
catch(PDOException $e) {
print_r($e-getMessage());
}
?
Expected result:
Array
(
[0] = Array
(
[ID_CLIENTE] = 29
(...)
)
)
Actual result:
--
SQLSTATE[HY093]: Invalid parameter number
--
Edit bug report at http://bugs.php.net/bug.php?id=53960edit=1
--
Try a snapshot (PHP 5.2):
http://bugs.php.net/fix.php?id=53960r=trysnapshot52
Try a snapshot (PHP 5.3):
http://bugs.php.net/fix.php?id=53960r=trysnapshot53
Try a snapshot (trunk):
http://bugs.php.net/fix.php?id=53960r=trysnapshottrunk
Fixed in SVN:
http://bugs.php.net/fix.php?id=53960r=fixed
Fixed in SVN and need be documented:
http://bugs.php.net/fix.php?id=53960r=needdocs
Fixed in release:
http://bugs.php.net/fix.php?id=53960r=alreadyfixed
Need backtrace:
http://bugs.php.net/fix.php?id=53960r=needtrace
Need Reproduce Script:
http://bugs.php.net/fix.php?id=53960r=needscript
Try newer version:
http://bugs.php.net/fix.php?id=53960r=oldversion
Not developer issue:
http://bugs.php.net/fix.php?id=53960r=support
Expected behavior:
http://bugs.php.net/fix.php?id=53960r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=53960r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=53960r=submittedtwice
register_globals:
http://bugs.php.net/fix.php?id=53960r=globals
PHP 4 support discontinued: http://bugs.php.net/fix.php?id=53960r=php4
Daylight Savings:http://bugs.php.net/fix.php?id=53960r=dst
IIS Stability:
http://bugs.php.net/fix.php?id=53960r=isapi
Install GNU Sed:
http://bugs.php.net/fix.php?id=53960r=gnused
Floating point limitations:
http://bugs.php.net/fix.php?id=53960r=float
No Zend Extensions:
http://bugs.php.net/fix.php?id=53960r=nozend
MySQL Configuration Error:
http://bugs.php.net/fix.php?id=53960r=mysqlcfg
Bug #53327 [Bgs]: Determine parameter names in ReflectionMethod::invokeArgs
Edit report at http://bugs.php.net/bug.php?id=53327edit=1 ID: 53327 User updated by:contato at andersonfraga dot net Reported by:contato at andersonfraga dot net Summary:Determine parameter names in ReflectionMethod::invokeArgs Status: Bogus Type: Bug Package:Reflection related Operating System: Windows 7, Ubuntu 10.10, Gentoo PHP Version:Irrelevant Block user comment: N Private report: N New Comment: I think this would be a nice feature... Thank you Felipe. Previous Comments: [2010-11-17 21:54:59] fel...@php.net This is an expected behavior, there is no nothing special with argument names in Reflection. [2010-11-17 02:08:57] contato at andersonfraga dot net Description: I would like to use the names of parameters to execute methods with specific arguments. But invokeArgs not correctly sends the names with those on the method. I think this result is not correct. It should not obey the parameter names? Test script: --- http://pastebin.com/fuF4tWGq Expected result: arg1: orange arg2: apple arg3: -- and also report a warning because of missing arg3, i.e. Actual result: -- arg1: orange arg2: apple arg3: bad error -- Edit this bug report at http://bugs.php.net/bug.php?id=53327edit=1
[PHP-BUG] Bug #53327 [NEW]: Determine parameter names in ReflectionMethod::invokeArgs
From: Operating system: Windows 7, Ubuntu 10.10, Gentoo PHP version: Irrelevant Package: Reflection related Bug Type: Bug Bug description:Determine parameter names in ReflectionMethod::invokeArgs Description: I would like to use the names of parameters to execute methods with specific arguments. But invokeArgs not correctly sends the names with those on the method. I think this result is not correct. It should not obey the parameter names? Test script: --- http://pastebin.com/fuF4tWGq Expected result: arg1: orange arg2: apple arg3: -- and also report a warning because of missing arg3, i.e. Actual result: -- arg1: orange arg2: apple arg3: bad error -- Edit bug report at http://bugs.php.net/bug.php?id=53327edit=1 -- Try a snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=53327r=trysnapshot52 Try a snapshot (PHP 5.3): http://bugs.php.net/fix.php?id=53327r=trysnapshot53 Try a snapshot (trunk): http://bugs.php.net/fix.php?id=53327r=trysnapshottrunk Fixed in SVN: http://bugs.php.net/fix.php?id=53327r=fixed Fixed in SVN and need be documented: http://bugs.php.net/fix.php?id=53327r=needdocs Fixed in release: http://bugs.php.net/fix.php?id=53327r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=53327r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=53327r=needscript Try newer version: http://bugs.php.net/fix.php?id=53327r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=53327r=support Expected behavior: http://bugs.php.net/fix.php?id=53327r=notwrong Not enough info: http://bugs.php.net/fix.php?id=53327r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=53327r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=53327r=globals PHP 4 support discontinued: http://bugs.php.net/fix.php?id=53327r=php4 Daylight Savings:http://bugs.php.net/fix.php?id=53327r=dst IIS Stability: http://bugs.php.net/fix.php?id=53327r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=53327r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=53327r=float No Zend Extensions: http://bugs.php.net/fix.php?id=53327r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=53327r=mysqlcfg
