couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Matt Cosentino <mcosent...@cacorp.com>
Subject RE: Mango query with $eq operator returns no results, but $regex does
Date Thu, 21 Sep 2017 17:27:39 GMT
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 <wohali@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 <wohali@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" <mcosentino@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 <mcosentino@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 <mcosentino@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 
> > <mcosentino@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 
> > > <mcosentino@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 
> > > > <mcosentino@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 <user@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 
> > > > > <mcosentino@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
> > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>
Mime
View raw message