v.24.8New Feature

Add fuzzQuery Function for Random Query Variations

Official CH changelog text
Add a new table function fuzzQuery. This function allows the modification of a given query string with random variations. Example: SELECT query FROM fuzzQuery('SELECT 1') LIMIT 5;. #67655 (pufit).
Introduces a new table function fuzzQuery that generates random variations of a given SQL query string.

Why it matters

The fuzzQuery function enables users to create multiple randomized versions of a query, which is useful for testing, debugging, and analyzing query behavior under slight modifications. This helps in identifying query stability and robustness.

How to use it

Use the fuzzQuery function by passing a SQL query string as an argument. For example: SELECT query FROM fuzzQuery('SELECT 1') LIMIT 5; returns five randomly varied versions of the input query.

Related resources

PreviousNext