You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Jiatao Tao (Jira)" <ji...@apache.org> on 2020/06/17 02:05:00 UTC

[jira] [Assigned] (CALCITE-1973) Get sql node's pos error when SQL has join

     [ https://issues.apache.org/jira/browse/CALCITE-1973?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jiatao Tao reassigned CALCITE-1973:
-----------------------------------

    Assignee: Jiatao Tao

> Get sql node's pos error when SQL has join
> ------------------------------------------
>
>                 Key: CALCITE-1973
>                 URL: https://issues.apache.org/jira/browse/CALCITE-1973
>             Project: Calcite
>          Issue Type: Bug
>            Reporter: Jiatao Tao
>            Assignee: Jiatao Tao
>            Priority: Major
>         Attachments: WX20170904-112559.png, screenshot-2.png
>
>
> Hi, I met some problems with parser.
> Parse SQL like "select a from t t1 join tt t2 on t1.c = tt.c", and the from's pos is 20,23("oin")(obviously not).
> And I test another query "select a from (select a from KYLIN_SALES) t inner join KYLIN_SALES tt on t.price = tt.price", and get from's pos is 51, 54("oin"), seems that pos is take "join"
> Hope your advice
> Best Wishes
> Aron



--
This message was sent by Atlassian Jira
(v8.3.4#803005)