@Test
  public void testHashIndexKeySetQueryForLocalRegion() throws Exception {
    createLocalRegion("portfolios");
    createData(region, 200);
    helpTestHashIndexForQuery("SELECT * FROM " + SEPARATOR + "portfolios.keySet p WHERE p = '1'",
        "p",
        SEPARATOR + "portfolios.keySet p");
  }
Tests that hash index is used and that it returns the correct result for local region
geode-core/src/integrationTest/java/org/apache/geode/cache/query/internal/index/HashIndexQueryIntegrationTest.java