[IGNITE-23243] .NET: LINQ: Value was either too large or too small for a Decimal

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: 3.0
• Labels: ignite-3
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Pavel Tupitsyn
• Reporter: Pavel Tupitsyn
• Created: 20/Sep/24 11:52
• Updated: 02/Oct/24 12:14

Description

IGNITE-21743 generates SQL with DECIMAL(60, 30) casts, but the resulting values might exceed maximum decimal precision in .NET (28-29 digits).

After IGNITE-23192 fix, TestCastToDecimalPrecision fails:

System.OverflowException : Value was either too large or too small for a Decimal.
10:07:15            at System.Numerics.BigInteger.op_Explicit(BigInteger value)
           at Apache.Ignite.Internal.Proto.BinaryTuple.BinaryTupleReader.ReadDecimalUnscaled(ReadOnlySpan`1 span, Int32 scale) in /opt/buildagent/work/b8d4df1365f1f1e5/modules/platforms/dotnet/Apache.Ignite/Internal/Proto/BinaryTuple/BinaryTupleReader.cs:line 569
           at Apache.Ignite.Internal.Proto.BinaryTuple.BinaryTupleReader.ReadDecimal(ReadOnlySpan`1 span, Int32 scale) in /opt/buildagent/work/b8d4df1365f1f1e5/modules/platforms/dotnet/Apache.Ignite/Internal/Proto/BinaryTuple/BinaryTupleReader.cs:line 563
           at Apache.Ignite.Internal.Proto.BinaryTuple.BinaryTupleReader.GetDecimalNullable(Int32 index, Int32 scale) in /opt/buildagent/work/b8d4df1365f1f1e5/modules/platforms/dotnet/Apache.Ignite/Internal/Proto/BinaryTuple/BinaryTupleReader.cs:line 264
           at SingleColumnFromBinaryTupleReader_System.Nullable`1[[System.Decimal, System.Private.CoreLib, Version=6.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]_57(IReadOnlyList`1 , BinaryTupleReader& )
           at Apache.Ignite.Internal.Sql.ResultSet`1.ReadRow(IReadOnlyList`1 cols, MsgPackReader& reader)
           at Apache.Ignite.Internal.Sql.ResultSet`1.<>c__DisplayClass37_0.<<EnumerateRows>g__EnumeratePage|0>d.MoveNext()
           at Apache.Ignite.Internal.Sql.ResultSet`1.EnumerateRows()+MoveNext()
           at Apache.Ignite.Internal.Sql.ResultSet`1.EnumerateRows()+System.Threading.Tasks.Sources.IValueTaskSource<System.Boolean>.GetResult()
           at Apache.Ignite.Internal.Linq.IgniteQueryExecutor.ExecuteCollection[T](QueryModel queryModel)+MoveNext()
           at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
           at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
           at Apache.Ignite.Tests.Linq.LinqTests.TestCastToDecimalPrecision()

Issue Links

• is blocked by: IGNITE-23340 .NET: Some BigDecimal values can't be represented
• is caused by: IGNITE-21743 .NET: LINQ: Cast to decimal loses precision
• is related to: IGNITE-23192 Sql. Arithmetic operations failed with "out of range" exception.