Juraj Duráni created TEIID-4970: ----------------------------------- Summary: Couchbase - GROUP BY returns empty result Key: TEIID-4970 URL: https://issues.jboss.org/browse/TEIID-4970 Project: Teiid Issue Type: Bug Components: Misc. Connectors Affects Versions: 8.12.x-6.4 Reporter: Juraj Duráni Assignee: Steven Hawkins Priority: Blocker Issuing query like \[1\] returns empty result. Query seems to not be properly translated to source-specific query \[2\] {code:sql|title=\[1\] Query} SELECT IntKey, SUM(IntKey) AS Total FROM BQT1.SmallA GROUP BY IntKey {code} {code:plain|title=\[2\] Source-specific query - GROUP BY clause refers to cb_c2 instead of cb_c1} 09:53:09,066 DEBUG [org.teiid.CONNECTOR] (Worker5_QueryProcessorQueue64) TEIID29001 Source-specific Query: SELECT `$cb_c1_IntKey`, SUM(`$cb_c2_IntKey`) FROM `dvqe_small` `$cb_t1` LET `$cb_c1_IntKey` = `$cb_t1`.`IntKey`, `$cb_c2_IntKey` = `$cb_t1`.`IntKey` WHERE `$cb_t1`.`type` = 'SmallA' GROUP BY `$cb_c2_IntKey` {code} -- This message was sent by Atlassian JIRA (v7.2.3#72005)