You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "Wail Y. Alkowaileet (Jira)" <ji...@apache.org> on 2019/10/22 18:35:00 UTC
[jira] [Updated] (ASTERIXDB-2663) Revise correlated sub-queries
with aggregates
[ https://issues.apache.org/jira/browse/ASTERIXDB-2663?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Wail Y. Alkowaileet updated ASTERIXDB-2663:
-------------------------------------------
Description:
Query in ASTERIXDB-1581 seems to generate empty aggregates?
{code:java}
...
group by ([$$163 := $$164]) decor ([$$145 := $$200]) {
aggregate [] <- []
-- AGGREGATE |LOCAL|
aggregate [] <- []
-- AGGREGATE |LOCAL|
aggregate [] <- []
-- AGGREGATE |LOCAL|
select (not(is-missing($$175)))
-- STREAM_SELECT |LOCAL|
nested tuple source
-- NESTED_TUPLE_SOURCE |LOCAL|
}
....
{code}
was:
Query in ASTERIXDB-1581 seems to generate empty aggregates?
{code:java}
group by ([$$163 := $$164]) decor ([$$145 := $$200]) {
aggregate [] <- []
-- AGGREGATE |LOCAL|
aggregate [] <- []
-- AGGREGATE |LOCAL|
aggregate [] <- []
-- AGGREGATE |LOCAL|
select (not(is-missing($$175)))
-- STREAM_SELECT |LOCAL|
nested tuple source
-- NESTED_TUPLE_SOURCE |LOCAL|
}
{code}
> Revise correlated sub-queries with aggregates
> ---------------------------------------------
>
> Key: ASTERIXDB-2663
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-2663
> Project: Apache AsterixDB
> Issue Type: Bug
> Reporter: Wail Y. Alkowaileet
> Priority: Minor
>
> Query in ASTERIXDB-1581 seems to generate empty aggregates?
>
> {code:java}
> ...
> group by ([$$163 := $$164]) decor ([$$145 := $$200]) {
> aggregate [] <- []
> -- AGGREGATE |LOCAL|
> aggregate [] <- []
> -- AGGREGATE |LOCAL|
> aggregate [] <- []
> -- AGGREGATE |LOCAL|
> select (not(is-missing($$175)))
> -- STREAM_SELECT |LOCAL|
> nested tuple source
> -- NESTED_TUPLE_SOURCE |LOCAL|
> }
> ....
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)