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)
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 likedata_{001..100}.csv will now be properly expanded and processed by ClickHouse.