This issue has been created
There is 1 update.
 
 
XWiki Platform / cid:jira-generated-image-avatar-2a21a8b4-b802-4f68-8919-c5b1c29cda4b XWIKI-23019 Open

Oracle inconsistent datatypes error when using user suggest for multiple users

 
View issue   ยท   Add comment
 

Issue created

 
cid:jira-generated-image-avatar-435e9ff3-d6e0-4a13-9caa-dfc0a97d08fa Simon Urli created this issue on 25/Mar/25 11:21
 
Summary: Oracle inconsistent datatypes error when using user suggest for multiple users
Issue Type: cid:jira-generated-image-avatar-2a21a8b4-b802-4f68-8919-c5b1c29cda4b Bug
Affects Versions: 16.10.5
Assignee: Unassigned
Components: Web - Templates & Resources
Created: 25/Mar/25 11:21
Labels: oracle
Priority: cid:jira-generated-image-static-major-dfa11beb-a114-4230-af6f-c272d29084af Major
Reporter: Simon Urli
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
    
 
 

1 update

 
cid:jira-generated-image-avatar-435e9ff3-d6e0-4a13-9caa-dfc0a97d08fa Changes by Simon Urli on 25/Mar/25 11:21
 
Assignee: Simon Urli