count of group by column return 1 over join ------------------------------------------- Key: TEIID-2397 URL: https://issues.jboss.org/browse/TEIID-2397 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Critical Fix For: 8.3 A query of the form: select e1, count(e1) from pm1.g1, (select 1 from pm1.g2 limit 1) x group by e1 Will fail to return the proper count for e1 as the decomposition is erroneously considering the decomposed count aggregate as unnecessary.