[COMPASS-2988] Cannot filter using binary data if BSON is of type 3 Created: 11/Jul/18  Updated: 26/Jun/23

Status: Open
Project: Compass
Component/s: Query
Affects Version/s: 1.14.6
Fix Version/s: None

Type: Bug Priority: Minor - P4
Reporter: Rick Jones Assignee: Unassigned
Resolution: Unresolved Votes: 3
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Related
related to COMPASS-1083 LUUID/NUUID/BinData support for filters Closed
is related to COMPASS-2709 As a Compass user I want to view, sea... Closed
Story Points: 5

 Description   

I have a collection in a mongo database that contains a document that looks as follows:

 

{
  _id : ObjectId("5a70ce9198145b0628c70665"),
  DeviceId: BinData(3, 'uBUP0V1/RkWYzGT1dS/8Xw==')
}

 

 

In compass this shows up as

{
  _id : ObjectId("5a70ce9198145b0628c70665"),
  DeviceId: Binary('uBUP0V1/RkWYzGT1dS/8Xw==')
}

In compass, I attempt to filter for this information by entering the following

{DeviceId: Binary('uBUP0V1/RkWYzGT1dS/8Xw==')}

however, no results are returned. I have also tried filtering

 

{DeviceId: Binary('uBUP0V1/RkWYzGT1dS/8Xw=='), 3}

I believe there is an issue with specifying searching for BinData of types that are not 0 from compass.

 

 



 Comments   
Comment by Yang Liu [ 30/Mar/19 ]

I have the same problem for UUID (type 4). Is there any walkaround? 

Generated at Wed Feb 07 22:31:46 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.