v.21.4New Features

Supports Implicit Key Type Conversion for JOIN

Supports implicit key type conversion for JOIN. #19885 (Vladimir).
Support for implicit key type conversion in JOIN operations.

Why it matters

This feature addresses the issue where JOIN keys have differing data types, which previously required explicit type casting by the user. By enabling implicit key type conversion, it simplifies query writing and improves query compatibility and flexibility, saving users from manual type conversions.

How to use it

Users can benefit from this feature automatically when performing JOIN operations between tables with keys of different but compatible types. No extra configuration is needed; the system will implicitly convert key types to allow the join.