[
https://issues.apache.org/jira/browse/CALCITE-3741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17017638#comment-17017638
]
james601232 commented on CALCITE-3741:
--------------------------------------
Dear [~amaliujia]
we have a open project quicksql. it's use jdbc:calcite method query
mongodb. type sql "select * from products order by score". calcite analysis and
optimistc the sql found more than one “order by score” key word in sql. eg.
“select * from products {color:#FF0000}order by score order by score{color}”
{color:#172b4d}. I tried debug codes and found SqlValidatorImpl class deal
order by logic. but i don't known how to cope it. hopeful getting help. thank
u so much {color}
{color:#172b4d}!image-2020-01-17-09-40-47-906.png!{color}
> 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
>
>
> 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)
