v.23.9Improvement

Added is_deterministic Field to system.functions Table

Official CH changelog text
Added field is_deterministic to system table system.functions which indicates whether the result of a function is stable between two invocations (given exactly the same inputs) or not. #54766 #55035 (Robert Schulze).
Added the is_deterministic field to the system.functions table to indicate whether a function produces stable results for identical inputs.

Why it matters

This feature helps users and developers identify which functions in ClickHouse are deterministic, meaning they return consistent results given the same inputs. It aids in query optimization, correctness verification, and understanding function behavior.

How to use it

Query the system.functions table and check the is_deterministic column to determine if a function is deterministic. For example:

sql<br>SELECT name, is_deterministic FROM system.functions WHERE name = 'function_name'<br>

Related resources

PreviousNext