Sorting doesn't work on Oracle Database

[ilieandriuta]

Please see the following JIRA issue.

[petrenkonikita112263]

AFAIU, this is the issue for livetable on XWiki with Oracle DB. Still, in this app, the livetable doesn't have the same columns used to reproduce the bug (Short Text Field, a User Field, and a Group Field). The Ideas app didn't fit the requirements to reproduce an issue.

[oanalavinia]

The app has the Assignee field, which is the one that should be used for reproducing the issue if you look at the Ideas specific jira ticket https://jira.xwiki.org/browse/IDEAS-69 (it was closed just because a general one was created)

[petrenkonikita112263]

Okay, then next from this , the version is used 8.4.5, and as I assume, same for the main issue. Oh, it doesn't matter; only configure oracle to 11.10 instead of hsqldb to see this issue.

[oanalavinia]

8.4 was the minimal supported version at that time, so this is why ideas was tested with this version. But the main issue is still open, so the ideas specific bug should still reproduce until the latest version of XWiki.
It should be enough just to confirm that it still reproduces on 11.10 for the Assignee field.