No used values suggested for list fields on Oracle

Steps to reproduce:

1. Create a new XClass by editing any document with the class editor.
2. Add a property "myList" of type "DBList"
3. For this property, enable "Multiple Select", "Relational Storage" and set "Display Type" to "input".
4. Save the XClass
5. Add an object of the class to any page using the object editor. Set two values "Option 1", "Option 2" and save the page.
6. Open the object editor on another page, add an object of the class and type "Option" in the myList input.

Expected result:

The previously set values "Option 1" and "Option 2" are suggested.

Actual result:

No values are suggested. In the network tab of the developer tools, a failed request is displayed with response

org.xwiki.query.QueryException: Exception while executing query. Query statement = [select listItem, str(listItem) as unfilterable1 from BaseObject as obj, DBStringListProperty as prop join prop.list listItem where obj.className = :className and obj.name <> :templateName and prop.id.id = obj.id and prop.id.name = :propertyName order by unfilterable1 desc]
ClassCastException: class java.lang.String cannot be cast to class java.lang.Long (java.lang.String and java.lang.Long are in module java.base of loader 'bootstrap')
 

When adding a Live Data for this class with 

{{liveData
  id="test"
  properties="doc.name,myList"
  limit="5"
  source="liveTable"
  sourceParameters="translationPrefix=&className=NestedLiveDataIT.filterWithRelationalDBList.WebHome"
}}{{/liveData}}

 
the same error can be observed when typing in the filter for "myList" as it triggers the same code.

The cast that is mentioned in the error is from https://github.com/xwiki/xwiki-platform/blob/b320aea672a8daa96226dde94300c973e56f5972/xwiki-platform-core/xwiki-platform-oldcore/src/main/java/com/xpn/xwiki/internal/objects/classes/UsedValuesListQueryBuilder.java#L83 which is triggered because the second value is no count anymore since XWIKI-23019. I've reverted the change of that issue and then the values were suggested as expected.

For XWIKI-23727 I'm adding an integration test that reproduces the scenario with Live Data.