From kristianmccolm@hotmail.com Thu Nov 23 20:39:56 2017 From: kristianmccolm@hotmail.com To: openldap-bugs@openldap.org Subject: Re: (ITS#8776) lessOrEqual does not work as expected Date: Thu, 23 Nov 2017 20:39:54 +0000 Message-ID: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============1328994646043515723==" --===============1328994646043515723== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit --_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 Sent: November 23, 2017 15:19 To: kristianmccolm(a)hotmail.com; openldap-its(a)OpenLDAP.org Subject: Re: (ITS#8776) lessOrEqual does not work as expected kristianmccolm(a)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} ( 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 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

Hello Michael,


The lessOrEqual does work as expe= cted now after shutting down the directory and running slapindex.


Thanks

Kristian




From: Michael Str=F6der &= lt;michael(a)stroeder.com>
Sent: November 23, 2017 15:19
To: kristianmccolm(a)hotmail.com; openldap-its(a)OpenLDAP.org
Subject: Re: (ITS#8776) lessOrEqual does not work as expected
 
kristianmccolm(a)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 belo= w, 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):
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

(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 Attribut= e' SYNTAX
> 1.3.6.1.4.1.1466.115.121.1.27 X-ORIGIN 'user defined' EQUALITY integer= Match
> 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_-- --===============1328994646043515723==--