[teiid-issues] [JBoss JIRA] (TEIID-4970) Couchbase - GROUP BY returns empty result
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)