[
https://issues.apache.org/jira/browse/CALCITE-1973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16151866#comment-16151866
]
Julian Hyde commented on CALCITE-1973:
--------------------------------------
Looks like a bug. But what exactly do you mean by "from"? There isn't a SqlNode
for the FROM keyword as such, just the table expression.
I would approach this by adding a test to SqlParserTest.
> 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: Julian Hyde
>
> 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
(v6.4.14#64029)