Bug #24772

Live search is unusable with Oracle

Added by Xavier Perseguers about 9 years ago. Updated about 9 years ago.

Status:
Closed
Priority:
Must have
Category:
-
Target version:
-
Start date:
2011-01-24
Due date:
% Done:

0%

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)

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


Related issues

Related to TYPO3 Core - Feature #24092: Add live search to the backend toolbar Closed 2010-11-17

History

#1 Updated by Xavier Perseguers about 9 years ago

Committed to trunk (rev 10280).

Also available in: Atom PDF