deardeng opened a new issue, #47851: URL: https://github.com/apache/doris/issues/47851
### Search before asking - [x] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Version doris master ### What's Wrong? Fix many properties in the table building attribute that do not have a trim, which may result in errors in the subsequent process such as ``` mysql> CREATE TABLE tbl1 -> ( -> k1 DATE, -> k2 varchar(20) -> ) DISTRIBUTED BY HASH(k1) -> PARTITION BY RANGE(k1) () -> DISTRIBUTED BY HASH(k1) -> PROPERTIES -> ( -> "replication_num"="1", -> "dynamic_partition.enable" = "true", -> "dynamic_partition.time_unit" = "DAY", -> "dynamic_partition.start" = "-7", -> "dynamic_partition.end" = "3", -> "dynamic_partition.prefix" = "p", -> "dynamic_partition.buckets" = "32" -> ); Query OK, 0 rows affected (0.09 sec)mysql> alter table tbl1 set ( "dynamic_partition.start " = "-2147483648"); Query OK, 0 rows affected (0.00 sec)mysql> show create table tbl1; +-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | tbl1 | CREATE TABLE `tbl1` ( `k1` date NULL, `k2` varchar(20) NULL ) ENGINE=OLAP DUPLICATE KEY(`k1`, `k2`) PARTITION BY RANGE(`k1`) (PARTITION p20241206 VALUES [('2024-12-06'), ('2024-12-07')), PARTITION p20241207 VALUES [('2024-12-07'), ('2024-12-08')), PARTITION p20241208 VALUES [('2024-12-08'), ('2024-12-09')), PARTITION p20241209 VALUES [('2024-12-09'), ('2024-12-10'))) DISTRIBUTED BY HASH(`k1`) BUCKETS 10 PROPERTIES ( "replication_allocation" = "tag.location.default: 1", "min_load_replica_num" = "-1", "is_being_synced" = "false", "dynamic_partition.enable" = "true", "dynamic_partition.time_unit" = "DAY", "dynamic_partition.time_zone" = "Asia/Shanghai", "dynamic_partition.start" = "-7", "dynamic_partition.end" = "3", "dynamic_partition.prefix" = "p", "dynamic_partition.replication_allocation" = "tag.location.default: 1", "dynamic_partition.buckets" = "32", "dynamic_partition.create_history_partition" = "false", "dynamic_partition.history_partition_num" = "-1", "dynamic_partition.hot_partition_num" = "0", "dynamic_partition.reserved_history_periods" = "NULL", "dynamic_partition.storage_policy" = "", "storage_medium" = "hdd", "storage_format" = "V2", "inverted_index_storage_format" = "V1", "light_schema_change" = "true", "disable_auto_compaction" = "false", "enable_single_replica_compaction" = "false", "group_commit_interval_ms" = "10000", "group_commit_data_bytes" = "134217728" ); | +-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec)mysql> ``` alter table tbl1 set ( "dynamic_partition.start " = "-2147483648"); return ok but not work in show create table There is an extra space after 'dynamic_partition. start' here <img width="1342" alt="Image" src="https://github.com/user-attachments/assets/a99a92b3-b901-48ca-8857-8a3965f8a3ad"; /> ### What You Expected? 1. trime table properties when create table or alter table 2. and add some regression case ### How to Reproduce? _No response_ ### Anything Else? _No response_ ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [x] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
