You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@couchdb.apache.org by Matt Cosentino <mc...@cacorp.com> on 2017/08/23 19:49:56 UTC
Mango query with $eq operator returns no results, but $regex does
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
Re: Mango query with $eq operator returns no results, but $regex does
Posted by Garren Smith <ga...@apache.org>.
Can you run an _explain query and show us the results. That should tell you
which index it is trying to use. The other option is to use the `use_index`
option to specify the exact index you want to use. If possible could you
create a scenario that we can test against and run ourselves? It doesn't
help right now, but we have done a ton of work on Mango around index
selection and querying. So the next release will have a much more
predictable index selector for mango.
On Thu, Sep 21, 2017 at 7:27 PM, Matt Cosentino <mc...@cacorp.com>
wrote:
> I created a new client document like before and it did not fix the issue.
>
> - Matt
>
>
> -----Original Message-----
> From: Matt Cosentino [mailto:mcosentino@cacorp.com]
> Sent: Thursday, September 21, 2017 12:24 PM
> To: user@couchdb.apache.org; Joan Touzet <wo...@apache.org>
> Subject: RE: Mango query with $eq operator returns no results, but $regex
> does
>
> Moved my changes over to the live server and this problem is happening
> again. This is maddening.
>
> - Matt
>
> -----Original Message-----
> From: Matt Cosentino [mailto:mcosentino@cacorp.com]
> Sent: Thursday, August 24, 2017 4:02 PM
> To: user@couchdb.apache.org; Joan Touzet <wo...@apache.org>
> Subject: RE: Mango query with $eq operator returns no results, but $regex
> does
>
> I don't see any errors. I had tried deleting and recreating the index,
> thinking that might be the case, but that didn't fix it.
>
> - Matt
>
>
> -----Original Message-----
> From: Joan Touzet [mailto:wohali@apache.org]
> Sent: Thursday, August 24, 2017 3:36 PM
> To: user@couchdb.apache.org
> Subject: Re: Mango query with $eq operator returns no results, but $regex
> does
>
> Have you checked your couch.log / couchdb.log file for any errors?
> It's possible the index needed to be rebuilt, and adding the new document
> forced that operation.
>
> ----- Original Message -----
> From: "Matt Cosentino" <mc...@cacorp.com>
> To: user@couchdb.apache.org
> Sent: Thursday, 24 August, 2017 3:56:35 PM
> Subject: RE: Mango query with $eq operator returns no results, but $regex
> does
>
> Yeah, but not knowing what was wrong doesn't leave me with much confidence
> in the database going forward.
>
> - Matt
>
>
> -----Original Message-----
> From: Garren Smith [mailto:garren@apache.org]
> Sent: Thursday, August 24, 2017 2:38 PM
> To: user@couchdb.apache.org
> Subject: Re: Mango query with $eq operator returns no results, but $regex
> does
>
> I'm not sure. Glad it's working though.
>
> On Thu, 24 Aug 2017 at 9:09 PM Matt Cosentino <mc...@cacorp.com>
> wrote:
>
> > I didn't want to give you any confidential information, so I created a
> > new client document. Well, now the query works and returns all the
> > client documents. What happened?
> >
> > - Matt
> >
> >
> > -----Original Message-----
> > From: Garren Smith [mailto:garren@apache.org]
> > Sent: Thursday, August 24, 2017 2:00 PM
> > To: user@couchdb.apache.org
> > Subject: Re: Mango query with $eq operator returns no results, but
> > $regex does
> >
> > Could you supply some example docs so I can try and reproduce it.
> >
> > On Thu, 24 Aug 2017 at 8:07 PM Matt Cosentino <mc...@cacorp.com>
> > wrote:
> >
> > > Yes.
> > >
> > > - Matt
> > >
> > >
> > > -----Original Message-----
> > > From: Garren Smith [mailto:garren@apache.org]
> > > Sent: Thursday, August 24, 2017 12:51 PM
> > > To: user@couchdb.apache.org
> > > Subject: Re: Mango query with $eq operator returns no results, but
> > > $regex does
> > >
> > > Do you have any docs with the field type = client?
> > >
> > > On Thu, 24 Aug 2017 at 7:47 PM Matt Cosentino
> > > <mc...@cacorp.com>
> > > wrote:
> > >
> > > > Tried that, it is using the type index. Isn't that what I want?
> > > > That's the only field in my selector.
> > > >
> > > > - Matt
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: Garren Smith [mailto:garren@apache.org]
> > > > Sent: Thursday, August 24, 2017 12:34 PM
> > > > To: user@couchdb.apache.org
> > > > Subject: Re: Mango query with $eq operator returns no results, but
> > > > $regex does
> > > >
> > > > I think the best next step is to run the query against _explain
> > > > instead of _find. It will tell you which index it has selected.
> > > >
> > > > The other option is to add another selector with client_id > null.
> > > > I'm guessing it is choosing the type, customer_name index and you
> > > > want it to use the type, client_id index
> > > >
> > > > On Thu, 24 Aug 2017 at 6:42 PM Matt Cosentino
> > > > <mc...@cacorp.com>
> > > > wrote:
> > > >
> > > > > special: _id
> > > > > json: type, client_id
> > > > > json: last_payment
> > > > > json: type
> > > > > json: date
> > > > > json: date, time
> > > > > json: type, client_id, date
> > > > > json: datetime
> > > > > json: client_id
> > > > > json: type, customer_name
> > > > > json: customer_name
> > > > >
> > > > > { selector: { "type": { "$eq": "client" } } }
> > > > >
> > > > > - Matt
> > > > >
> > > > >
> > > > > -----Original Message-----
> > > > > From: Garren Smith [mailto:garren@apache.org]
> > > > > Sent: Thursday, August 24, 2017 11:00 AM
> > > > > To: user@couchdb.apache.org
> > > > > Subject: Re: Mango query with $eq operator returns no results,
> > > > > but $regex does
> > > > >
> > > > > Can you give me a full list of all your indexes and the query
> > > > > you are running.
> > > > >
> > > > > On Thu, 24 Aug 2017 at 5:45 PM Matt Cosentino
> > > > > <mc...@cacorp.com>
> > > > > wrote:
> > > > >
> > > > > > 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:mcosentino@cacorp.com]
> > > > > > Sent: Thursday, August 24, 2017 9:41 AM
> > > > > > To: user@couchdb.apache.org
> > > > > > 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:garren@apache.org]
> > > > > > Sent: Thursday, August 24, 2017 4:38 AM
> > > > > > To: user <us...@couchdb.apache.org>
> > > > > > 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
> > > > > > <mc...@cacorp.com>
> > > > > > 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
> > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>
RE: Mango query with $eq operator returns no results, but $regex
does
Posted by Matt Cosentino <mc...@cacorp.com>.
I created a new client document like before and it did not fix the issue.
- Matt
-----Original Message-----
From: Matt Cosentino [mailto:mcosentino@cacorp.com]
Sent: Thursday, September 21, 2017 12:24 PM
To: user@couchdb.apache.org; Joan Touzet <wo...@apache.org>
Subject: RE: Mango query with $eq operator returns no results, but $regex does
Moved my changes over to the live server and this problem is happening again. This is maddening.
- Matt
-----Original Message-----
From: Matt Cosentino [mailto:mcosentino@cacorp.com]
Sent: Thursday, August 24, 2017 4:02 PM
To: user@couchdb.apache.org; Joan Touzet <wo...@apache.org>
Subject: RE: Mango query with $eq operator returns no results, but $regex does
I don't see any errors. I had tried deleting and recreating the index, thinking that might be the case, but that didn't fix it.
- Matt
-----Original Message-----
From: Joan Touzet [mailto:wohali@apache.org]
Sent: Thursday, August 24, 2017 3:36 PM
To: user@couchdb.apache.org
Subject: Re: Mango query with $eq operator returns no results, but $regex does
Have you checked your couch.log / couchdb.log file for any errors?
It's possible the index needed to be rebuilt, and adding the new document forced that operation.
----- Original Message -----
From: "Matt Cosentino" <mc...@cacorp.com>
To: user@couchdb.apache.org
Sent: Thursday, 24 August, 2017 3:56:35 PM
Subject: RE: Mango query with $eq operator returns no results, but $regex does
Yeah, but not knowing what was wrong doesn't leave me with much confidence in the database going forward.
- Matt
-----Original Message-----
From: Garren Smith [mailto:garren@apache.org]
Sent: Thursday, August 24, 2017 2:38 PM
To: user@couchdb.apache.org
Subject: Re: Mango query with $eq operator returns no results, but $regex does
I'm not sure. Glad it's working though.
On Thu, 24 Aug 2017 at 9:09 PM Matt Cosentino <mc...@cacorp.com> wrote:
> I didn't want to give you any confidential information, so I created a
> new client document. Well, now the query works and returns all the
> client documents. What happened?
>
> - Matt
>
>
> -----Original Message-----
> From: Garren Smith [mailto:garren@apache.org]
> Sent: Thursday, August 24, 2017 2:00 PM
> To: user@couchdb.apache.org
> Subject: Re: Mango query with $eq operator returns no results, but
> $regex does
>
> Could you supply some example docs so I can try and reproduce it.
>
> On Thu, 24 Aug 2017 at 8:07 PM Matt Cosentino <mc...@cacorp.com>
> wrote:
>
> > Yes.
> >
> > - Matt
> >
> >
> > -----Original Message-----
> > From: Garren Smith [mailto:garren@apache.org]
> > Sent: Thursday, August 24, 2017 12:51 PM
> > To: user@couchdb.apache.org
> > Subject: Re: Mango query with $eq operator returns no results, but
> > $regex does
> >
> > Do you have any docs with the field type = client?
> >
> > On Thu, 24 Aug 2017 at 7:47 PM Matt Cosentino
> > <mc...@cacorp.com>
> > wrote:
> >
> > > Tried that, it is using the type index. Isn't that what I want?
> > > That's the only field in my selector.
> > >
> > > - Matt
> > >
> > >
> > > -----Original Message-----
> > > From: Garren Smith [mailto:garren@apache.org]
> > > Sent: Thursday, August 24, 2017 12:34 PM
> > > To: user@couchdb.apache.org
> > > Subject: Re: Mango query with $eq operator returns no results, but
> > > $regex does
> > >
> > > I think the best next step is to run the query against _explain
> > > instead of _find. It will tell you which index it has selected.
> > >
> > > The other option is to add another selector with client_id > null.
> > > I'm guessing it is choosing the type, customer_name index and you
> > > want it to use the type, client_id index
> > >
> > > On Thu, 24 Aug 2017 at 6:42 PM Matt Cosentino
> > > <mc...@cacorp.com>
> > > wrote:
> > >
> > > > special: _id
> > > > json: type, client_id
> > > > json: last_payment
> > > > json: type
> > > > json: date
> > > > json: date, time
> > > > json: type, client_id, date
> > > > json: datetime
> > > > json: client_id
> > > > json: type, customer_name
> > > > json: customer_name
> > > >
> > > > { selector: { "type": { "$eq": "client" } } }
> > > >
> > > > - Matt
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: Garren Smith [mailto:garren@apache.org]
> > > > Sent: Thursday, August 24, 2017 11:00 AM
> > > > To: user@couchdb.apache.org
> > > > Subject: Re: Mango query with $eq operator returns no results,
> > > > but $regex does
> > > >
> > > > Can you give me a full list of all your indexes and the query
> > > > you are running.
> > > >
> > > > On Thu, 24 Aug 2017 at 5:45 PM Matt Cosentino
> > > > <mc...@cacorp.com>
> > > > wrote:
> > > >
> > > > > 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:mcosentino@cacorp.com]
> > > > > Sent: Thursday, August 24, 2017 9:41 AM
> > > > > To: user@couchdb.apache.org
> > > > > 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:garren@apache.org]
> > > > > Sent: Thursday, August 24, 2017 4:38 AM
> > > > > To: user <us...@couchdb.apache.org>
> > > > > 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
> > > > > <mc...@cacorp.com>
> > > > > 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
> > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>
RE: Mango query with $eq operator returns no results, but $regex
does
Posted by Matt Cosentino <mc...@cacorp.com>.
Moved my changes over to the live server and this problem is happening again. This is maddening.
- Matt
-----Original Message-----
From: Matt Cosentino [mailto:mcosentino@cacorp.com]
Sent: Thursday, August 24, 2017 4:02 PM
To: user@couchdb.apache.org; Joan Touzet <wo...@apache.org>
Subject: RE: Mango query with $eq operator returns no results, but $regex does
I don't see any errors. I had tried deleting and recreating the index, thinking that might be the case, but that didn't fix it.
- Matt
-----Original Message-----
From: Joan Touzet [mailto:wohali@apache.org]
Sent: Thursday, August 24, 2017 3:36 PM
To: user@couchdb.apache.org
Subject: Re: Mango query with $eq operator returns no results, but $regex does
Have you checked your couch.log / couchdb.log file for any errors?
It's possible the index needed to be rebuilt, and adding the new document forced that operation.
----- Original Message -----
From: "Matt Cosentino" <mc...@cacorp.com>
To: user@couchdb.apache.org
Sent: Thursday, 24 August, 2017 3:56:35 PM
Subject: RE: Mango query with $eq operator returns no results, but $regex does
Yeah, but not knowing what was wrong doesn't leave me with much confidence in the database going forward.
- Matt
-----Original Message-----
From: Garren Smith [mailto:garren@apache.org]
Sent: Thursday, August 24, 2017 2:38 PM
To: user@couchdb.apache.org
Subject: Re: Mango query with $eq operator returns no results, but $regex does
I'm not sure. Glad it's working though.
On Thu, 24 Aug 2017 at 9:09 PM Matt Cosentino <mc...@cacorp.com> wrote:
> I didn't want to give you any confidential information, so I created a
> new client document. Well, now the query works and returns all the
> client documents. What happened?
>
> - Matt
>
>
> -----Original Message-----
> From: Garren Smith [mailto:garren@apache.org]
> Sent: Thursday, August 24, 2017 2:00 PM
> To: user@couchdb.apache.org
> Subject: Re: Mango query with $eq operator returns no results, but
> $regex does
>
> Could you supply some example docs so I can try and reproduce it.
>
> On Thu, 24 Aug 2017 at 8:07 PM Matt Cosentino <mc...@cacorp.com>
> wrote:
>
> > Yes.
> >
> > - Matt
> >
> >
> > -----Original Message-----
> > From: Garren Smith [mailto:garren@apache.org]
> > Sent: Thursday, August 24, 2017 12:51 PM
> > To: user@couchdb.apache.org
> > Subject: Re: Mango query with $eq operator returns no results, but
> > $regex does
> >
> > Do you have any docs with the field type = client?
> >
> > On Thu, 24 Aug 2017 at 7:47 PM Matt Cosentino
> > <mc...@cacorp.com>
> > wrote:
> >
> > > Tried that, it is using the type index. Isn't that what I want?
> > > That's the only field in my selector.
> > >
> > > - Matt
> > >
> > >
> > > -----Original Message-----
> > > From: Garren Smith [mailto:garren@apache.org]
> > > Sent: Thursday, August 24, 2017 12:34 PM
> > > To: user@couchdb.apache.org
> > > Subject: Re: Mango query with $eq operator returns no results, but
> > > $regex does
> > >
> > > I think the best next step is to run the query against _explain
> > > instead of _find. It will tell you which index it has selected.
> > >
> > > The other option is to add another selector with client_id > null.
> > > I'm guessing it is choosing the type, customer_name index and you
> > > want it to use the type, client_id index
> > >
> > > On Thu, 24 Aug 2017 at 6:42 PM Matt Cosentino
> > > <mc...@cacorp.com>
> > > wrote:
> > >
> > > > special: _id
> > > > json: type, client_id
> > > > json: last_payment
> > > > json: type
> > > > json: date
> > > > json: date, time
> > > > json: type, client_id, date
> > > > json: datetime
> > > > json: client_id
> > > > json: type, customer_name
> > > > json: customer_name
> > > >
> > > > { selector: { "type": { "$eq": "client" } } }
> > > >
> > > > - Matt
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: Garren Smith [mailto:garren@apache.org]
> > > > Sent: Thursday, August 24, 2017 11:00 AM
> > > > To: user@couchdb.apache.org
> > > > Subject: Re: Mango query with $eq operator returns no results,
> > > > but $regex does
> > > >
> > > > Can you give me a full list of all your indexes and the query
> > > > you are running.
> > > >
> > > > On Thu, 24 Aug 2017 at 5:45 PM Matt Cosentino
> > > > <mc...@cacorp.com>
> > > > wrote:
> > > >
> > > > > 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:mcosentino@cacorp.com]
> > > > > Sent: Thursday, August 24, 2017 9:41 AM
> > > > > To: user@couchdb.apache.org
> > > > > 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:garren@apache.org]
> > > > > Sent: Thursday, August 24, 2017 4:38 AM
> > > > > To: user <us...@couchdb.apache.org>
> > > > > 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
> > > > > <mc...@cacorp.com>
> > > > > 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
> > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>
RE: Mango query with $eq operator returns no results, but $regex
does
Posted by Matt Cosentino <mc...@cacorp.com>.
I don't see any errors. I had tried deleting and recreating the index, thinking that might be the case, but that didn't fix it.
- Matt
-----Original Message-----
From: Joan Touzet [mailto:wohali@apache.org]
Sent: Thursday, August 24, 2017 3:36 PM
To: user@couchdb.apache.org
Subject: Re: Mango query with $eq operator returns no results, but $regex does
Have you checked your couch.log / couchdb.log file for any errors?
It's possible the index needed to be rebuilt, and adding the new document forced that operation.
----- Original Message -----
From: "Matt Cosentino" <mc...@cacorp.com>
To: user@couchdb.apache.org
Sent: Thursday, 24 August, 2017 3:56:35 PM
Subject: RE: Mango query with $eq operator returns no results, but $regex does
Yeah, but not knowing what was wrong doesn't leave me with much confidence in the database going forward.
- Matt
-----Original Message-----
From: Garren Smith [mailto:garren@apache.org]
Sent: Thursday, August 24, 2017 2:38 PM
To: user@couchdb.apache.org
Subject: Re: Mango query with $eq operator returns no results, but $regex does
I'm not sure. Glad it's working though.
On Thu, 24 Aug 2017 at 9:09 PM Matt Cosentino <mc...@cacorp.com> wrote:
> I didn't want to give you any confidential information, so I created a
> new client document. Well, now the query works and returns all the
> client documents. What happened?
>
> - Matt
>
>
> -----Original Message-----
> From: Garren Smith [mailto:garren@apache.org]
> Sent: Thursday, August 24, 2017 2:00 PM
> To: user@couchdb.apache.org
> Subject: Re: Mango query with $eq operator returns no results, but
> $regex does
>
> Could you supply some example docs so I can try and reproduce it.
>
> On Thu, 24 Aug 2017 at 8:07 PM Matt Cosentino <mc...@cacorp.com>
> wrote:
>
> > Yes.
> >
> > - Matt
> >
> >
> > -----Original Message-----
> > From: Garren Smith [mailto:garren@apache.org]
> > Sent: Thursday, August 24, 2017 12:51 PM
> > To: user@couchdb.apache.org
> > Subject: Re: Mango query with $eq operator returns no results, but
> > $regex does
> >
> > Do you have any docs with the field type = client?
> >
> > On Thu, 24 Aug 2017 at 7:47 PM Matt Cosentino
> > <mc...@cacorp.com>
> > wrote:
> >
> > > Tried that, it is using the type index. Isn't that what I want?
> > > That's the only field in my selector.
> > >
> > > - Matt
> > >
> > >
> > > -----Original Message-----
> > > From: Garren Smith [mailto:garren@apache.org]
> > > Sent: Thursday, August 24, 2017 12:34 PM
> > > To: user@couchdb.apache.org
> > > Subject: Re: Mango query with $eq operator returns no results, but
> > > $regex does
> > >
> > > I think the best next step is to run the query against _explain
> > > instead of _find. It will tell you which index it has selected.
> > >
> > > The other option is to add another selector with client_id > null.
> > > I'm guessing it is choosing the type, customer_name index and you
> > > want it to use the type, client_id index
> > >
> > > On Thu, 24 Aug 2017 at 6:42 PM Matt Cosentino
> > > <mc...@cacorp.com>
> > > wrote:
> > >
> > > > special: _id
> > > > json: type, client_id
> > > > json: last_payment
> > > > json: type
> > > > json: date
> > > > json: date, time
> > > > json: type, client_id, date
> > > > json: datetime
> > > > json: client_id
> > > > json: type, customer_name
> > > > json: customer_name
> > > >
> > > > { selector: { "type": { "$eq": "client" } } }
> > > >
> > > > - Matt
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: Garren Smith [mailto:garren@apache.org]
> > > > Sent: Thursday, August 24, 2017 11:00 AM
> > > > To: user@couchdb.apache.org
> > > > Subject: Re: Mango query with $eq operator returns no results,
> > > > but $regex does
> > > >
> > > > Can you give me a full list of all your indexes and the query
> > > > you are running.
> > > >
> > > > On Thu, 24 Aug 2017 at 5:45 PM Matt Cosentino
> > > > <mc...@cacorp.com>
> > > > wrote:
> > > >
> > > > > 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:mcosentino@cacorp.com]
> > > > > Sent: Thursday, August 24, 2017 9:41 AM
> > > > > To: user@couchdb.apache.org
> > > > > 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:garren@apache.org]
> > > > > Sent: Thursday, August 24, 2017 4:38 AM
> > > > > To: user <us...@couchdb.apache.org>
> > > > > 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
> > > > > <mc...@cacorp.com>
> > > > > 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
> > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>
Re: Mango query with $eq operator returns no results, but $regex
does
Posted by Joan Touzet <wo...@apache.org>.
Have you checked your couch.log / couchdb.log file for any errors?
It's possible the index needed to be rebuilt, and adding the new
document forced that operation.
----- Original Message -----
From: "Matt Cosentino" <mc...@cacorp.com>
To: user@couchdb.apache.org
Sent: Thursday, 24 August, 2017 3:56:35 PM
Subject: RE: Mango query with $eq operator returns no results, but $regex does
Yeah, but not knowing what was wrong doesn't leave me with much confidence in the database going forward.
- Matt
-----Original Message-----
From: Garren Smith [mailto:garren@apache.org]
Sent: Thursday, August 24, 2017 2:38 PM
To: user@couchdb.apache.org
Subject: Re: Mango query with $eq operator returns no results, but $regex does
I'm not sure. Glad it's working though.
On Thu, 24 Aug 2017 at 9:09 PM Matt Cosentino <mc...@cacorp.com> wrote:
> I didn't want to give you any confidential information, so I created a
> new client document. Well, now the query works and returns all the
> client documents. What happened?
>
> - Matt
>
>
> -----Original Message-----
> From: Garren Smith [mailto:garren@apache.org]
> Sent: Thursday, August 24, 2017 2:00 PM
> To: user@couchdb.apache.org
> Subject: Re: Mango query with $eq operator returns no results, but
> $regex does
>
> Could you supply some example docs so I can try and reproduce it.
>
> On Thu, 24 Aug 2017 at 8:07 PM Matt Cosentino <mc...@cacorp.com>
> wrote:
>
> > Yes.
> >
> > - Matt
> >
> >
> > -----Original Message-----
> > From: Garren Smith [mailto:garren@apache.org]
> > Sent: Thursday, August 24, 2017 12:51 PM
> > To: user@couchdb.apache.org
> > Subject: Re: Mango query with $eq operator returns no results, but
> > $regex does
> >
> > Do you have any docs with the field type = client?
> >
> > On Thu, 24 Aug 2017 at 7:47 PM Matt Cosentino
> > <mc...@cacorp.com>
> > wrote:
> >
> > > Tried that, it is using the type index. Isn't that what I want?
> > > That's the only field in my selector.
> > >
> > > - Matt
> > >
> > >
> > > -----Original Message-----
> > > From: Garren Smith [mailto:garren@apache.org]
> > > Sent: Thursday, August 24, 2017 12:34 PM
> > > To: user@couchdb.apache.org
> > > Subject: Re: Mango query with $eq operator returns no results, but
> > > $regex does
> > >
> > > I think the best next step is to run the query against _explain
> > > instead of _find. It will tell you which index it has selected.
> > >
> > > The other option is to add another selector with client_id > null.
> > > I'm guessing it is choosing the type, customer_name index and you
> > > want it to use the type, client_id index
> > >
> > > On Thu, 24 Aug 2017 at 6:42 PM Matt Cosentino
> > > <mc...@cacorp.com>
> > > wrote:
> > >
> > > > special: _id
> > > > json: type, client_id
> > > > json: last_payment
> > > > json: type
> > > > json: date
> > > > json: date, time
> > > > json: type, client_id, date
> > > > json: datetime
> > > > json: client_id
> > > > json: type, customer_name
> > > > json: customer_name
> > > >
> > > > { selector: { "type": { "$eq": "client" } } }
> > > >
> > > > - Matt
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: Garren Smith [mailto:garren@apache.org]
> > > > Sent: Thursday, August 24, 2017 11:00 AM
> > > > To: user@couchdb.apache.org
> > > > Subject: Re: Mango query with $eq operator returns no results,
> > > > but $regex does
> > > >
> > > > Can you give me a full list of all your indexes and the query
> > > > you are running.
> > > >
> > > > On Thu, 24 Aug 2017 at 5:45 PM Matt Cosentino
> > > > <mc...@cacorp.com>
> > > > wrote:
> > > >
> > > > > 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:mcosentino@cacorp.com]
> > > > > Sent: Thursday, August 24, 2017 9:41 AM
> > > > > To: user@couchdb.apache.org
> > > > > 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:garren@apache.org]
> > > > > Sent: Thursday, August 24, 2017 4:38 AM
> > > > > To: user <us...@couchdb.apache.org>
> > > > > 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
> > > > > <mc...@cacorp.com>
> > > > > 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
> > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>
RE: Mango query with $eq operator returns no results, but $regex
does
Posted by Matt Cosentino <mc...@cacorp.com>.
Yeah, but not knowing what was wrong doesn't leave me with much confidence in the database going forward.
- Matt
-----Original Message-----
From: Garren Smith [mailto:garren@apache.org]
Sent: Thursday, August 24, 2017 2:38 PM
To: user@couchdb.apache.org
Subject: Re: Mango query with $eq operator returns no results, but $regex does
I'm not sure. Glad it's working though.
On Thu, 24 Aug 2017 at 9:09 PM Matt Cosentino <mc...@cacorp.com> wrote:
> I didn't want to give you any confidential information, so I created a
> new client document. Well, now the query works and returns all the
> client documents. What happened?
>
> - Matt
>
>
> -----Original Message-----
> From: Garren Smith [mailto:garren@apache.org]
> Sent: Thursday, August 24, 2017 2:00 PM
> To: user@couchdb.apache.org
> Subject: Re: Mango query with $eq operator returns no results, but
> $regex does
>
> Could you supply some example docs so I can try and reproduce it.
>
> On Thu, 24 Aug 2017 at 8:07 PM Matt Cosentino <mc...@cacorp.com>
> wrote:
>
> > Yes.
> >
> > - Matt
> >
> >
> > -----Original Message-----
> > From: Garren Smith [mailto:garren@apache.org]
> > Sent: Thursday, August 24, 2017 12:51 PM
> > To: user@couchdb.apache.org
> > Subject: Re: Mango query with $eq operator returns no results, but
> > $regex does
> >
> > Do you have any docs with the field type = client?
> >
> > On Thu, 24 Aug 2017 at 7:47 PM Matt Cosentino
> > <mc...@cacorp.com>
> > wrote:
> >
> > > Tried that, it is using the type index. Isn't that what I want?
> > > That's the only field in my selector.
> > >
> > > - Matt
> > >
> > >
> > > -----Original Message-----
> > > From: Garren Smith [mailto:garren@apache.org]
> > > Sent: Thursday, August 24, 2017 12:34 PM
> > > To: user@couchdb.apache.org
> > > Subject: Re: Mango query with $eq operator returns no results, but
> > > $regex does
> > >
> > > I think the best next step is to run the query against _explain
> > > instead of _find. It will tell you which index it has selected.
> > >
> > > The other option is to add another selector with client_id > null.
> > > I'm guessing it is choosing the type, customer_name index and you
> > > want it to use the type, client_id index
> > >
> > > On Thu, 24 Aug 2017 at 6:42 PM Matt Cosentino
> > > <mc...@cacorp.com>
> > > wrote:
> > >
> > > > special: _id
> > > > json: type, client_id
> > > > json: last_payment
> > > > json: type
> > > > json: date
> > > > json: date, time
> > > > json: type, client_id, date
> > > > json: datetime
> > > > json: client_id
> > > > json: type, customer_name
> > > > json: customer_name
> > > >
> > > > { selector: { "type": { "$eq": "client" } } }
> > > >
> > > > - Matt
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: Garren Smith [mailto:garren@apache.org]
> > > > Sent: Thursday, August 24, 2017 11:00 AM
> > > > To: user@couchdb.apache.org
> > > > Subject: Re: Mango query with $eq operator returns no results,
> > > > but $regex does
> > > >
> > > > Can you give me a full list of all your indexes and the query
> > > > you are running.
> > > >
> > > > On Thu, 24 Aug 2017 at 5:45 PM Matt Cosentino
> > > > <mc...@cacorp.com>
> > > > wrote:
> > > >
> > > > > 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:mcosentino@cacorp.com]
> > > > > Sent: Thursday, August 24, 2017 9:41 AM
> > > > > To: user@couchdb.apache.org
> > > > > 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:garren@apache.org]
> > > > > Sent: Thursday, August 24, 2017 4:38 AM
> > > > > To: user <us...@couchdb.apache.org>
> > > > > 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
> > > > > <mc...@cacorp.com>
> > > > > 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
> > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>
Re: Mango query with $eq operator returns no results, but $regex does
Posted by Garren Smith <ga...@apache.org>.
I'm not sure. Glad it's working though.
On Thu, 24 Aug 2017 at 9:09 PM Matt Cosentino <mc...@cacorp.com> wrote:
> I didn't want to give you any confidential information, so I created a new
> client document. Well, now the query works and returns all the client
> documents. What happened?
>
> - Matt
>
>
> -----Original Message-----
> From: Garren Smith [mailto:garren@apache.org]
> Sent: Thursday, August 24, 2017 2:00 PM
> To: user@couchdb.apache.org
> Subject: Re: Mango query with $eq operator returns no results, but $regex
> does
>
> Could you supply some example docs so I can try and reproduce it.
>
> On Thu, 24 Aug 2017 at 8:07 PM Matt Cosentino <mc...@cacorp.com>
> wrote:
>
> > Yes.
> >
> > - Matt
> >
> >
> > -----Original Message-----
> > From: Garren Smith [mailto:garren@apache.org]
> > Sent: Thursday, August 24, 2017 12:51 PM
> > To: user@couchdb.apache.org
> > Subject: Re: Mango query with $eq operator returns no results, but
> > $regex does
> >
> > Do you have any docs with the field type = client?
> >
> > On Thu, 24 Aug 2017 at 7:47 PM Matt Cosentino <mc...@cacorp.com>
> > wrote:
> >
> > > Tried that, it is using the type index. Isn't that what I want?
> > > That's the only field in my selector.
> > >
> > > - Matt
> > >
> > >
> > > -----Original Message-----
> > > From: Garren Smith [mailto:garren@apache.org]
> > > Sent: Thursday, August 24, 2017 12:34 PM
> > > To: user@couchdb.apache.org
> > > Subject: Re: Mango query with $eq operator returns no results, but
> > > $regex does
> > >
> > > I think the best next step is to run the query against _explain
> > > instead of _find. It will tell you which index it has selected.
> > >
> > > The other option is to add another selector with client_id > null.
> > > I'm guessing it is choosing the type, customer_name index and you
> > > want it to use the type, client_id index
> > >
> > > On Thu, 24 Aug 2017 at 6:42 PM Matt Cosentino
> > > <mc...@cacorp.com>
> > > wrote:
> > >
> > > > special: _id
> > > > json: type, client_id
> > > > json: last_payment
> > > > json: type
> > > > json: date
> > > > json: date, time
> > > > json: type, client_id, date
> > > > json: datetime
> > > > json: client_id
> > > > json: type, customer_name
> > > > json: customer_name
> > > >
> > > > { selector: { "type": { "$eq": "client" } } }
> > > >
> > > > - Matt
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: Garren Smith [mailto:garren@apache.org]
> > > > Sent: Thursday, August 24, 2017 11:00 AM
> > > > To: user@couchdb.apache.org
> > > > Subject: Re: Mango query with $eq operator returns no results, but
> > > > $regex does
> > > >
> > > > Can you give me a full list of all your indexes and the query you
> > > > are running.
> > > >
> > > > On Thu, 24 Aug 2017 at 5:45 PM Matt Cosentino
> > > > <mc...@cacorp.com>
> > > > wrote:
> > > >
> > > > > 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:mcosentino@cacorp.com]
> > > > > Sent: Thursday, August 24, 2017 9:41 AM
> > > > > To: user@couchdb.apache.org
> > > > > 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:garren@apache.org]
> > > > > Sent: Thursday, August 24, 2017 4:38 AM
> > > > > To: user <us...@couchdb.apache.org>
> > > > > 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
> > > > > <mc...@cacorp.com>
> > > > > 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
> > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>
RE: Mango query with $eq operator returns no results, but $regex
does
Posted by Matt Cosentino <mc...@cacorp.com>.
I didn't want to give you any confidential information, so I created a new client document. Well, now the query works and returns all the client documents. What happened?
- Matt
-----Original Message-----
From: Garren Smith [mailto:garren@apache.org]
Sent: Thursday, August 24, 2017 2:00 PM
To: user@couchdb.apache.org
Subject: Re: Mango query with $eq operator returns no results, but $regex does
Could you supply some example docs so I can try and reproduce it.
On Thu, 24 Aug 2017 at 8:07 PM Matt Cosentino <mc...@cacorp.com> wrote:
> Yes.
>
> - Matt
>
>
> -----Original Message-----
> From: Garren Smith [mailto:garren@apache.org]
> Sent: Thursday, August 24, 2017 12:51 PM
> To: user@couchdb.apache.org
> Subject: Re: Mango query with $eq operator returns no results, but
> $regex does
>
> Do you have any docs with the field type = client?
>
> On Thu, 24 Aug 2017 at 7:47 PM Matt Cosentino <mc...@cacorp.com>
> wrote:
>
> > Tried that, it is using the type index. Isn't that what I want?
> > That's the only field in my selector.
> >
> > - Matt
> >
> >
> > -----Original Message-----
> > From: Garren Smith [mailto:garren@apache.org]
> > Sent: Thursday, August 24, 2017 12:34 PM
> > To: user@couchdb.apache.org
> > Subject: Re: Mango query with $eq operator returns no results, but
> > $regex does
> >
> > I think the best next step is to run the query against _explain
> > instead of _find. It will tell you which index it has selected.
> >
> > The other option is to add another selector with client_id > null.
> > I'm guessing it is choosing the type, customer_name index and you
> > want it to use the type, client_id index
> >
> > On Thu, 24 Aug 2017 at 6:42 PM Matt Cosentino
> > <mc...@cacorp.com>
> > wrote:
> >
> > > special: _id
> > > json: type, client_id
> > > json: last_payment
> > > json: type
> > > json: date
> > > json: date, time
> > > json: type, client_id, date
> > > json: datetime
> > > json: client_id
> > > json: type, customer_name
> > > json: customer_name
> > >
> > > { selector: { "type": { "$eq": "client" } } }
> > >
> > > - Matt
> > >
> > >
> > > -----Original Message-----
> > > From: Garren Smith [mailto:garren@apache.org]
> > > Sent: Thursday, August 24, 2017 11:00 AM
> > > To: user@couchdb.apache.org
> > > Subject: Re: Mango query with $eq operator returns no results, but
> > > $regex does
> > >
> > > Can you give me a full list of all your indexes and the query you
> > > are running.
> > >
> > > On Thu, 24 Aug 2017 at 5:45 PM Matt Cosentino
> > > <mc...@cacorp.com>
> > > wrote:
> > >
> > > > 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:mcosentino@cacorp.com]
> > > > Sent: Thursday, August 24, 2017 9:41 AM
> > > > To: user@couchdb.apache.org
> > > > 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:garren@apache.org]
> > > > Sent: Thursday, August 24, 2017 4:38 AM
> > > > To: user <us...@couchdb.apache.org>
> > > > 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
> > > > <mc...@cacorp.com>
> > > > 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
> > > > >
> > > > >
> > > >
> > >
> >
>
Re: Mango query with $eq operator returns no results, but $regex does
Posted by Garren Smith <ga...@apache.org>.
Could you supply some example docs so I can try and reproduce it.
On Thu, 24 Aug 2017 at 8:07 PM Matt Cosentino <mc...@cacorp.com> wrote:
> Yes.
>
> - Matt
>
>
> -----Original Message-----
> From: Garren Smith [mailto:garren@apache.org]
> Sent: Thursday, August 24, 2017 12:51 PM
> To: user@couchdb.apache.org
> Subject: Re: Mango query with $eq operator returns no results, but $regex
> does
>
> Do you have any docs with the field type = client?
>
> On Thu, 24 Aug 2017 at 7:47 PM Matt Cosentino <mc...@cacorp.com>
> wrote:
>
> > Tried that, it is using the type index. Isn't that what I want? That's
> > the only field in my selector.
> >
> > - Matt
> >
> >
> > -----Original Message-----
> > From: Garren Smith [mailto:garren@apache.org]
> > Sent: Thursday, August 24, 2017 12:34 PM
> > To: user@couchdb.apache.org
> > Subject: Re: Mango query with $eq operator returns no results, but
> > $regex does
> >
> > I think the best next step is to run the query against _explain
> > instead of _find. It will tell you which index it has selected.
> >
> > The other option is to add another selector with client_id > null. I'm
> > guessing it is choosing the type, customer_name index and you want it
> > to use the type, client_id index
> >
> > On Thu, 24 Aug 2017 at 6:42 PM Matt Cosentino <mc...@cacorp.com>
> > wrote:
> >
> > > special: _id
> > > json: type, client_id
> > > json: last_payment
> > > json: type
> > > json: date
> > > json: date, time
> > > json: type, client_id, date
> > > json: datetime
> > > json: client_id
> > > json: type, customer_name
> > > json: customer_name
> > >
> > > { selector: { "type": { "$eq": "client" } } }
> > >
> > > - Matt
> > >
> > >
> > > -----Original Message-----
> > > From: Garren Smith [mailto:garren@apache.org]
> > > Sent: Thursday, August 24, 2017 11:00 AM
> > > To: user@couchdb.apache.org
> > > Subject: Re: Mango query with $eq operator returns no results, but
> > > $regex does
> > >
> > > Can you give me a full list of all your indexes and the query you
> > > are running.
> > >
> > > On Thu, 24 Aug 2017 at 5:45 PM Matt Cosentino
> > > <mc...@cacorp.com>
> > > wrote:
> > >
> > > > 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:mcosentino@cacorp.com]
> > > > Sent: Thursday, August 24, 2017 9:41 AM
> > > > To: user@couchdb.apache.org
> > > > 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:garren@apache.org]
> > > > Sent: Thursday, August 24, 2017 4:38 AM
> > > > To: user <us...@couchdb.apache.org>
> > > > 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
> > > > <mc...@cacorp.com>
> > > > 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
> > > > >
> > > > >
> > > >
> > >
> >
>
RE: Mango query with $eq operator returns no results, but $regex
does
Posted by Matt Cosentino <mc...@cacorp.com>.
Yes.
- Matt
-----Original Message-----
From: Garren Smith [mailto:garren@apache.org]
Sent: Thursday, August 24, 2017 12:51 PM
To: user@couchdb.apache.org
Subject: Re: Mango query with $eq operator returns no results, but $regex does
Do you have any docs with the field type = client?
On Thu, 24 Aug 2017 at 7:47 PM Matt Cosentino <mc...@cacorp.com> wrote:
> Tried that, it is using the type index. Isn't that what I want? That's
> the only field in my selector.
>
> - Matt
>
>
> -----Original Message-----
> From: Garren Smith [mailto:garren@apache.org]
> Sent: Thursday, August 24, 2017 12:34 PM
> To: user@couchdb.apache.org
> Subject: Re: Mango query with $eq operator returns no results, but
> $regex does
>
> I think the best next step is to run the query against _explain
> instead of _find. It will tell you which index it has selected.
>
> The other option is to add another selector with client_id > null. I'm
> guessing it is choosing the type, customer_name index and you want it
> to use the type, client_id index
>
> On Thu, 24 Aug 2017 at 6:42 PM Matt Cosentino <mc...@cacorp.com>
> wrote:
>
> > special: _id
> > json: type, client_id
> > json: last_payment
> > json: type
> > json: date
> > json: date, time
> > json: type, client_id, date
> > json: datetime
> > json: client_id
> > json: type, customer_name
> > json: customer_name
> >
> > { selector: { "type": { "$eq": "client" } } }
> >
> > - Matt
> >
> >
> > -----Original Message-----
> > From: Garren Smith [mailto:garren@apache.org]
> > Sent: Thursday, August 24, 2017 11:00 AM
> > To: user@couchdb.apache.org
> > Subject: Re: Mango query with $eq operator returns no results, but
> > $regex does
> >
> > Can you give me a full list of all your indexes and the query you
> > are running.
> >
> > On Thu, 24 Aug 2017 at 5:45 PM Matt Cosentino
> > <mc...@cacorp.com>
> > wrote:
> >
> > > 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:mcosentino@cacorp.com]
> > > Sent: Thursday, August 24, 2017 9:41 AM
> > > To: user@couchdb.apache.org
> > > 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:garren@apache.org]
> > > Sent: Thursday, August 24, 2017 4:38 AM
> > > To: user <us...@couchdb.apache.org>
> > > 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
> > > <mc...@cacorp.com>
> > > 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
> > > >
> > > >
> > >
> >
>
Re: Mango query with $eq operator returns no results, but $regex does
Posted by Garren Smith <ga...@apache.org>.
Do you have any docs with the field type = client?
On Thu, 24 Aug 2017 at 7:47 PM Matt Cosentino <mc...@cacorp.com> wrote:
> Tried that, it is using the type index. Isn't that what I want? That's the
> only field in my selector.
>
> - Matt
>
>
> -----Original Message-----
> From: Garren Smith [mailto:garren@apache.org]
> Sent: Thursday, August 24, 2017 12:34 PM
> To: user@couchdb.apache.org
> Subject: Re: Mango query with $eq operator returns no results, but $regex
> does
>
> I think the best next step is to run the query against _explain instead of
> _find. It will tell you which index it has selected.
>
> The other option is to add another selector with client_id > null. I'm
> guessing it is choosing the type, customer_name index and you want it to
> use the type, client_id index
>
> On Thu, 24 Aug 2017 at 6:42 PM Matt Cosentino <mc...@cacorp.com>
> wrote:
>
> > special: _id
> > json: type, client_id
> > json: last_payment
> > json: type
> > json: date
> > json: date, time
> > json: type, client_id, date
> > json: datetime
> > json: client_id
> > json: type, customer_name
> > json: customer_name
> >
> > { selector: { "type": { "$eq": "client" } } }
> >
> > - Matt
> >
> >
> > -----Original Message-----
> > From: Garren Smith [mailto:garren@apache.org]
> > Sent: Thursday, August 24, 2017 11:00 AM
> > To: user@couchdb.apache.org
> > Subject: Re: Mango query with $eq operator returns no results, but
> > $regex does
> >
> > Can you give me a full list of all your indexes and the query you are
> > running.
> >
> > On Thu, 24 Aug 2017 at 5:45 PM Matt Cosentino <mc...@cacorp.com>
> > wrote:
> >
> > > 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:mcosentino@cacorp.com]
> > > Sent: Thursday, August 24, 2017 9:41 AM
> > > To: user@couchdb.apache.org
> > > 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:garren@apache.org]
> > > Sent: Thursday, August 24, 2017 4:38 AM
> > > To: user <us...@couchdb.apache.org>
> > > 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
> > > <mc...@cacorp.com>
> > > 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
> > > >
> > > >
> > >
> >
>
RE: Mango query with $eq operator returns no results, but $regex
does
Posted by Matt Cosentino <mc...@cacorp.com>.
Tried that, it is using the type index. Isn't that what I want? That's the only field in my selector.
- Matt
-----Original Message-----
From: Garren Smith [mailto:garren@apache.org]
Sent: Thursday, August 24, 2017 12:34 PM
To: user@couchdb.apache.org
Subject: Re: Mango query with $eq operator returns no results, but $regex does
I think the best next step is to run the query against _explain instead of _find. It will tell you which index it has selected.
The other option is to add another selector with client_id > null. I'm guessing it is choosing the type, customer_name index and you want it to use the type, client_id index
On Thu, 24 Aug 2017 at 6:42 PM Matt Cosentino <mc...@cacorp.com> wrote:
> special: _id
> json: type, client_id
> json: last_payment
> json: type
> json: date
> json: date, time
> json: type, client_id, date
> json: datetime
> json: client_id
> json: type, customer_name
> json: customer_name
>
> { selector: { "type": { "$eq": "client" } } }
>
> - Matt
>
>
> -----Original Message-----
> From: Garren Smith [mailto:garren@apache.org]
> Sent: Thursday, August 24, 2017 11:00 AM
> To: user@couchdb.apache.org
> Subject: Re: Mango query with $eq operator returns no results, but
> $regex does
>
> Can you give me a full list of all your indexes and the query you are
> running.
>
> On Thu, 24 Aug 2017 at 5:45 PM Matt Cosentino <mc...@cacorp.com>
> wrote:
>
> > 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:mcosentino@cacorp.com]
> > Sent: Thursday, August 24, 2017 9:41 AM
> > To: user@couchdb.apache.org
> > 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:garren@apache.org]
> > Sent: Thursday, August 24, 2017 4:38 AM
> > To: user <us...@couchdb.apache.org>
> > 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
> > <mc...@cacorp.com>
> > 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
> > >
> > >
> >
>
Re: Mango query with $eq operator returns no results, but $regex does
Posted by Garren Smith <ga...@apache.org>.
I think the best next step is to run the query against _explain instead of
_find. It will tell you which index it has selected.
The other option is to add another selector with client_id > null. I'm
guessing it is choosing the type, customer_name index and you want it to
use the type, client_id index
On Thu, 24 Aug 2017 at 6:42 PM Matt Cosentino <mc...@cacorp.com> wrote:
> special: _id
> json: type, client_id
> json: last_payment
> json: type
> json: date
> json: date, time
> json: type, client_id, date
> json: datetime
> json: client_id
> json: type, customer_name
> json: customer_name
>
> { selector: { "type": { "$eq": "client" } } }
>
> - Matt
>
>
> -----Original Message-----
> From: Garren Smith [mailto:garren@apache.org]
> Sent: Thursday, August 24, 2017 11:00 AM
> To: user@couchdb.apache.org
> Subject: Re: Mango query with $eq operator returns no results, but $regex
> does
>
> Can you give me a full list of all your indexes and the query you are
> running.
>
> On Thu, 24 Aug 2017 at 5:45 PM Matt Cosentino <mc...@cacorp.com>
> wrote:
>
> > 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:mcosentino@cacorp.com]
> > Sent: Thursday, August 24, 2017 9:41 AM
> > To: user@couchdb.apache.org
> > 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:garren@apache.org]
> > Sent: Thursday, August 24, 2017 4:38 AM
> > To: user <us...@couchdb.apache.org>
> > 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
> > <mc...@cacorp.com>
> > 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
> > >
> > >
> >
>
RE: Mango query with $eq operator returns no results, but $regex
does
Posted by Matt Cosentino <mc...@cacorp.com>.
special: _id
json: type, client_id
json: last_payment
json: type
json: date
json: date, time
json: type, client_id, date
json: datetime
json: client_id
json: type, customer_name
json: customer_name
{ selector: { "type": { "$eq": "client" } } }
- Matt
-----Original Message-----
From: Garren Smith [mailto:garren@apache.org]
Sent: Thursday, August 24, 2017 11:00 AM
To: user@couchdb.apache.org
Subject: Re: Mango query with $eq operator returns no results, but $regex does
Can you give me a full list of all your indexes and the query you are running.
On Thu, 24 Aug 2017 at 5:45 PM Matt Cosentino <mc...@cacorp.com> wrote:
> 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:mcosentino@cacorp.com]
> Sent: Thursday, August 24, 2017 9:41 AM
> To: user@couchdb.apache.org
> 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:garren@apache.org]
> Sent: Thursday, August 24, 2017 4:38 AM
> To: user <us...@couchdb.apache.org>
> 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
> <mc...@cacorp.com>
> 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
> >
> >
>
Re: Mango query with $eq operator returns no results, but $regex does
Posted by Garren Smith <ga...@apache.org>.
Can you give me a full list of all your indexes and the query you are
running.
On Thu, 24 Aug 2017 at 5:45 PM Matt Cosentino <mc...@cacorp.com> wrote:
> 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:mcosentino@cacorp.com]
> Sent: Thursday, August 24, 2017 9:41 AM
> To: user@couchdb.apache.org
> 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:garren@apache.org]
> Sent: Thursday, August 24, 2017 4:38 AM
> To: user <us...@couchdb.apache.org>
> 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 <mc...@cacorp.com>
> 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
> >
> >
>
RE: Mango query with $eq operator returns no results, but $regex
does
Posted by Matt Cosentino <mc...@cacorp.com>.
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:mcosentino@cacorp.com]
Sent: Thursday, August 24, 2017 9:41 AM
To: user@couchdb.apache.org
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:garren@apache.org]
Sent: Thursday, August 24, 2017 4:38 AM
To: user <us...@couchdb.apache.org>
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 <mc...@cacorp.com>
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
>
>
RE: Mango query with $eq operator returns no results, but $regex
does
Posted by Matt Cosentino <mc...@cacorp.com>.
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:garren@apache.org]
Sent: Thursday, August 24, 2017 4:38 AM
To: user <us...@couchdb.apache.org>
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 <mc...@cacorp.com>
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
>
>
Re: Mango query with $eq operator returns no results, but $regex does
Posted by Garren Smith <ga...@apache.org>.
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 <mc...@cacorp.com>
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
>
>