> ## Documentation Index
> Fetch the complete documentation index at: https://clickhouse.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# allow_suspicious_* session settings

> ClickHouse session settings in the allow_suspicious_* generated group.

These settings are available in [system.settings](https://clickhouse.com/docs/reference/system-tables/settings.md) and are autogenerated from [source](https://github.com/ClickHouse/ClickHouse/blob/master/src/Core/Settings.cpp).

## allow\_suspicious\_codecs

Type

Bool

Default

0

If it is set to true, allow to specify meaningless compression codecs.

## allow\_suspicious\_fixed\_string\_types

Type

Bool

Default

0

In CREATE TABLE statement allows creating columns of type FixedString(n) with n > 256. FixedString with length >= 256 is suspicious and most likely indicates a misuse

## allow\_suspicious\_indexes

**Aliases**: `allow_suspicious_indices`

Type

Bool

Default

0

Reject primary/secondary indexes and sorting keys with identical expressions

## allow\_suspicious\_low\_cardinality\_types

Type

Bool

Default

0

Allows or restricts using [LowCardinality](https://clickhouse.com/docs/reference/data-types/lowcardinality.md) with data types with fixed size of 8 bytes or less: numeric data types and `FixedString(8_bytes_or_less)`.

For small fixed values using of `LowCardinality` is usually inefficient, because ClickHouse stores a numeric index for each row. As a result:

* Disk space usage can rise.
* RAM consumption can be higher, depending on a dictionary size.
* Some functions can work slower due to extra coding/encoding operations.

Merge times in [MergeTree](https://clickhouse.com/docs/reference/engines/table-engines/mergetree-family/mergetree.md)-engine tables can grow due to all the reasons described above.

Possible values:

* 1 — Usage of `LowCardinality` is not restricted.
* 0 — Usage of `LowCardinality` is restricted.

## allow\_suspicious\_primary\_key

Type

Bool

Default

0

Allow suspicious `PRIMARY KEY`/`ORDER BY` for MergeTree (i.e. SimpleAggregateFunction).

## allow\_suspicious\_ttl\_expressions

Type

Bool

Default

0

Reject TTL expressions that don't depend on any of table's columns. It indicates a user error most of the time.

## allow\_suspicious\_types\_in\_group\_by

Type

Bool

Default

0

Allows or restricts using [Variant](https://clickhouse.com/docs/reference/data-types/variant.md) and [Dynamic](https://clickhouse.com/docs/reference/data-types/dynamic.md) types in GROUP BY keys.

## allow\_suspicious\_types\_in\_order\_by

Type

Bool

Default

0

Allows or restricts using [Variant](https://clickhouse.com/docs/reference/data-types/variant.md) and [Dynamic](https://clickhouse.com/docs/reference/data-types/dynamic.md) types in ORDER BY keys.

## allow\_suspicious\_variant\_types

Type

Bool

Default

0

In CREATE TABLE statement allows specifying Variant type with similar variant types (for example, with different numeric or date types). Enabling this setting may introduce some ambiguity when working with values with similar types.
