[
https://issues.apache.org/jira/browse/ASTERIXDB-866?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15133123#comment-15133123
]
Taewoo Kim commented on ASTERIXDB-866:
--------------------------------------
SORT_GROUP_BY requires an explicit subplan, it may be hard to add this into a
general select plan.Thanks to Jianfeng, I found a solution. The solution is
adding DISTINCT between SORT after the secondary index search and the primary
index search to see only one PKs.
> Incorrect query results possible when accessing secondary indexes
> -----------------------------------------------------------------
>
> Key: ASTERIXDB-866
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-866
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: AsterixDB, Optimizer
> Reporter: asterixdb-importer
> Assignee: Taewoo Kim
>
> Incorrect query results possible when accessing secondary indexes
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
