[
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)
