[ https://issues.apache.org/jira/browse/CALCITE-3741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17016659#comment-17016659 ]
Danny Chen commented on CALCITE-3741: ------------------------------------- Why you write multiple "order by"s in your query, i tried MySQL 5.6 and PostgreSQL 11g, they all fails with such syntax. > duplicate ‘ordre by‘ key word generate in select > ------------------------------------------------ > > Key: CALCITE-3741 > URL: https://issues.apache.org/jira/browse/CALCITE-3741 > Project: Calcite > Issue Type: Bug > Components: mongodb-adapter > Affects Versions: 1.17.0 > Reporter: james601232 > Priority: Major > Attachments: image-2020-01-16-14-28-57-662.png > > > 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: > !image-2020-01-16-14-28-57-662.png! > could you help me what wrong happen. > Tks > -- This message was sent by Atlassian Jira (v8.3.4#803005)