[jira] [Updated] (ASTERIXDB-2403) Group-by can produce empty array result

["Xikui Wang (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/ASTERIXDB-2403?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Xikui Wang updated ASTERIXDB-2403:
----------------------------------
    Description: 
Following query can produce a empty list. If we put this query into a sub-query and insert it into dataset with auuid, this can cause a meaningless record.
{code}
drop dataverse test if exists;
create dataverse test;
use test;
create type testType as open {
id : int64
};
create dataset testDataset(testType) primary key id;
use test;
let val1=(select country, count(*) from testDataset group by country)
select val1;
{code}


  was:
Following query can produce a empty list. If we put this query into a sub-query and insert it into dataset with auuid, this can cause a meaningless record.
[code]
drop dataverse test if exists;
create dataverse test;
use test;
create type testType as open {
id : int64
};
create dataset testDataset(testType) primary key id;
use test;
let val1=(select country, count(*) from testDataset group by country)
select val1;
[code]



> Group-by can produce empty array result
> ---------------------------------------
>
>                 Key: ASTERIXDB-2403
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-2403
>             Project: Apache AsterixDB
>          Issue Type: Bug
>            Reporter: Xikui Wang
>            Priority: Major
>
> Following query can produce a empty list. If we put this query into a sub-query and insert it into dataset with auuid, this can cause a meaningless record.
> {code}
> drop dataverse test if exists;
> create dataverse test;
> use test;
> create type testType as open {
> id : int64
> };
> create dataset testDataset(testType) primary key id;
> use test;
> let val1=(select country, count(*) from testDataset group by country)
> select val1;
> {code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)