Hi Colin,
When you perform a Union or Intersect in a nanoflow, it compares objects by their memory references rather than GUIDs. As a result, even if two objects represent the same entity in the database, they might not be considered Equal on the client-side, and the operation doesn't remove duplicates.