[DRILL-4173] Query did not return all documents if collection using a hashed shard key

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.3.0
• Component/s: Storage - MongoDB

Environment

Windows 2012

• Assignee: Jason Altekruse
• Reporter: Yuqing Tang
• Created: 08/Dec/15 16:12
• Updated: 28/Sep/23 14:56

Description

MongoDB 3.0.6

If a collection used a hashed shard key (

{ "shardkey": "hashed" }

), queries like "select * from ..." may not return all documents which should be returned from the collection.

Test Case:
Create 3 mongos, 3 config, 3 replicaset each with 3 mongod.
Create one collection with hashed shard key.
Insert 6 documents to this collection with shard key value 1,2,3,4,5,6
Do a query select * from ....
Only 2,3,4 will be returned.