v.22.10Improvement

Add Decimal Type Support in IN Operator for Floating Point Comparisons

Add support for decimal type comparing with floating point literal in IN operator. #41544 (liang.huang).
Add support for comparing Decimal type columns with floating point literals inside the IN operator.

Why it matters

This feature solves the issue where Decimal columns could not be directly compared to floating point literals within an IN clause, enabling more flexible and intuitive queries involving mixed numeric types.

How to use it

Users can now write queries that include Decimal columns compared directly with floating point literals inside an IN operator without extra casting, for example:

SELECT * FROM table WHERE decimal_column IN (1.1, 2.2, 3.3);