Uploaded image for project: 'XWiki Platform'
  1. XWiki Platform
  2. XWIKI-23019

Oracle inconsistent datatypes error when using user suggest for multiple users

    XMLWordPrintable

Details

    • Unit, Integration
    • Unknown
    • N/A
    • N/A

    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
        

      Attachments

        Activity

          People

            surli Simon Urli
            surli Simon Urli
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: