Leading wildcard search on indexed attribute shows not indexed

[ShitalPatil Participant]

OpenDJ 3.0
When we search with wildcard in front of search string, it shows as attribute not indexed.
But searching with wildcard at the end, works fine.
Is this something known issue in 3.0? It use to work well in 2.6.

>ldapsearch -h localhost -p 389 -D “cn=Manager” -w pass -b “o=org” “(cn=*min)” debugsearchindex
dn: cn=debugsearch
debugsearchindex: filter=(cn=*min)[INDEX:cn.substring][NOT-INDEXED] scope=sub[COUNT:488] final=[COUNT:488]

>ldapsearch -h localhost -p 389 -D “cn=Manager” -w pass -b “o=org” “(cn=Admin*)” debugsearchindex
dn: cn=debugsearch
debugsearchindex: filter=(cn=Admin*)[INDEX:cn.substring][COUNT:2] final=[COUNT:2
]

• This topic was modified 6 months ago by  ShitalPatil.

[Ludo Moderator]

OpenDJ has an optimization for initial substrings where it can use the cn.equality index, even though no substring index was configured.

[cliff_tian Participant]

Hi Ludo,

The search returns only 1 result, and it appears it could not use the cn.equality index – even after removing the substring index from cn and uid.
ldapsearch -h localhost -p 389 -D “cn=Manager” -w wcadmin -b “o=ptc” “(cn=*wcadmin)” debugsearchindex
dn: cn=debugsearch
debugsearchindex: filter=(cn=*wcadmin)[INDEX:cn.substring][NOT-INDEXED] scope=su
b[COUNT:488] final=[COUNT:488]

ldapsearch -h localhost -p 389 -D “cn=Manager” -w wcadmin -b “o=ptc” “(uid=*wcadmin)” debugsearchindex
dn: cn=debugsearch
debugsearchindex: filter=(uid=*wcadmin)[INDEX:uid.substring][NOT-INDEXED] scope=
sub[COUNT:488] final=[COUNT:488]

ldapsearch -h localhost -p 389 -D “cn=Manager” -w wcadmin -b “o=ptc” “(uid=wcadmin)” debugsearchindex
dn: cn=debugsearch
debugsearchindex: filter=(uid=wcadmin)[INDEX:uid.equality][COUNT:1] final=[COUNT
:1]

ldapsearch -h localhost -p 389 -D “cn=Manager” -w wcadmin -b “o=ptc” “(cn=wcadmin)” debugsearchindex
dn: cn=debugsearch
debugsearchindex: filter=(cn=wcadmin)[INDEX:cn.equality][COUNT:0] final=[COUNT:0
]

[cliff_tian Participant]

Also refer to screenshot for comparison:

[cliff_tian Participant]

Hi Ludo,

It will be appreciated if you can look the replies.

Cliff

[Author]

Posts