[
https://issues.apache.org/jira/browse/IGNITE-20721?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Maksim Zhuravkov updated IGNITE-20721:
--------------------------------------
Description:
Example:
{code:java}
sql("SELECT ROUND(1.12, 1::DECIMAL(1))");
# SqlValidatorException: Cannot apply 'ROUND' to arguments of type
'ROUND(<DECIMAL(3, 2)>, <DECIMAL(1, 0)>)'. Supported form(s): 'ROUND(<NUMERIC>,
<INTEGER>)'
SELECT ROUND(1.123, 1::BIGINT)
{code}
But this example produces a runtime error:
{code:java}
sql("SELECT ROUND(1.12, 1::BIGINT)");
# NoSuchMethodException:
org.apache.ignite.internal.sql.engine.exec.exp.IgniteSqlFunctions.sround(java.math.BigDecimal,
long)
{code}
SUBSTRING function is also affected by this error:
{code:java}
sql("SELECT SUBSTRING('1234', 1::BIGINT)")
# NoSuchMethodException:
org.apache.calcite.runtime.SqlFunctions.substring(java.lang.String, long)
sql("SELECT SUBSTRING('1234', 1::DECIMAL(1))")
# NoSuchMethodException:
org.apache.calcite.runtime.SqlFunctions.substring(java.lang.String,
java.math.BigDecimal)
{code}
Probably other functions, that accept values that belong to the domain of INT
type, are affected as well.
was:
Example:
{code:java}
sql("SELECT ROUND(1.12, 1::DECIMAL(1))");
# SqlValidatorException: Cannot apply 'ROUND' to arguments of type
'ROUND(<DECIMAL(3, 2)>, <DECIMAL(1, 0)>)'. Supported form(s): 'ROUND(<NUMERIC>,
<INTEGER>)'
SELECT ROUND(1.123, 1::BIGINT)
{code}
But this example produces a runtime error:
{code:java}
sql("SELECT ROUND(1.12, 1::BIGINT)");
# NoSuchMethodException:
org.apache.ignite.internal.sql.engine.exec.exp.IgniteSqlFunctions.sround(java.math.BigDecimal,
long)
{code}
SUBSTRING function is also affected by this error:
{code:java}
sql("SELECT SUBSTRING('1234', 1::BIGINT)")
# NoSuchMethodException:
org.apache.calcite.runtime.SqlFunctions.substring(java.lang.String, long)
sql("SELECT SUBSTRING('1234', 1::DECIMAL(1))")
# NoSuchMethodException:
org.apache.calcite.runtime.SqlFunctions.substring(java.lang.String,
java.math.BigDecimal)
{code}
Probably other functions, that accept values that lie in the domain of INT
type, are affected as well.
> Sql. Type mismatch errors for numeric types in function calls leak into
> runtime.
> --------------------------------------------------------------------------------
>
> Key: IGNITE-20721
> URL: https://issues.apache.org/jira/browse/IGNITE-20721
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Reporter: Maksim Zhuravkov
> Priority: Minor
> Labels: ignite-3
>
> Example:
> {code:java}
> sql("SELECT ROUND(1.12, 1::DECIMAL(1))");
> # SqlValidatorException: Cannot apply 'ROUND' to arguments of type
> 'ROUND(<DECIMAL(3, 2)>, <DECIMAL(1, 0)>)'. Supported form(s):
> 'ROUND(<NUMERIC>, <INTEGER>)'
> SELECT ROUND(1.123, 1::BIGINT)
> {code}
> But this example produces a runtime error:
> {code:java}
> sql("SELECT ROUND(1.12, 1::BIGINT)");
> # NoSuchMethodException:
> org.apache.ignite.internal.sql.engine.exec.exp.IgniteSqlFunctions.sround(java.math.BigDecimal,
> long)
> {code}
> SUBSTRING function is also affected by this error:
> {code:java}
> sql("SELECT SUBSTRING('1234', 1::BIGINT)")
> # NoSuchMethodException:
> org.apache.calcite.runtime.SqlFunctions.substring(java.lang.String, long)
> sql("SELECT SUBSTRING('1234', 1::DECIMAL(1))")
> # NoSuchMethodException:
> org.apache.calcite.runtime.SqlFunctions.substring(java.lang.String,
> java.math.BigDecimal)
> {code}
> Probably other functions, that accept values that belong to the domain of INT
> type, are affected as well.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
