v.23.1Improvement

Prevent Zero Value Specification for index_granularity

Prevent users from mistakenly specifying zero (invalid) value for index_granularity. This closes #44536. #44578 (Alexey Milovidov).
Prevent users from specifying zero as the value for index_granularity, which is invalid.

Why it matters

This feature addresses the issue where users could mistakenly set index_granularity to zero, an invalid value that could cause unexpected behavior or errors. By enforcing a restriction against zero values, it ensures data integrity and reduces configuration errors.

How to use it

Users simply need to specify a positive, non-zero value for index_granularity in their table definitions or settings. Attempts to set index_granularity = 0 will be blocked to prevent invalid configurations.