[jira] [Created] (FLINK-28403) SqlParserPos value for SqlCall is ambiguous

["suheng.cloud (Jira)" <ji...@apache.org>]

suheng.cloud created FLINK-28403:
------------------------------------

             Summary: SqlParserPos value for SqlCall is ambiguous
                 Key: FLINK-28403
                 URL: https://issues.apache.org/jira/browse/FLINK-28403
             Project: Flink
          Issue Type: Bug
          Components: Table SQL / API
    Affects Versions: 1.15.0
            Reporter: suheng.cloud


Dear Community:

For a long time I was puzzled by how SqlParserPos actually means in SqlCall, because I found the definitions for different statements in parserImpls.ftl are not unified.

For example,  in SqlCreateTable, we use `startPos.plus(getPos())` which means if I want to find out the end position of the last token, calling `SqlCreateTable::getParserPosition::getEndxx` is ok, but in some other statement like SqlRichDescribeTable, we just use the intermediate `pos` as the final position, so I must call `SqlRichDescribeTable.getParserPosition().plusAll(SqlRichDescribeTable::getOperandList())` to merge the result pos. Even worse in SqlStatementSet, which wrapped in SqlExecuate,  both above methods not work because no child operand covered `END` syntax.

My question is
 # Does the SqlParserPosition mean entire span for a sqlCall or not ?
 # What is the easyest and right way to get the "final position" of a SqlCall/SqlNode in fink sql?

Correct me if I miss some point, thanks for any help.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)