v.20.3Improvement

Don't Allow Odd Expressions in ALTER TABLE ... PARTITION Query

Don't allow strange expressions in ALTER TABLE ... PARTITION partition query. This addresses #7192 #8835 (alexey-milovidov)
Prevent the use of unsupported or strange expressions in the ALTER TABLE ... PARTITION partition queries to ensure correct syntax and behavior.

Why it matters

This feature fixes an issue where invalid or unexpected expressions could be used in ALTER TABLE ... PARTITION commands, which could lead to incorrect query execution or errors. By restricting the partition specification to valid expressions, it improves query reliability and user experience.

How to use it

Users simply write their ALTER TABLE ... PARTITION queries with valid partition specifiers. The system now enforces correct syntax automatically and rejects invalid expressions without additional configuration.