You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "ASF GitHub Bot (Jira)" <ji...@apache.org> on 2026/08/26 06:09:00 UTC
[jira] [Updated] (FLINK-40207) Make NaN and Infinity case-insensitive
[ https://issues.apache.org/jira/browse/FLINK-40207?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
ASF GitHub Bot updated FLINK-40207:
-----------------------------------
Labels: pull-request-available (was: )
> Make NaN and Infinity case-insensitive
> --------------------------------------
>
> Key: FLINK-40207
> URL: https://issues.apache.org/jira/browse/FLINK-40207
> Project: Flink
> Issue Type: Bug
> Components: Table SQL / Planner
> Reporter: Ramin Gharib
> Assignee: Ramin Gharib
> Priority: Minor
> Labels: pull-request-available
>
> Currently Flink only accepts case-sensitive \{{NaN. }}If we use nan, Nan, or NAN Flink will fail to parse it. For to reproduce simply write
>
> {code:java}
> SELECT CAST('nan' as FLOAT){code}
> You will get
> {code:java}
> Caused by: java.lang.NumberFormatException: For input string: "nan" at java.base/jdk.internal.math.FloatingDecimal.readJavaFormatString(FloatingDecimal.java:2054) at java.base/jdk.internal.math.FloatingDecimal.parseFloat(FloatingDecimal.java:122) at java.base/java.lang.Float.parseFloat(Float.java:476) at org.apache.flink.table.data.binary.BinaryStringDataUtil.toFloat(BinaryStringDataUtil.java:581) at BatchExecCalc$3.processElement(Unknown Source) at org.apache.flink.streaming.runtime.tasks.ChainingOutput.pushToOperator(ChainingOutput.java:110) at org.apache.flink.streaming.runtime.tasks.ChainingOutput.collect(ChainingOutput.java:79) at org.apache.flink.streaming.runtime.tasks.ChainingOutput.collect(ChainingOutput.java:41) {code}
> This is also applied for Infinity
> {code:java}
> Caused by: java.lang.NumberFormatException: For input string: "-infinity" {code}
> Moreover, we can also allow
> * {{-inf}}
> * {{inf}}
> as aliases for -Infinity and Infinity.
> Other vendors like Snowflake and Databricks also define them as case-insensitive:
> [https://docs.snowflake.com/en/sql-reference/data-types-numeric#special-values]
> [https://docs.databricks.com/aws/en/sql/language-manual/data-types/special-floating-point-values]
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)