There is 1 comment.
 
 
XWiki Platform / cid:jira-generated-image-avatar-e9fc5329-7375-4f89-a96b-d269966b89a7 XWIKI-22605 Open

Solr re-indexes many documents after restarting on PostgreSQL

 
View issue   ยท   Add comment
 

1 comment

 
cid:jira-generated-image-avatar-eb80d0fb-9d07-4e59-9ec1-2c2c53e2a56c Michael Hamann on 25/Oct/24 18:03
 

I've added some integration tests to verify that everything works. Some new results:

  1. In Postgres 17, the "builtin" locale provider seems to be the best option with locale "C.UTF-8" as it provides the same sorting as Solr and supports uppercase/lowercase transformations for Unicode characters while being independent of the OS, see https://postgresql.verite.pro/blog/2024/07/01/pg17-utf8-collation.html for some context. In Postgres 16 and earlier, the "builtin" provider doesn't exist. The locale "C.utf8" seems to be the next best option whose behavior is quite similar but which depends on the system.
  2. The Oracle database seems to have the same problem. Further, Oracle doesn't even correctly handle lower/upercase conversion with non-ASCII character. I haven't yet found out how to configure the Oracle database to fix this.