terrymanu commented on issue #27170: URL: https://github.com/apache/shardingsphere/issues/27170#issuecomment-5330797450
Hi @FlyingZC, thanks for raising this. All statements listed here are already supported on the current master, so I'm closing this issue as completed. The only part that was actually missing when this issue was filed — the flashback subquery with `AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '2' MINUTE)` — was fixed by #27465 (merged into 5.4.1), covered by the sql-case `update_with_subquery_using_interval`. The cell-assignment rule prefixes `UPDATE`, `UPSERT` and `UPSERT ALL` are part of the MODEL clause `RULES` syntax and have been supported by `modelRulesClause` in the Oracle grammar since #11503. Existing sql-cases such as `select_oracle_model_cv` (`RULES UPDATE (...)`) and `select_with_model_partition_dimension` / `select_with_model_with_multi_column_for_loop` (`RULES UPSERT (...)`) already cover multi-dimension cell references with `ANY` and `CV()`. Feel free to reopen if any of the listed statements still fails to parse on a version that includes #27465 (5.4.1 or later). -- 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. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
