Skip to main content
These settings are available in system.settings and are autogenerated from source.

validate_enum_literals_in_operators

If enabled, validate enum literals in operators like IN, 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 that GROUP 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 ALL expands into are not validated.
  • 1 - They are validated, as an explicit GROUP BY validates its own keys.

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. pointInPolygon accepts invalid polygons and returns possibly incorrect results for them.
  • 1 — Throwing an exception is enabled.
Last modified on September 25, 2026