Skip to content
ClickHouse Docs
ClickHouse DocsClickHouse Docs

validate_* session settings

These settings are available in system.settings and are autogenerated from source.

validate_enum_literals_in_operators

Type
Bool
Default
0
Version history
VersionDefault valueComment
25.10A new setting

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_mutation_query

Type
Bool
Default
1
Version history
VersionDefault valueComment
24.111New setting to validate mutation queries by default.

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

Type
Bool
Default
1
Version history
VersionDefault valueComment
20.41Throw exception if polygon is invalid in function pointInPolygon by default instead of returning possibly wrong results

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.
Navigation