Bug #24772

Live search is unusable with Oracle

Added by Xavier Perseguers over 10 years ago. Updated over 10 years ago.

Status:
Closed
Priority:
Must have
Category:
-
Target version:
-
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

17267.diff (1.75 KB) 17267.diff Administrator Admin, 2011-01-24 14:55

Related issues

Related to TYPO3 Core - Feature #24092: Add live search to the backend toolbarClosedJeff Segars2010-11-17

Actions
#1

Updated by Xavier Perseguers over 10 years ago

Committed to trunk (rev 10280).

Also available in: Atom PDF