Issue Bug Closed

#24772Live search is unusable with Oracle

Xavier Perseguers 01/24/11, 14:54 updated 02/11/11, 11:03

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)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.