[teiid-issues] [JBoss JIRA] (TEIID-3312) Subquery field giving a group by error

Mark Tawk created TEIID-3312: -------------------------------- Summary: Subquery field giving a group by error Key: TEIID-3312 URL: https://issues.jboss.org/browse/TEIID-3312 Project: Teiid Issue Type: Feature Request Reporter: Mark Tawk Assignee: Steven Hawkins Priority: Critical Hello, I'm using Teiid 8.9.0.Alpha2, Mysql 5.7 and mysql5 Translator I have query, in which i'm using a subquery field containing a criteria using a date field coming from the main query YEAR("activities"."ActivityDate"). Teiid is forcing me to put "activities"."ActivityDate" in main query group by, while i want to group my data by YEAR("activities"."ActivityDate"). I'm getting the following teiid error : TEIID30020 Processing exception for request fOwqPyy91bbL.0 'TEIID30492 [activities.ActivityDate] cannot be used outside of aggregate functions since they are not present in a GROUP BY clause.'. Here is the query: select COUNT( distinct "activities"."ActEmpName") as "activities_ActEmpName" ,YEAR(activities.ActivityDate) as "activities_ActivityDate" ,(select COUNT( distinct "employees_sub"."EmpFullName") as "employees_EmpFullName" from "TrackerModel".tracker_datawarehouse."employees" "employees_sub" where ( YEAR(employees_sub.EmpHireDate) <= YEAR("activities"."ActivityDate")) LIMIT 0 , 1) as "SubQuery Employees" from "TrackerModel".tracker_datawarehouse."activities" "activities" group by YEAR(activities.ActivityDate) LIMIT 0 , 10 -- This message was sent by Atlassian JIRA (v6.3.11#6341)