Nabarun Nag created GEODE-7655: ---------------------------------- Summary: Prevent ClassCastException while running nested queries Key: GEODE-7655 URL: https://issues.apache.org/jira/browse/GEODE-7655 Project: Geode Issue Type: Bug Components: querying Reporter: Nabarun Nag
While running a nested query like : {noformat} select productId, productCodes['GMI'], contractSize from /product where contractSize = null and productCodes['GMI'] in (select distinct b.productCodes['GMI'] from /product b where b.contractSize != null and b.status='ACTIVE') LIMIT 2000 {noformat} Following Indexes need to be created for the Exception to occur 1. Primary Key Index on productID 2. Functional index on productID 3. Functional index on productCodes['GMI'] -- This message was sent by Atlassian Jira (v8.3.4#803005)