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

    String[] queries = new String[] {
        "<trace>select * from " + SEPARATOR + "region1 c, " + SEPARATOR
            + "region2 s where c.pkid = 1 and c.id > 1 and c.id < 10 and c.pkid = s.pkid",
        "<trace>select * from " + SEPARATOR + "region1 c, " + SEPARATOR
            + "region2 s where c.pkid >= 0 and c.pkid < 10 and c.id < 10 and c.pkid = s.pkid"};

    // just need enough so that there are 1-10 ids per pkid
    for (int i = 0; i < 1000; i++) {
      region1.put(i, new Customer(i % 5, i % 10));
      region2.put(i, new Customer(i, i));
    }

    executeQueriesWithIndexCombinations(queries, new DefaultIndexCreatorCallback(qs) {
      @Override
      protected String[] createIndexTypesForRegion1() {
        return new String[] {"Compact", "Hash"};
      }
    }, false /* want to compare actual results and not size only */);
  }
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