@Test
  public void testSingleFilterWithSingleEquijoinOneToManyMapping() throws Exception {
    createRegions();

    String[] queries =
        new String[] {"select * from " + SEPARATOR + "region1 c, " + SEPARATOR
            + "region2 s where c.pkid=1 and c.pkid = s.pkid",
            "select * from " + SEPARATOR + "region1 c, " + SEPARATOR
                + "region2 s where c.pkid=1 and s.pkid = c.pkid",
            "select * from " + SEPARATOR + "region1 c, " + SEPARATOR
                + "region2 s where c.pkid = s.pkid and c.pkid=1",
            "select * from " + SEPARATOR + "region1 c, " + SEPARATOR
                + "region2 s where s.pkid = c.pkid and c.pkid=1",
            "select distinct * from " + SEPARATOR + "region1 c, " + SEPARATOR
                + "region2 s where s.pkid = c.pkid and c.pkid=1"};

    for (int i = 0; i < 1000; i++) {
      region1.put(i, new Customer(i, i));
      region2.put(i, new Customer(i % 100, i));
    }

    executeQueriesWithIndexCombinations(queries, new DefaultIndexCreatorCallback(qs) {
      @Override
      protected String[] createIndexTypesForRegion2() {
        return new String[] {"Compact", "Hash"};
      }
    }, false);
  }
We do not want to test this with Primary Key on the many side or else only 1 result will be
returned
geode-core/src/integrationTest/java/org/apache/geode/cache/query/internal/index/EquiJoinIntegrationTest.java