Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-4969

Couchbase - ORDER BY returns empty result

    Details

      Description

      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].

      [1] Query

      SELECT IntKey AS Total FROM BQT1.SmallA ORDER BY IntKey
      

      [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
      

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                jdurani Juraj Duráni
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: