[SERVER-708] Lookup with indexes returns wrong data. Created: 06/Mar/10  Updated: 12/Jul/16  Resolved: 06/Mar/10

Status: Closed
Project: Core Server
Component/s: Index Maintenance
Affects Version/s: None
Fix Version/s: 1.3.4

Type: Bug Priority: Major - P3
Reporter: Stavros Korokithakis Assignee: Eliot Horowitz (Inactive)
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Ubuntu 9.10 32-bit, using the latest package available in the repo.


Participants:

 Description   

I created an index on cluster, cluster_depth, visited (ascending on all), and querying I get this:

In [60]: people.find_one({"cluster": cluster, "cluster_depth": 0, "visited": {"$exists": True}})
Out[60]:

{u'_id': u'Boytrash', u'cluster': 0, u'cluster_depth': 0, u'friends': [u'b1u1rner', u'javierodrigo', u'Xpato__X', u'flugu'], u'got_friends': True, u'real_name': u'Roberto'}

Visited does not exist, it is wrong. Removing the index gives me the correct reply.



 Comments   
Comment by auto [ 06/Mar/10 ]

Author:

{'login': 'erh', 'name': 'Eliot Horowitz', 'email': 'eliot@10gen.com'}

Message: fix exists with index SERVER-708
http://github.com/mongodb/mongo/commit/da4507b7c6fb088f55a368d404e15ce349ada692

Generated at Thu Feb 08 02:54:56 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.