Ugraded to 2.1, still get no results, and now get no results for the $regex query as well. If I do a query of $gt null, the results I'm looking for are there.
- Matt -----Original Message----- From: Matt Cosentino [mailto:[email protected]] Sent: Thursday, August 24, 2017 9:41 AM To: [email protected] Subject: RE: Mango query with $eq operator returns no results, but $regex does I have an index created for "type". { "type": "json", "def": { "fields": [ { "type": "asc" } ] } } I'll try upgrading my test server to 2.1 and see if that helps, thanks. - Matt -----Original Message----- From: Garren Smith [mailto:[email protected]] Sent: Thursday, August 24, 2017 4:38 AM To: user <[email protected]> Subject: Re: Mango query with $eq operator returns no results, but $regex does Hi Matt, What are your indexes? Also could you try these queries on CouchDB 2.1. The index selector was improved significantly in 2.1 to avoid these types of issues. Cheers Garren On Wed, Aug 23, 2017 at 9:49 PM, Matt Cosentino <[email protected]> wrote: > This is very strange. I have a very simple query: > > { selector: { "type": { "$eq": "client" } } } > > This returns no results, but there are documents with a type value of > client, and the index exists. > > I try other values in the query and they all work. > > I try this query instead: > > { selector: { "type": { "$regex": "client" } } } > > This gives me the results I expect. Why? > > Here's another strange thing. I have another version of my database on > another server. I run the original query there and it works. Both > servers are running version 2.0 of CouchDB. Does anyone have any idea > what could be wrong? > > > - Matt > >
