assertRowCount(9, s.executeQuery("select distinct a.c1, a.c3, a.c2 from two a, two b where a.c1 = b.c1"));
rtsp = SQLUtilities.getRuntimeStatisticsParser(s);
assertTrue(rtsp.eliminatedDuplicates());
assertRowCount(9, s.executeQuery("select distinct a.c1, a.c3, a.c2 from two a, two b where a.c1 = b.c1 and a.c2 = 1"));
rtsp = SQLUtilities.getRuntimeStatisticsParser(s);
assertTrue(rtsp.eliminatedDuplicates());
// both keys from unique index in where clause but joined to different tables
assertRowCount(1, s.executeQuery("select distinct a.c1 from one a, two b, three c where a.c1 = b.c1 and c.c1 = b.c3 and a.c1 = 1"));
rtsp = SQLUtilities.getRuntimeStatisticsParser(s);
assertTrue(rtsp.eliminatedDuplicates());