Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-3741

duplicate ‘ordre by‘ key word generate in select

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.17.0
    • Fix Version/s: None
    • Component/s: mongodb-adapter
    • Labels:
      None

      Description

      Hi

         I encoutner a problem use calcite query mongodb.  my select sql is "select * from products order by score". unfortunatly.  calcite analysis sql concat redundant 'order by score'  in sql.

      debug screenshot as following:

      could you help me what wrong happen. 

      Tks 

       

        Attachments

        1. image-2020-01-17-10-43-28-765.png
          20 kB
          james601232
        2. image-2020-01-17-09-40-47-906.png
          29 kB
          james601232
        3. image-2020-01-16-14-28-57-662.png
          269 kB
          james601232

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              james601232 james601232
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated: