[TYPO3-core] RFC #17267: Live search is unusable with Oracle

[Xavier Perseguers]

Hi,

This is an SVN patch request.

Type: Bugfix

BT reference: http://bugs.typo3.org/view.php?id=17267

Branches: trunk

Problem:
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.

Cheers
Xavier
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 17267.diff
Type: text/x-diff
Size: 1788 bytes
Desc: not available
URL: <http://lists.typo3.org/pipermail/typo3-team-core/attachments/20110124/8318ad11/attachment.diff>