--_000_BN6PR04MB08825B65B73F5FF9B6674966DD210BN6PR04MB0882namp_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hello Michael,
The lessOrEqual does work as expected now after shutting down the directory= and running slapindex.
Thanks
Kristian
________________________________ From: Michael Str=F6der michael@stroeder.com Sent: November 23, 2017 15:19 To: kristianmccolm@hotmail.com; openldap-its@OpenLDAP.org Subject: Re: (ITS#8776) lessOrEqual does not work as expected
kristianmccolm@hotmail.com wrote:
Full_Name: Kristian McColm Version: slapd 2.4.40
Did you also test with a newer release?
With an attribute type defined in the schema and index as per the below, =
and the
value of the attribute set to 0, the lessOrEqual filter does not work as expected.
It works for me.
Example filter (aeStatus<=3D1) also finds entries with (aeStatus=3D0):
https://demo.ae-dir.com/web2ldap?ldapi://%2Fopt%2Fae-dir%2Frun%2Fslapd%2Fld= api/cn=3Dtest,ou=3Dae-dir??sub?(aeStatus<=3D1)?bindname=3Duid%3Dzots%2Ccn%3= Dtest%2Cou%3Dae-dir,X-BINDPW=3DCorrectHorseBatteryStaple
(This is an OpenLDAP 2.4.45 server but this worked for me with older releases too.)
Schema attribute: olcAttributeTypes: {1} ( <oid> NAME 'num' DESC 'Numeric Attribute' SYNTAX 1.3.6.1.4.1.1466.115.121.1.27 X-ORIGIN 'user defined' EQUALITY integerMat=
ch
ORDERING integerOrderingMatch )
Did you use <oid> as a placeholder or is that value really literally in your schema? If you used it as a placeholder herein which OID did you really use?
Did you eventually changed index-related schema config without re-indexing?
Ciao, Michael.
--_000_BN6PR04MB08825B65B73F5FF9B6674966DD210BN6PR04MB0882namp_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
<html> <head> <meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Diso-8859-= 1"> <style type=3D"text/css" style=3D"display:none;"><!-- P {margin-top:0;margi= n-bottom:0;} --></style> </head> <body dir=3D"ltr"> <div id=3D"divtagdefaultwrapper" style=3D"font-size:12pt;color:#000000;font= -family:Calibri,Helvetica,sans-serif;" dir=3D"ltr"> <p style=3D"margin-top:0;margin-bottom:0">Hello Michael,</p> <p style=3D"margin-top:0;margin-bottom:0"><br> </p> <p style=3D"margin-top:0;margin-bottom:0">The lessOrEqual does work as expe= cted now after shutting down the directory and running slapindex. <br> </p> <p style=3D"margin-top:0;margin-bottom:0"><br> </p> <p style=3D"margin-top:0;margin-bottom:0">Thanks <br> </p> <p style=3D"margin-top:0;margin-bottom:0">Kristian</p> <br> <br> <div style=3D"color: rgb(0, 0, 0);"> <hr style=3D"display:inline-block;width:98%" tabindex=3D"-1"> <div id=3D"divRplyFwdMsg" dir=3D"ltr"><font style=3D"font-size:11pt" face= =3D"Calibri, sans-serif" color=3D"#000000"><b>From:</b> Michael Str=F6der &= lt;michael@stroeder.com><br> <b>Sent:</b> November 23, 2017 15:19<br> <b>To:</b> kristianmccolm@hotmail.com; openldap-its@OpenLDAP.org<br> <b>Subject:</b> Re: (ITS#8776) lessOrEqual does not work as expected</font> <div> </div> </div> <div class=3D"BodyFragment"><font size=3D"2"><span style=3D"font-size:10pt;= "> <div class=3D"PlainText">kristianmccolm@hotmail.com wrote:<br> > Full_Name: Kristian McColm<br> > Version: slapd 2.4.40<br> <br> Did you also test with a newer release?<br> <br> > With an attribute type defined in the schema and index as per the belo= w, and the<br> > value of the attribute set to 0, the lessOrEqual filter does not work = as<br> > expected.<br> <br> It works for me.<br> <br> Example filter (aeStatus<=3D1) also finds entries with (aeStatus=3D0):<b= r> <br> <a href=3D"https://demo.ae-dir.com/web2ldap?ldapi://%2Fopt%2Fae-dir%2Frun%2= Fslapd%2Fldapi/cn=3Dtest,ou=3Dae-dir??sub?(aeStatus<=3D1)?bindname=3Duid= %3Dzots%2Ccn%3Dtest%2Cou%3Dae-dir,X-BINDPW=3DCorrectHorseBatteryStaple">htt= ps://demo.ae-dir.com/web2ldap?ldapi://%2Fopt%2Fae-dir%2Frun%2Fslapd%2Fldapi= /cn=3Dtest,ou=3Dae-dir??sub?(aeStatus<=3D1)?bindname=3Duid%3Dzots%2Ccn%3= Dtest%2Cou%3Dae-dir,X-BINDPW=3DCorrectHorseBatteryStaple</a><br> <br> (This is an OpenLDAP 2.4.45 server but this worked for me with older<br> releases too.)<br> <br> > Schema attribute:<br> > olcAttributeTypes: {1} ( <oid> NAME 'num' DESC 'Numeric Attribut= e' SYNTAX<br> > 1.3.6.1.4.1.1466.115.121.1.27 X-ORIGIN 'user defined' EQUALITY integer= Match<br> > ORDERING integerOrderingMatch )<br> <br> Did you use <oid> as a placeholder or is that value really literally = in<br> your schema? If you used it as a placeholder herein which OID did you<br> really use?<br> <br> Did you eventually changed index-related schema config without re-indexing?= <br> <br> Ciao, Michael.<br> <br> </div> </span></font></div> </div> </div> </body> </html>
--_000_BN6PR04MB08825B65B73F5FF9B6674966DD210BN6PR04MB0882namp_--