MDB2_Driver_mysqli Bug #10895http://pear.php.net/bugs/10895
[Closed] setLimit() does not work properly when a subquery uses LIMITen-uspear-webmaster@lists.php.netpear-webmaster@lists.php.nethourly12000-01-01T12:00+00:00

setLimit() does not work properly when a subquery uses LIMITDescription:
------------
Queries with a subselect that use a LIMIT statement will not be modified correctly when using setLimit().
In a SQL statment like:
SELECT a, (SELECT dateOther FROM T1 ORDER BY date DESC LIMIT 1) FROM T2;
The preg_match in _modifyQuery matches the first LIMIT and will not append another one.aldo
aldohttp://pear.php.net/bugs/10895
MDB2_Driver_mysqli Bug
Reported by aldo
2007-04-30T13:18:08+00:00
PHP: 5.2.1 OS: Any Package Version: 1.4.0
Description:
------------
Queries with a subselect that use a LIMIT statement will not be modified correctly when using setLimit().
In a SQL statment like:
SELECT a, (SELECT dateOther FROM T1 ORDER BY date DESC LIMIT 1) FROM T2;
The preg_match in _modifyQuery matches the first LIMIT and will not append another one.]]>MDB2_Driver_mysqli Bug
Reported by aldo
2007-04-30T13:18:08+00:00
PHP: 5.2.1 OS: Any Package Version: 1.4.0
Description:
------------
Queries with a subselect that use a LIMIT statement will not be modified correctly when using setLimit().
In a SQL statment like:
SELECT a, (SELECT dateOther FROM T1 ORDER BY date DESC LIMIT 1) FROM T2;
The preg_match in _modifyQuery matches the first LIMIT and will not append another one.]]>2007-04-30T13:18:08+00:00
aldo [2007-05-02 19:37] http://pear.php.net/bugs/10895#1178134633
I have tested CVS and the check for the closing parenthesis is effective. It is correctly working for subqueries and statements that end in a LIMIT. Thank you.]]>I have tested CVS and the check for the closing parenthesis is effective. It is correctly working for subqueries and statements that end in a LIMIT. Thank you.]]>2007-05-02T19:37:13+00:00
quipo [2007-05-02 17:01] http://pear.php.net/bugs/10895#1178125304
This bug has been fixed in CVS.
If this was a documentation problem, the fix will appear on pear.php.net by the end of next Sunday (CET).
If this was a problem with the pear.php.net website, the change should be live shortly.
Otherwise, the fix will appear in the package's next release.
Thank you for the report and for helping us make PEAR better.
--
Can you test the current CVS version and send me some feedback, please? TIA]]>This bug has been fixed in CVS.
If this was a documentation problem, the fix will appear on pear.php.net by the end of next Sunday (CET).
If this was a problem with the pear.php.net website, the change should be live shortly.
Otherwise, the fix will appear in the package's next release.
Thank you for the report and for helping us make PEAR better.
--
Can you test the current CVS version and send me some feedback, please? TIA]]>2007-05-02T17:01:44+00:00