So turns out the regression was actually introduced triggered by https://github.com/xwiki/xwiki-platform/commit/5c11a874bd24a581f534d283186e209bbccd8113.
The root cause actually been introduced by XWIKI-12355 in which the implementation of HqlQueryUtils#isShortFormStatement is not accurate (i.e. it considers any statement starting with "from" as a short form statement, which is not true).
Thomas Mortagne on 18/Mar/25 14:24
So turns out the regression was actually triggered by https://github.com/xwiki/xwiki-platform/commit/5c11a874bd24a581f534d283186e209bbccd8113#diff-a1da19f70f72feebf68dd54b03a522b3b472f40438545c590529c3f7bdf227c8L336-R355.
The root cause actually been introduced by XWIKI-12355 in which the implementation of HqlQueryUtils#isShortFormStatement is not accurate (i.e. it considers any statement starting with "from" as a short form statement, which is not true).
This message was sent by Atlassian Jira (v9.3.0#930000-sha1:287aeb6)
If image attachments aren't displayed, see this article.