terrymanu commented on issue #31461: URL: https://github.com/apache/shardingsphere/issues/31461#issuecomment-5330787337
Hi @iamhucong, thanks for putting this list together. All the SQL cases listed in this issue are now supported on the current master, so I am closing it as completed. - `CREATE TABLE ... ENGINE=OLAP ... DUPLICATE KEY(...) DISTRIBUTED BY HASH(...) BUCKETS ... PROPERTIES` — supported by #31270 and extended by #39201. - `ALTER TABLE ... ORDER BY (...)` (with optional `FROM rollup` / `PROPERTIES`) and `ALTER TABLE ... ADD COLUMN ... AFTER ...` — supported by #38400. - `STRRIGHT` — supported by #33393. - `CREATE/ALTER/DROP/SHOW SQL_BLOCK_RULE` — supported by #37817. - `DROP FILE "file_name" [FROM database] PROPERTIES` — supported by #38050. - `PERCENT_RANK() OVER ...` window function — covered by the Doris dialect window function rules. Each of them has parser test cases under `test/it/parser/src/main/resources/sql/supported/`, for example `alter_table_order_by_doris`, `create_table_with_properties`, `drop_file_quoted`, `drop_sql_block_rule_single` and `select_strright`. These fixes are on master (5.5.4-SNAPSHOT). If anyone finds a Doris statement that still fails to parse, please open a new issue with the SQL and the version. Thanks again! -- 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]
