#48109 substring index with nssubstrbegin: 1 is not being used with filters like (attr=x*)
Closed: Fixed None Opened 5 years ago by nhosoi.

Description of problem:

I define an index with:
nssubstrbegin: 2

like this:
dn: cn=uid,cn=index,cn=userRoot,cn=ldbm database,cn=plugins,cn=config
objectClass: top
objectClass: nsIndex
objectClass: extensibleObject
cn: uid
nsSystemIndex: false
nsIndexType: eq
nsIndexType: pres
nsIndexType: sub
nssubstrbegin: 2
nssubstrmiddle: 2
nssubstrend: 2

  • db2index

And a query with filter (uid=n*) seems not to be using the index:

[25/Feb/2015:15:37:06 +0100] conn=7 op=1 SRCH base="o=redhat" scope=2
filter="(uid=n*)" attrs=ALL
[25/Feb/2015:15:37:06 +0100] conn=7 op=1 RESULT err=0 tag=101 nentries=1
etime=0 notes=A

Reviewed by Rich (Thank you!!)

Pushed to master:
8f1eef1..71f7659 master -> master
commit 71f7659
commit ae69e4a

Pushed to 389-ds-base-1.3.3:
a875da1..09fc02e 389-ds-base-1.3.3 -> 389-ds-base-1.3.3
commit 09fc02e
commit 511ec03

Fixed a compiler warning reported by Jenkins (#514)

71f7659..3701875 master -> master
commit 3701875

09fc02e..d6f7b97 389-ds-base-1.3.3 -> 389-ds-base-1.3.3
commit d6f7b97

Reviewed by Rich (Thank you!!)

Pushed to master:
bb0d222..2eba67c master -> master
commit 2eba67c

Pushed to 1.3.3:
1fe0088..650ca94 389-ds-base-1.3.3 -> 389-ds-base-1.3.3
commit 650ca94

Reviewed by Mark (Thank you!!)

Pushed to master:
cb22bb3..230ace2 master -> master
commit 230ace2

Pushed to 389-ds-base-1.3.4:
7715ac1..e001de5 389-ds-base-1.3.4 -> 389-ds-base-1.3.4
commit e001de5

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

3 years ago

Login to comment on this ticket.