Support MySQL/Oracle update statement convert to SqlUpdate to improve sql federation support

[strongduanmu]

Background

On the master branch, SQLNodeConverterEngine already supports the conversion of most SelectStatement statements, which provides a good foundation for sql federation. In order to improve the support of sql federation for update statements and complex statements such as update join, we need to support the conversion of UpdateStatement in SQLNodeConverterEngine.

MySQL update statement doc - https://dev.mysql.com/doc/refman/8.0/en/update.html

UPDATE [LOW_PRIORITY] [IGNORE] table_reference
    SET assignment_list
    [WHERE where_condition]
    [ORDER BY ...]
    [LIMIT row_count]

value:
    {expr | DEFAULT}

assignment:
    col_name = value

assignment_list:
    assignment [, assignment] ...

UPDATE [LOW_PRIORITY] [IGNORE] table_references
    SET assignment_list
    [WHERE where_condition]

Oracle update statement doc - https://docs.oracle.com/en/database/oracle/oracle-database/21/sqlrf/UPDATE.html#GUID-027A462D-379D-4E35-8611-410F3AC8FDA5

Task

• [ ] add UpdateStatementConverter implement, you can refer - https://github.com/polardb/polardbx-sql/blob/cdd976850bdfc3264dff279198b6b06eb8641fbe/polardbx-optimizer/src/main/java/com/alibaba/polardbx/optimizer/parse/visitor/FastSqlToCalciteNodeVisitor.java#L1110
• [ ] add UpdateStatementConverter call logic in SQLNodeConverterEngine
• [ ] add update statement convert test case in resources/converter directory

[zihaoAK47]

Hi mentor, in order for SQL Federation to support update statements and support explain update, I would like to solve this problem. Please assign it to me. Thank you

[github-actions[bot]]

There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.

[github-actions[bot]]

There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.