[teiid-issues] [JBoss JIRA] (TEIID-4970) Couchbase - GROUP BY returns empty result
RH Bugzilla Integration (JIRA)
issues at jboss.org
Tue Oct 24 09:06:00 EDT 2017
[ https://issues.jboss.org/browse/TEIID-4970?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13481205#comment-13481205 ]
RH Bugzilla Integration commented on TEIID-4970:
------------------------------------------------
Van Halbert <vhalbert at redhat.com> changed the Status of [bug 1466155|https://bugzilla.redhat.com/show_bug.cgi?id=1466155] from MODIFIED to ON_QA
> 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
> Fix For: 10.0, 8.12.x-6.4, 9.3.1
>
>
> 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.5.0#75005)
More information about the teiid-issues
mailing list