terrymanu commented on issue #27137: URL: https://github.com/apache/shardingsphere/issues/27137#issuecomment-5329238539
Hi @FlyingZC, thanks for reporting this. This enhancement has already been completed on the current master branch, so we can close this issue as done. - `DROP TABLESPACE ... [INCLUDING CONTENTS [AND | KEEP] DATAFILES] [CASCADE CONSTRAINTS]` was implemented in #27221, covering the Oracle grammar rule, the visitor, and parser test cases (`drop_tablespace_constraints`, `drop_tablespace_datafiles`). - The companion statements are also supported now: `ALTER SYSTEM SWITCH LOGFILE` (test case `alter_system_switch_logfile`), `DROP TYPE ... FORCE` (test case `drop_type_schema_force`), and `CREATE [OR REPLACE] TYPE ... AS OBJECT ... NOT FINAL` (test case `create_type_as_object`). - One note: the first SQL in the description, `DROP TABLESPACE INCLUDING CONTENTS AND DATAFILES tbs_4;`, is not valid Oracle syntax; the documented form is `DROP TABLESPACE tbs_4 INCLUDING CONTENTS AND DATAFILES;`, which is already supported and covered by test cases. Since all the listed statements parse successfully on the latest version, I'm closing this issue as completed. Feel free to reopen it if anything is still missing. -- 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]
