Details
Description
Reproduction steps:
- Create several users on a wiki
- Create a new app within minutes
- Insert a user field and edit it to allow multiple users
- Create a new entry in that new app
- Type some characters (e.g. "foo") in the suggester for users
Expected result:
- the suggester should provide users matching what is typed
Obtained result:
- only a subset of users is displayed when focusing on the suggester, typing values in it doesn't refresh the values. When checking the requests, a 500 error appears for the values requested and the body contains following error:
org.xwiki.query.QueryException: Exception while executing query. Query statement = [select prop.textValue, count(*) as unfilterable0 from BaseObject as obj, StringListProperty as prop where obj.className = :className and obj.name <> :templateName and prop.id.id = obj.id and prop.id.name = :propertyName group by prop.textValue order by count(*) desc] OracleDatabaseException: ORA-00932: inconsistent datatypes: expected - got CLOB