CREATE TABLE tst_in (key UInt32) ENGINE=MergeTree ORDER BY key AS SELECT number FROM numbers(1000000);

SELECT count()
FROM tst_in
WHERE key IN (
    SELECT number
    FROM numbers(1000)
);


Received exception from server (version 23.6.1):
Code: 53. DB::Exception: Received from localhost:9000. DB::Exception: Types of column 1 in section IN don't match: UInt32 on the left, UInt64 on the right. (TYPE_MISMATCH)
(query: SELECT count()
FROM tst_in
WHERE key IN (
    SELECT number
    FROM numbers(1000)
);)


If we disable index analysis it does work

SELECT count()
FROM tst_in
WHERE identity(key IN (
    SELECT number
    FROM numbers(1000)
));

1000