v.1.1.54362New Feature

Implemented Empty Function for FixedString Null Byte Check

Official CH changelog text
Implemented the empty function from a FixedString argument: the function returns 1 if the string consists entirely of null bytes (zhang2014).
Implemented the empty function for FixedString arguments in ClickHouse, which returns 1 if the string consists entirely of null bytes.

Why it matters

This feature allows users to check whether a FixedString is effectively empty by verifying if it contains only null bytes. It helps in identifying uninitialized or placeholder fixed-length strings, improving data validation and processing.

How to use it

Use the empty function by passing a FixedString column or value as an argument. For example:

SELECT empty(fixed_string_column) FROM table

This query will return 1 for each row where the FixedString consists entirely of null bytes.
PreviousNext