[ https://issues.apache.org/jira/browse/GEODE-7655?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Nabarun Nag closed GEODE-7655. ------------------------------ > 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 > Priority: Major > Fix For: 1.12.0 > > Time Spent: 50m > Remaining Estimate: 0h > > 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)