validate_enum_literals_in_operators
If enabled, validate enum literals in operators likeIN, NOT IN, ==, != against the enum type and throw an exception if the literal is not a valid enum value.
validate_group_by_all_key_types
Controls whether the grouping keys thatGROUP BY ALL expands the SELECT expressions into are checked against allow_suspicious_types_in_group_by. Disable it to restore the behavior of versions before 26.7, which accepted a Variant or Dynamic key written as GROUP BY ALL, for example a grouping key that is an untyped JSON subpath. Takes effect only when the analyzer is enabled (enable_analyzer = 1, the default); with the old analyzer such a key was rejected before 26.7 as well, so there is nothing to restore there. An explicit GROUP BY is unaffected and keeps rejecting such a key either way, so this is narrower than setting allow_suspicious_types_in_group_by, which also permits them in an explicit GROUP BY.
Possible values:
- 0 - The key types
GROUP BY ALLexpands into are not validated. - 1 - They are validated, as an explicit
GROUP BYvalidates its own keys.
validate_mutation_query
Validate mutation queries before accepting them. Mutations are executed in the background, and running an invalid query can cause mutations to get stuck, requiring manual intervention. Only change this setting if you encounter a backward-incompatible bug.validate_polygons
Enables or disables throwing an exception in the pointInPolygon function, if the polygon is self-intersecting or self-tangent. Possible values:- 0 — Throwing an exception is disabled.
pointInPolygonaccepts invalid polygons and returns possibly incorrect results for them. - 1 — Throwing an exception is enabled.