Leading wildcard search on indexed attribute shows not indexed

This topic contains 4 replies, has 3 voices, and was last updated by  cliff_tian 3 days, 10 hours ago.

  • Author
    Posts
  • #25554
     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 4 days, 14 hours ago by  ShitalPatil.
    #25556
     Ludo 
    Moderator

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

    #25574
     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
    ]

    #25575
     cliff_tian 
    Participant

    Also refer to screenshot for comparison:

    OpenDJ 2 VS 3

    #25635
     cliff_tian 
    Participant

    Hi Ludo,

    It will be appreciated if you can look the replies.

    Cliff

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic.

©2019 ForgeRock - we provide an identity and access platform to secure every online relationship for the enterprise market, educational sector and even entire countries. Click to view our privacy policy and terms of use.

Log in with your credentials

Forgot your details?