[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 |
||
| Attachments: |
|
| 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}) }) 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 |