This topic has 4 replies, 3 voices, and was last updated 3 years, 1 month ago by 
-
Posts
-
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
]OpenDJ has an optimization for initial substrings where it can use the cn.equality index, even though no substring index was configured.
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
]
You must be logged in to reply to this topic.
