[SERVER-254] Indexing on field causes no results from query Created: 24/Aug/09  Updated: 12/Jul/16  Resolved: 31/Aug/09

Status: Closed
Project: Core Server
Component/s: Querying
Affects Version/s: 0.9.10
Fix Version/s: 1.1.0

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

Windows XP 32-bit
Intel Core2 6400 2.13GHz
2 GB RAM


Attachments: Zip Archive data.zip    
Participants:

 Description   

Start the server with the attached database.

Run the following in the Mongo Console:

> db.properties.find({ '46' :

{ $gt : 10 }

})

You should get one result.

> db.properties.ensureIndex(

{ '46' : 1}

)
true
> db.properties.find({ '46' :

{ $gt : 10 }

})

You should get zero results.

> db.properties.dropIndex(

{ '46' : 1}

)

{"nIndexesWas" : 2 , "ok" : 1}

> db.properties.find({ '46' :

{ $gt : 10 }

})

You should get one result again.



 Comments   
Comment by Eliot Horowitz (Inactive) [ 15/Sep/09 ]

released in 1.1.0

Comment by Eliot Horowitz (Inactive) [ 31/Aug/09 ]

this if fixed in the 1.1 branch
you can get it in the nightlies after 8/28
but you will have to drop the index and re-create

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