Public bug reported:
if you have SQL like
SELECT * FROM (SELECT * FROM table WHERE <first condtion>) as t WHERE
<second codintion>
to count this sql it transform it to
SELECT count(*) FROM (SELECT count(*) FROM table WHERE <first condtion>)
as t WHERE <second codintion>
For OCAL I modify the old widget.php file to search for /^
*SELECT(.*)FROM/ only at the begining and use different fileds in inner
and outer Query (I put all fields that are needed in outer query)
In this old AIKI there was str_replace which replace all occurance of
the string so if there is two asterisks it replace them both and I can
use preg_replace because asterisk is special character in RegEx.
** Affects: aikiframework
Importance: Undecided
Status: New
--
You received this bug notification because you are a member of Aiki
Framework Admins, which is subscribed to aikiframework.
https://bugs.launchpad.net/bugs/899194
Title:
Aiki bad count nested SELECT for pagination
Status in Aiki Framework:
New
Bug description:
if you have SQL like
SELECT * FROM (SELECT * FROM table WHERE <first condtion>) as t WHERE
<second codintion>
to count this sql it transform it to
SELECT count(*) FROM (SELECT count(*) FROM table WHERE <first
condtion>) as t WHERE <second codintion>
For OCAL I modify the old widget.php file to search for /^
*SELECT(.*)FROM/ only at the begining and use different fileds in
inner and outer Query (I put all fields that are needed in outer
query)
In this old AIKI there was str_replace which replace all occurance of
the string so if there is two asterisks it replace them both and I can
use preg_replace because asterisk is special character in RegEx.
To manage notifications about this bug go to:
https://bugs.launchpad.net/aikiframework/+bug/899194/+subscriptions
_______________________________________________
Mailing list: https://launchpad.net/~aikiframework.admins
Post to : [email protected]
Unsubscribe : https://launchpad.net/~aikiframework.admins
More help : https://help.launchpad.net/ListHelp
