v.22.2Experimental Feature

Support SET, YEAR, TIME, and GEOMETRY Data Types in MaterializedMySQL

Support SET, YEAR, TIME and GEOMETRY data types in MaterializedMySQL (experimental feature). Fixes #18091, #21536, #26361. #33429 (zzsmdfj).
Support for SET, YEAR, TIME, and GEOMETRY data types in MaterializedMySQL (experimental).

Why it matters

This feature extends the MaterializedMySQL engine to support additional MySQL data types: SET, YEAR, TIME, and GEOMETRY. It resolves issues related to the lack of support for these types, improving data compatibility and usability when replicating or synchronizing MySQL tables with ClickHouse.

How to use it

Enable the experimental support by using the MaterializedMySQL table engine as usual. The new data types will now be recognized and handled correctly without additional configuration. Since it is experimental, testing in a controlled environment before production use is recommended.