[jira] [Created] (GEODE-7655) Prevent ClassCastException while running nested queries

["Nabarun Nag (Jira)" <ji...@apache.org>]

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)