--_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 <[email protected]> Sent: November 23, 2017 15:19 To: [email protected]; [email protected] Subject: Re: (ITS#8776) lessOrEqual does not work as expected [email protected] 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;[email protected]><br> <b>Sent:</b> November 23, 2017 15:19<br> <b>To:</b> [email protected]; [email protected]<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">[email protected] 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_--
