Queries using two replicated caches give duplicate records
I have a cluster with two replicated caches. A SQL query joining the two caches is not returning correct results. If my cluster has two nodes, it gives double the records... I did a distinct in the query and it returned correctly.
Is this a known issue? Or am I doing something wrong.