Xikui Wang created ASTERIXDB-2578:
-------------------------------------
Summary: GROUP AS creates illegal state
Key: ASTERIXDB-2578
URL: https://issues.apache.org/jira/browse/ASTERIXDB-2578
Project: Apache AsterixDB
Issue Type: Bug
Reporter: Xikui Wang
Attachments: init_dataverse.txt
{code}
USE HW8;
SELECT u.id, avg(obs.rate) as avg_rate, InterestGroups
FROM Observations obs, Users u, Observers obr, Interests i
WHERE obs.kind = 'heart_rate' AND obr.ownedBy = u.id AND obs.observerId =
obr.id AND i.name in u.memberOf AND i.topic = "diabetes"
GROUP BY u.id
GROUP AS InterestGroups(i as ig);
{code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
