wgy8283335 commented on pull request #10168:
URL: https://github.com/apache/shardingsphere/pull/10168#issuecomment-826447551
I've test the TransferTool, the result of the rule sentence like below:
```
-----------------------------------
Before:
UPDATE [ hint ] { dml_table_expression_clause | ONLY
(dml_table_expression_clause) } [ t_alias ] update_set_clause [ where_clause ]
[ returning_clause ] [error_logging_clause] ;
After:
UPDATE (hint)? (dmlTableExpressionClause | ONLY
LP_(dmlTableExpressionClause)RP_ ) (tAlias)? updateSetClause (whereClause)?
(returningClause)? (errorLoggingClause)? ;
-----------------------------------
Before:
ALTER TABLE [ schema. ] table
[ memoptimize_read_clause ]
[ memoptimize_write_clause ]
[ alter_table_properties
| column_clauses
| constraint_clauses
| alter_table_partitioning
| alter_external_table
| move_table_clause
| modify_to_partitioned
| modify_opaque_type
| immutable_table_clauses
| blockchain_table_clauses
]
[ enable_disable_clause
| { ENABLE | DISABLE }
{ TABLE LOCK | ALL TRIGGERS | CONTAINER_MAP | CONTAINERS_DEFAULT }
] ...
;
After:
ALTER TABLE (schema.)? table (memoptimizeReadClause)?
(memoptimizeWriteClause)? (alterTableProperties | columnClauses |
constraintClauses | alterTablePartitioning | alterExternalTable |
moveTableClause | modifyToPartitioned | modifyOpaqueType |
immutableTableClauses | blockchainTableClauses)? (enableDisableClause |
(ENABLE | DISABLE) (TABLE LOCK | ALL TRIGGERS | CONTAINER_MAP |
CONTAINERS_DEFAULT) )* ;
------------------------------------
Before:
SET
{ { (column [, column ]...) = (subquery)
| column = { expr | (subquery) | DEFAULT }
}
[, { (column [, column]...) = (subquery)
| column = { expr | (subquery) | DEFAULT }
}
]...
| VALUE (t_alias) = { expr | (subquery) }
}};
After:
SET ( ( LP_(column (,column)* )RP_ EQ_ LP_(subquery)RP_ | column EQ_
(expr | LP_(subquery)RP_ | DEFAULT) ) (, ( LP_(column (,column)* )RP_ EQ_
LP_(subquery)RP_ | column EQ_ (expr | LP_(subquery)RP_ | DEFAULT) ) )* |
VALUE LP_(tAlias)RP_ EQ_ (expr | LP_(subquery)RP_ ) )
-------------------------------
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
