You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Danny Chen (Jira)" <ji...@apache.org> on 2020/01/16 08:16:00 UTC

[jira] [Commented] (CALCITE-3741) duplicate ‘ordre by‘ key word generate in select

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