v.19.3New Features
Added Support of Nullable Types in Mysql Table Function
Added support ofNullabletypes inmysqltable function. #4198 (Emmanuel Donin de Rosière)
Why it matters
This feature enables users to correctly handle and query MySQL tables that containNullable columns using the mysql table function in ClickHouse. It solves the problem of data type incompatibility and improves data integration by preserving nullability when accessing MySQL data.How to use it
Use themysql table function as usual to query MySQL tables with nullable columns. The function now automatically supports and returns columns with Nullable types without additional configuration. Example usage:SELECT * FROM mysql('host:port', 'database', 'table', 'user', 'password')