Set up docs MCPThese settings are available in system.settings and are autogenerated from source.
optimize_injective_functions_in_group_by
Type
Bool
Default
1
Version history
| Version | Default value | Comment |
|---|---|---|
| 24.1 | 1 | Replace injective functions by it's arguments in GROUP BY section in analyzer |
Replaces injective functions by it’s arguments in GROUP BY sectio
optimize_injective_functions_in_limit_by
Type
Bool
Default
1
Version history
| Version | Default value | Comment |
|---|---|---|
| 26.6 | 1 | New setting that replaces injective functions by their arguments in the LIMIT BY keys. |
Replaces injective functions by their arguments in LIMIT BY section.
Example: LIMIT 5 BY toString(x) becomes LIMIT 5 BY x.
optimize_injective_functions_inside_uniq
Type
Bool
Default
1
Delete injective functions of one argument inside uniq*() functions.