[
https://issues.apache.org/jira/browse/IGNITE-23349?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Iurii Gerzhedovich reassigned IGNITE-23349:
-------------------------------------------
Assignee: Iurii Gerzhedovich
> Sql. Investigate modulo reaction with different fractional types
> -----------------------------------------------------------------
>
> Key: IGNITE-23349
> URL: https://issues.apache.org/jira/browse/IGNITE-23349
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Affects Versions: 3.0.0-beta1
> Reporter: Evgeny Stanilovsky
> Assignee: Iurii Gerzhedovich
> Priority: Major
> Labels: ignite-3
>
> Passed:
> {noformat}
> select '12'::int8 % '-2.2247526E4'::real
> {noformat}
> Failed:
> {noformat}
> select '12'::int8 % '-2.2247526E8'::real
> {noformat}
> {noformat}
> Caused by: org.apache.ignite.sql.SqlException: IGN-SQL-7
> TraceId:24a5acaa-18de-4009-96de-4b5bfa4a1840 Numeric field overflow. A field
> with precision 14, scale 7 must round to an absolute value less than 10^7.
> at SC.execute(Unknown Source)
> at
> org.apache.ignite.internal.sql.engine.exec.exp.ExpressionFactoryImpl$ProjectImpl.apply(ExpressionFactoryImpl.java:772)
> at
> org.apache.ignite.internal.sql.engine.exec.rel.ProjectNode.push(ProjectNode.java:69)
> at
> org.apache.ignite.internal.sql.engine.exec.rel.ScanNode.push(ScanNode.java:125)
> ... 5 more
> Caused by: org.apache.ignite.sql.SqlException: IGN-SQL-7
> TraceId:24a5acaa-18de-4009-96de-4b5bfa4a1840 Numeric field overflow. A field
> with precision 14, scale 7 must round to an absolute value less than 10^7.
> at
> org.apache.ignite.internal.sql.engine.exec.exp.IgniteSqlFunctions.numericOverflowError(IgniteSqlFunctions.java:433)
> at
> org.apache.ignite.internal.sql.engine.exec.exp.IgniteSqlFunctions.processValueWithIntegralPart(IgniteSqlFunctions.java:377)
> at
> org.apache.ignite.internal.sql.engine.exec.exp.IgniteSqlFunctions.toBigDecimal(IgniteSqlFunctions.java:355)
> at
> org.apache.ignite.internal.sql.engine.exec.exp.IgniteSqlFunctions.toBigDecimal(IgniteSqlFunctions.java:276)
> ... 9 more
> {noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
