Actions
Bug #41641
closed
t3lib_db StripOrderBy, stripGroupBy fails if clause is misspelled or appears twice.
Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2012-10-06
Due date:
% Done:
100%
Estimated time:
TYPO3 Version:
4.7
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:
Description
If ORDER BY or GROUP BY clauses are misspelled or appear twice in the given string. This fails.
Change the expression to be more tolerant and capable to clean, strip the related clauses efficiently.
It could allows to strip that kind of string:
ORDER BY name, tstamp DESC ORDER BY name, tstamp DESC ORDERBY name, tstamp DESC ORDER BY ORDER BY name, tstamp DESC ORDERBY ORDER BY name, tstamp DESC ORDER BYORDERBY name, tstamp DESC ORDERBYORDERBY name, tstamp DESC ORDERBYORDERBYname, tstamp DESC ORDERBYORDERBY ORDER BY name, tstamp DESC etc..
Updated by 
Updated by 
Updated by
Actions