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)