[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-2382) No error message for query with aggregate function and no group by clause

No error message for query with aggregate function and no group by clause ------------------------------------------------------------------------- Key: TEIIDDES-2382 URL: https://issues.jboss.org/browse/TEIIDDES-2382 Project: Teiid Designer Issue Type: Bug Components: Transformations Affects Versions: 8.6 Reporter: Jan Stastny Assignee: Barry LaFond In designer when defining a table in view model with following transformation query, bad error message is returned to user. SELECT cust.id AS customer_id, SUM(ord.amount) AS total_amount FROM customers AS cust INNER JOIN orders AS ord ON cust.id = ord.customer_id GROUP BY cust.id; When user forgets to write the GROUP BY clause then error with following message occurs: "ERROR:ERROR". When I execute similar query via teeid driver then I get very useful message: "Error: Remote org.teiid.api.exception.query.QueryValidatorException: Non-constant, non-aggregate expression cust.id cannot be mixed with aggregate functions and implicit grouping." It would be very helpful if Teiid designer gave similar message instead of the "ERROR:ERROR" one.