SET allow_experimental_statistics = 1;
SET allow_statistics_optimize = 1;
SET mutations_sync = 1;

CREATE TABLE tab (a Float64 STATISTICS(tdigest)) Engine = MergeTree() ORDER BY tuple();
INSERT INTO tab SELECT number FROM system.numbers LIMIT 10000;
SELECT count(*) FROM tab WHERE a < '10';
DROP TABLE tab;

CREATE TABLE tab (a Int32 STATISTICS(tdigest)) Engine = MergeTree() ORDER BY tuple();
INSERT INTO tab SELECT number FROM system.numbers LIMIT 10000;
SELECT count(*) FROM tab WHERE a < '10.5'; -- { serverError TYPE_MISMATCH }
DROP TABLE tab;

CREATE TABLE tab (a Int32 STATISTICS(tdigest)) Engine = MergeTree() ORDER BY tuple();
INSERT INTO tab SELECT number FROM system.numbers LIMIT 10000;
SELECT count(*) FROM tab WHERE a < 10.5;
DROP TABLE tab;

CREATE TABLE tab (a Int16 STATISTICS(tdigest)) Engine = MergeTree() ORDER BY tuple();
INSERT INTO tab SELECT number FROM system.numbers LIMIT 10000;
SELECT count(*) FROM tab WHERE a < '9999999999999999999999999';
DROP TABLE tab;
