Details
-
Task
-
Status: Closed
-
Minor - P4
-
Resolution: Done
-
None
-
None
Description
Currently, when we specify the "on" field using a field that is partially indexed with a unique constraint, we throw an error informing the user that an index isn't found.
Error: command failed: {
|
"ok" : 0,
|
"errmsg" : "Cannot find index to verify that join fields will be unique",
|
"code" : 51183,
|
"codeName" : "Location51183"
|
} : aggregate failed :
|
Our source indicates that a field that is partially uniquely indexed is insufficient as a unique index.
It's not clear in our $merge documentation that a partially indexed field is insufficient for specifying "on" in $merge.
Attachments
Issue Links
- is related to
-
SERVER-60104 $merge not working with partial index
-
- Closed
-