[CALCITE-4462] `ROUND` SQL function throws exception on Infinite or NaN arguments

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.25.0, 1.26.0
• Component/s: core
• Assignee: Unassigned
• Reporter: Yuriy Sazonets
• Created: 11/Jan/21 13:23
• Updated: 09/Nov/21 01:56

Description

Should return original value instead of throwing an exception.

Stack trace

java.lang.NumberFormatException: Character I is neither a decimal digit number, decimal point, nor "e" notation exponential

mark.java.lang.NumberFormatException: Character I is neither a decimal digit number, decimal point, nor "e" notation exponential mark.

at java.base/java.math.BigDecimal.<init>(BigDecimal.java:519)
at java.base/java.math.BigDecimal.<init>(BigDecimal.java:402)
at java.base/java.math.BigDecimal.<init>(BigDecimal.java:835)
at java.base/java.math.BigDecimal.valueOf(BigDecimal.java:1305)
at org.apache.calcite.runtime.SqlFunctions.sround(SqlFunctions.java:1535)
at Baz$8$1.current(Unknown Source) at org.apache.calcite.linq4j.Linq4j$EnumeratorIterator.next(Linq4j.java:684)
at org.apache.calcite.avatica.util.IteratorCursor.next(IteratorCursor.java:46)
at org.apache.calcite.avatica.AvaticaResultSet.next(AvaticaResultSet.java:217)

Issue Links

• is related to: CALCITE-4589 'Infinity' float values fails with java.lang.ClassCastException