#48971 International Collation Ordered Searches currently broken.
Closed: wontfix by spichugi. Opened by nhosoi.

Sample filters.

"(uid:2.16.840.1.113730.3.3.2.15.1:=>AAA)"
"(uid:es:=>AAA)"
"(uid:2.16.840.1.113730.3.3.2.15.1.5:=AAA)"
"(uid:es.5:=AAA)"
"(uid:2.16.840.1.113730.3.3.2.15.1:=>user100)"
"(uid:es:=>user100)"
"(uid:2.16.840.1.113730.3.3.2.15.1.5:=user100)"
"(uid:es.5:=user100)"
"(uid:2.16.840.1.113730.3.3.2.15.1:=<1)"
"(uid:es:=<1)"
"(uid:2.16.840.1.113730.3.3.2.15.1.1:=1)"
"(uid:es.1:=1)"
"(uid:2.16.840.1.113730.3.3.2.15.1:=<user1)"
"(uid:es:=<user1)"
"(uid:2.16.840.1.113730.3.3.2.15.1.1:=user1)"
"(uid:es.1:=user1)"
"(uid:2.16.840.1.113730.3.3.2.15.1:=<z)"
"(uid:es:=<z)"
"(uid:2.16.840.1.113730.3.3.2.15.1.1:=z)"
"(uid:es.1:=z)"

Note: the attribute title is indexed with matching rule 2.16.840.1.113730.3.3.2.28.1.6.
$ ldapsearch [...] '(title:2.16.840.1.113730.3.3.2.15.1.6:=CEO)' title
dn: uid=ntest,ou=People,dc=example,dc=com
title: CEO

But both searches with the filter '(title:2.16.840.1.113730.3.3.2.28.1.6:=>=CEO)' and '(title:2.16.840.1.113730.3.3.2.28.1.6:=<=CEO)' return none.

Access log:

SRCH base="dc=example,dc=com" scope=2 filter="(title:2.16.840.1.113730.3.3.2.28.1.6:=<=CEO)" attrs="title"
RESULT err=0 tag=101 nentries=0 etime=0

At least, the index is being used and nothing is found.


Found some working cases.
{{{
Using C.4.3.4. Greater-Than or Equal-to Example.
(The other operations share the same symptom).
locality:2.16.840.1.113730.3.3.2.18.1:=>= Québec
Returns nothing. Not working.

locality:fr:=>= Québec
Returns nothing. Not working.

locality:2.16.840.1.113730.3.3.2.18.1.4:=Québec
Returns expected results. Working.

locality:fr.4:=Québec
Although mozldap search works,
Openldap search does not accept this syntax: Bad search filter (-7)
}}}
For more cases, see also https://access.redhat.com/documentation/en-US/Red_Hat_Directory_Server/8.2/html/Administration_Guide/Searching_an_Internationalized_Directory.html

Can I be a pain and ask you to attach the ldif of the database you were testing these searches with?

test ldif containing i18n data
i18ntest.ldif

I've attached my data.

The examples above are from the Doc... But the range search works and does not work in the same way.
locality:fr:=>= Québec
...

Note: need to investigate older versions

Metadata Update from @nhosoi:
- Issue set to the milestone: 1.3.6.0

Metadata Update from @mreynolds:
- Issue close_status updated to: None
- Issue set to the milestone: 1.4 backlog (was: 1.3.6.0)

389-ds-base is moving from Pagure to Github. This means that new issues and pull requests
will be accepted only in 389-ds-base's github repository.

This issue has been cloned to Github and is available here:
- https://github.com/389ds/389-ds-base/issues/2030

If you want to receive further updates on the issue, please navigate to the github issue
and click on subscribe button.

Thank you for understanding. We apologize for all inconvenience.

Metadata Update from @spichugi:
- Issue close_status updated to: wontfix
- Issue status updated to: Closed (was: Open)

Metadata