[
https://issues.apache.org/jira/browse/CALCITE-3741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17017668#comment-17017668
]
james601232 commented on CALCITE-3741:
--------------------------------------
Dear [~icshuo]
type sql is "select * from products {color:#ff0000}order by
score{color}". but debug pic show two order by score words in
{color:#de350b}node{color} and {color:#de350b}orderBy{color} struct.
why node and orderBy have more than one order by score word. do it normally?
!image-2020-01-17-10-43-28-765.png!
> 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,
> image-2020-01-17-09-40-47-906.png, image-2020-01-17-10-43-28-765.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)
