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)