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

Couchbase - ORDER BY returns empty result

    XMLWordPrintable

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
      Unable to find source-code formatter for language: plain. Available languages are: actionscript, ada, applescript, bash, c, c#, c++, cpp, css, erlang, go, groovy, haskell, html, java, javascript, js, json, lua, none, nyan, objc, perl, php, python, r, rainbow, ruby, scala, sh, sql, swift, visualbasic, xml, yaml
      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
      

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            jdurani Juraj DurĂ¡ni (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: