Actions
Bug #24772
closed
Live search is unusable with Oracle
Start date:
2011-01-24
Due date:
% Done:
0%
Estimated time:
TYPO3 Version:
4.5
PHP Version:
5.2
Tags:
Complexity:
Is Regression:
Sprint Focus:
Description
Live search issues a query with all fields from a table but takes care of removing integer columns. However, when running as admin, uid and pid are added to the list of fields and those columns are integer.
The underlying generated search query uses a LIKE for each and every column. This is invalid for Oracle as a number column cannot be used with LIKE as it is possible with MySQL. Furthermore, it does not make sense to search in such columns for some textual content the user may have entered.
(issue imported from #M17267)
Files
Updated by
Actions