You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "Xikui Wang (JIRA)" <ji...@apache.org> on 2018/06/26 23:50:00 UTC

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

Xikui Wang created ASTERIXDB-2403:
-------------------------------------

             Summary: 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


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)