[teiid-issues] [JBoss JIRA] (TEIID-4972) Couchbase - query with comparison criteria not properly translated
Juraj Duráni created TEIID-4972:
-----------------------------------
Summary: 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
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)