DominoQuery @created behaviour in queries

HCL Domino Domino Forum
, ,
1

Hello,

"@created >= @dt('2023-01-01T00:00:00.000Z') and @created < @dt('2024-01-01T00:00:00.000Z')"

vs

"@created < @dt('2024-01-01T00:00:00.000Z') and @created >= @dt('2023-01-01T00:00:00.000Z')"

Shouldn't these two queries be finding the same results ? Is this a bug or am I missing something ? Am I reaching some DQL limit ? Tested on Domino 12.0.2.

> load domquery -f xxxx.nsf -q "@created >= @dt('2023-01-01T00:00:00.000Z') and @created < @dt('2024-01-01T00:00:00.000Z')" -e
 AND     (childct 2) (totals when complete:) Prep 0.0 msecs, Exec 282.324 msecs, ScannedDocs 131310, Entries 0, FoundDocs 61
        1.@created >= 2023-01-01T00:00:00.00Z NSF document search estimated cost = 50
[8E8C:0002-76F8]                Prep 0.73 msecs, Exec 282.315 msecs, ScannedDocs 131310, Entries 0, FoundDocs 61
        1.@created < 2024-01-01T00:00:00.00Z NSF document search estimated cost = 50
[8E8C:0002-76F8]                Prep 0.5 msecs, Exec 0.0 msecs, ScannedDocs 0, Entries 0, FoundDocs 0 (0 cost - coupled with earlier sibling)

[8E8C:0002-76F8] Total Documents found = 61


> load domquery -f xxxx.nsf -q “@created < @dt(‘2024-01-01T00:00:00.000Z’)  AND @created >= @dt(‘2023-01-01T00:00:00.000Z’)” -e

AND     (childct 2) (totals when complete:) Prep 0.0 msecs, Exec 353.325 msecs, ScannedDocs 131310, Entries 0, FoundDocs 131310

1.@created < 2024-01-01T00:00:00.00Z NSF document search estimated cost = 50

[B4F0:0002-37D0]                Prep 0.54 msecs, Exec 353.313 msecs, ScannedDocs 131310, Entries 0, FoundDocs 131310

1.@created >= 2023-01-01T00:00:00.00Z NSF document search estimated cost = 50

[B4F0:0002-37D0]                Prep 0.5 msecs, Exec 0.0 msecs, ScannedDocs 0, Entries 0, FoundDocs 0 (0 cost - coupled with earlier sibling)


[B4F0:0002-37D0] Total Documents found = 131310

Thanks