@Test
  public void testBug40333_InLocalRegion_2() throws Exception {
    CacheUtils.startCache();
    final Cache cache = CacheUtils.getCache();
    AttributesFactory attributesFactory = new AttributesFactory();
    RegionAttributes ra = attributesFactory.create();
    final Region region = cache.createRegion("new_pos", ra);
    String queryStr = " select distinct r.name, pVal, r.\"type\"  "
        + " from " + SEPARATOR + "new_pos r , r.positions.values pVal where "
        + " ( r.name IN Set('name_11' , 'name_12') OR false ) AND pVal.mktValue = 1.00";
    bug40333Simulation(region, queryStr);
  }
Tests the where clause formed with CompiledComparison nesting with CompiledIN
geode-core/src/integrationTest/java/org/apache/geode/cache/query/functional/MiscJUnitTest.java