[ASTERIXDB-2403] Group-by can produce empty array result

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.9.4
• Fix Version/s: 0.9.4.2
• Assignee: Dmitry Lychagin
• Reporter: Xikui Wang
• Created: 26/Jun/18 23:49
• Updated: 10/Apr/19 18:19

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.

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;