@Test
  public void testHashIndexEntriesQueryForLocalRegion() throws Exception {
    createLocalRegion("portfolios");
    createData(region, 200);
    helpTestHashIndexForQuery(
        "SELECT * FROM " + SEPARATOR + "portfolios.entries p WHERE p.key = '1'", "p.key",
        SEPARATOR + "portfolios.entries 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