Currently we are working in Drill to allow support for Nan an Inf <https://issues.apache.org/jira/browse/DRILL-5919> values . When using such values with functions we see the NumberFormatException exception. Query example: *select sin(cast('NaN' as float)) from (values(1)) *
It turns out that Calcite uses BigDecimal for handling DOUBLE, FLOAT values. Is it acceptable for Calcite to support nan, infinity values handling? For example, adding new types NON_NUMERIC_DOUBLE, NON_NUMERIC_FLOAT?
