[teiid-issues] [JBoss JIRA] (TEIID-4972) Couchbase - query with comparison criteria not properly translated

[RH Bugzilla Integration (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13435556#comment-13435556 ] 

RH Bugzilla Integration commented on TEIID-4972:
------------------------------------------------

Van Halbert <vhalbert at redhat.com> changed the Status of [bug 1466182|https://bugzilla.redhat.com/show_bug.cgi?id=1466182] from NEW to MODIFIED

> Couchbase - query with comparison criteria not properly translated
> ------------------------------------------------------------------
>
>                 Key: TEIID-4972
>                 URL: https://issues.jboss.org/browse/TEIID-4972
>             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 simple query with comparison criteria like \[1\] returns empty result. From what I can see, the query is not properly translated - it is translated to query with syntax error \[2\].
> Another issue here which I can see is that Teiid does not provide any information to the user that query actually failed. Only empty result is returned. This one, I will report it as a separate issue.
> {code:sql|title=\[1\] Query}
> SELECT BQT1.SmallA.FloatNum FROM BQT1.SmallA WHERE BQT1.SmallA.FloatNum = 7
> {code}
> {code:plain|title=\[2\] Source-specific query}
> 10:16:09,749 DEBUG [org.teiid.CONNECTOR] (Worker12_QueryProcessorQueue86) TEIID29001 Source-specific Query: SELECT TONUMBER(`$cb_c1_FloatNum`) FROM `dvqe_small` `$cb_t1` LET `$cb_c1_FloatNum` = `$cb_t1`.`FloatNum`TONUMBER() WHERE TONUMBER(`$cb_c1_FloatNum`) = 7.0 AND `$cb_t1`.`type` = 'SmallA'
> {code}



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)