Join Logical error: 'Bad cast from type DB::ColumnLowCardinality to DB::ColumnString

[vdimir]

Describe the bug
Logical error: 'Bad cast from type DB::ColumnLowCardinality to DB::ColumnString'. in JOIN

https://clickhouse-test-reports.s3.yandex.net/23237/67e427c13aa2b9857c697726251d1e27af4fa1d9/fuzzer_debug/report.html#fail1

DROP TABLE IF EXISTS l_lc;
DROP TABLE IF EXISTS r;

CREATE TABLE l_lc (`x` UInt32, `lc` LowCardinality(String)) ENGINE = Memory;
CREATE TABLE r (x UInt32, lc String) ENGINE = Memory;

INSERT INTO r VALUES (0, 'str');
INSERT INTO l_lc VALUES (0, 'str');

SELECT r.lc, toTypeName(l.lc), materialize(r.lc), toTypeName(materialize(r.lc)) FROM l_lc AS l RIGHT JOIN r USING (lc);

[vdimir]

Started to reproduce since 9d62842

[vdimir]

Connected, but cause segfault

CREATE TABLE lc (`x` UInt32, `key` LowCardinality(String)) ENGINE = TinyLog;
CREATE TABLE rr (`x` UInt32, `key` String) ENGINE = TinyLog;

SELECT lowCardinalityKeys(lc.key) FROM rr FULL JOIN lc as lc USING (key);