The following does not return expected result.
select * from index1 where name=“d2”
The result would be
But “select distinct name from index1” produces
Both queries should return the same result but we get different results.