[COMPASS-3466] $match with $gte ISODate fails Created: 20/Feb/19  Updated: 29/Oct/23  Resolved: 25/Feb/19

Status: Closed
Project: Compass
Component/s: Compass
Affects Version/s: 1.16.4
Fix Version/s: 1.17.0

Type: Bug Priority: Major - P3
Reporter: Frank Jones Assignee: Durran Jordan
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Windows 10


Attachments: PNG File Screenshot 2019-02-25 at 12.23.30.png     PNG File mongo_1.16.4_match.PNG    
Sprint: Iteration Yuca

 Description   

With the following $match statement;

{
  code: 'test',
  owner: ObjectId('5c6cc364cadec30a2b082cef'),
  tradedate: {
    $gte: ISODate('2015-12-21')
  }
}

an error "Expected end of input but "}" found." is presented.

In MongoDB CLI, an aggregate with the same $match condition preduces correct results.



 Comments   
Comment by Durran Jordan [ 25/Feb/19 ]

Fixed in latest 1.17 beta.

Comment by Frank Jones [ 20/Feb/19 ]

Removing either the `owner` or `tradedate` match condition allows the statement to pass.

Having both present at the same time appears to be the issue.

Generated at Wed Feb 07 22:33:16 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.