[CALCITE-3741] duplicate ‘ordre by‘ key word generate in select

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.17.0
• Component/s: mongodb-adapter
• Assignee: Unassigned
• Reporter: james601232
• Created: 16/Jan/20 06:30
• Updated: 20/Jan/20 01:28

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