[teiid-issues] [JBoss JIRA] (TEIID-4969) Couchbase - ORDER BY returns empty result

Couchbase - ORDER BY returns empty result ----------------------------------------- Key: TEIID-4969 URL: https://issues.jboss.org/browse/TEIID-4969 Project: Teiid Issue Type: Bug Components: Misc. Connectors Affects Versions: 8.12.12.6_4 Reporter: Juraj Duráni Assignee: Steven Hawkins Priority: Blocker Fix For: 10.0, 8.12.12.6_4, 9.3.1 Issuing query like \[1\] returns empty result. From what I can see, query seems to not be properly translated to the source-specific query \[2\]. {code:sql|title=\[1\] Query} SELECT IntKey AS Total FROM BQT1.SmallA ORDER BY IntKey {code} {code:plain|title=\[2\] Source-specific query - c_0 is not defined anywhere} 09:40:11,748 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue60) TEIID29001 Source-specific Query: SELECT `$cb_c1_IntKey` FROM `dvqe_small` `$cb_t1` LET `$cb_c1_IntKey` = `$cb_t1`.`IntKey`c_0 WHERE `$cb_t1`.`type` = 'SmallA' ORDER BY c_0 {code}