[Date Prev][Date Next] [Chronological] [Thread] [Top]

Re: (ITS#8776) lessOrEqual does not work as expected



--_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&gt;<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>&nbsp;</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>
&gt; Full_Name: Kristian McColm<br>
&gt; Version: slapd 2.4.40<br>
<br>
Did you also test with a newer release?<br>
<br>
&gt; With an attribute type defined in the schema and index as per the belo=
w, and the<br>
&gt; value of the attribute set to 0, the lessOrEqual filter does not work =
as<br>
&gt; expected.<br>
<br>
It works for me.<br>
<br>
Example filter (aeStatus&lt;=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&lt;=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&lt;=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>
&gt; Schema attribute:<br>
&gt; olcAttributeTypes: {1} ( &lt;oid&gt; NAME 'num' DESC 'Numeric Attribut=
e' SYNTAX<br>
&gt; 1.3.6.1.4.1.1466.115.121.1.27 X-ORIGIN 'user defined' EQUALITY integer=
Match<br>
&gt; ORDERING integerOrderingMatch )<br>
<br>
Did you use &lt;oid&gt; 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_--