v.20.4Improvement

Add Support for Leading Zeros in Number Ranges for Filepaths

Add ability to use number ranges with leading zeros in filepath #9989 (Olga Khvostikova)
Add support for number ranges with leading zeros in file paths used in ClickHouse table functions and external data source specifications.

Why it matters

Previously, ClickHouse did not correctly handle number ranges with leading zeros in file paths, limiting flexibility in specifying files when using patterns. This feature allows users to include number ranges with leading zeros, enabling more precise and convenient file selection based on consistent numeric patterns in filenames.

How to use it

Users can specify file paths with number ranges that include leading zeros in ClickHouse file-reading functions or external table specifications. For example, file patterns like data_{001..100}.csv will now be properly expanded and processed by ClickHouse.