snuyanzin commented on PR #25938: URL: https://github.com/apache/flink/pull/25938#issuecomment-2585208995
In general agree it is supported for most of the cases however there are some corner cases where it is not supported for instance in both FLOAT and DOUBLE there are `NaN`, `Infinity`, `-Infinity`. Not sure whether it is possible to make a query with `NaN` however it is possible to have something returning either `-Infinity` or `Infinity` for instance ```sql SELECT power(0, -1); ``` or ```sql SELECT -power(0, -1); ``` as a result casting of these doubles will NOT work since there are now infinities in DECIMAL so it will just fail ```sql SELECT CAST(power(0, -1) AS DECIMAL); ``` as an option we could mark it as supported \+ add some reference note about corner cases WDYT? -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: issues-unsubscr...@flink.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
