Arthi, This makes me think that the second cache is not replicated due to some misconfiguration, or something else is wrong in your code. If you want us to take a look, please provide the whole test (ideally as a small GitHub project). Currently it's not clear what's going on. As I said, if one the caches is replicated, affinity should not influence the query result.
-Val -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/SQL-gives-incorrect-results-tp4049p4092.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.