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).
Why it matters
This feature solves the issue whereDecimal 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 includeDecimal 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);