CREATE DICTIONARY `dict` (`c0` UInt128) PRIMARY KEY (`c0`) SOURCE(NULL()) LAYOUT(FLAT()) LIFETIME(0);

SELECT *, dictGetUInt16('dict', 'c0', `t1`.`c0`) = TRUE FROM `dict` AS t1;

CREATE TABLE t__fuzz_0 (`color_id` UInt64, `payload` String)
ENGINE = MergeTree ORDER BY color_id;

CREATE DICTIONARY colors
(
  color_id   UInt64,
  payload String
)
PRIMARY KEY color_id
SOURCE(CLICKHOUSE(TABLE 't__fuzz_0'))
LAYOUT(HASHED())
LIFETIME(0);

SELECT equals(materialize(9), CAST('red' AS Nullable(String)) = dictGetString('colors', 'payload', color_id))
FROM t__fuzz_0;

CREATE TABLE tab__fuzz_24
(`id` LowCardinality(UInt16), `payload` LowCardinality(Nullable(Int8)))
ENGINE = MergeTree ORDER BY id;

INSERT INTO tab__fuzz_24 FORMAT Values (1,'x'), (2,'y'), (99,'z');

CREATE TABLE ref_table_all
(`id` UInt64, `name` String, `i8` String, `i16` String, `i32` String, `i64` String, `u8` String, `u16` String, `u32` String, `u64` String, `f32` String, `f64` String, `d` String, `dt` String, `uid` String, `ip4` String, `ip6` String)
ENGINE = MergeTree ORDER BY id;

CREATE DICTIONARY dictionary_all
(`id` UInt64, `name` String, `i8` String, `i16` String, `i32` String, `i64` String, `u8` String, `u16` String, `u32` String, `u64` String, `f32` String, `f64` String, `d` String, `dt` String, `uid` String, `ip4` String, `ip6` String)
PRIMARY KEY id
SOURCE(CLICKHOUSE(TABLE 'ref_table_all'))
LIFETIME(MIN 0 MAX 0)
LAYOUT(HASHED());

SELECT DISTINCT 13, *, or(-32 = dictGetInt32(toFixedString('dictionary_all', toLowCardinality(14)), toFixedString('i32', 3), id), isNotDistinctFrom(1, 9223372036854775806), toLowCardinality(19), not(equals(payload, 9223372036854775806))), isNotNull('dictGetFloat64 - plan'), id, isNotNull(1)
FROM tab__fuzz_24 PREWHERE equals(9223372036854775806, payload)
WHERE isNotDistinctFrom(id, isNotDistinctFrom(9223372036854775806, equals(1, isNotNull(9223372036854775806)))) QUALIFY and(NULL, equals(1, isZeroOrNull(1)))
ORDER BY payload DESC;