You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@geode.apache.org by "Nabarun Nag (Jira)" <ji...@apache.org> on 2020/01/08 17:48:00 UTC
[jira] [Closed] (GEODE-7655) Prevent ClassCastException while
running nested queries
[ 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)