Page 1 of 1

LinqConnect Professional Version 4.8.1665 (14-Feb-2019) - Cannot Materialize System.UInt32 for MS SQL

Posted: Mon 25 Mar 2019 14:56
by AKRRKA
LinqConnect Professional Version 4.8.1665 (14-Feb-2019) - Cannot Materialize System.UInt32 for MS SQL

Hello,

I have any new error. Cant materialize object with value UInt32 as 4294967295 and more for MS SQL Server.

Code: Select all

MainException:
Message: Переполнение в результате выполнения арифметической операции.
Source: 
Anonymously Hosted DynamicMethods Assembly
Data: 
System.Collections.ListDictionaryInternal
StackTrace: 
   в MaterializeConcentrator(MaterializerScope )
   в Devart.Data.Linq.Engine.db.a()
   в Devart.Data.Linq.Engine.b9.b(a& A_0)
   в Devart.Data.Linq.Engine.b9.h()
   в Devart.Data.Linq.DataProvider.a(av A_0, IDbConnection A_1, IDataReader A_2)
   в Devart.Data.Linq.DataProvider.a(av A_0, Object[] A_1)
   в Devart.Data.Linq.Engine.DataQuery`1.System.Linq.IQueryProvider.Execute[S](Expression expression)
To reproduce this problem:
1) Create a field of type System.UInt32 (for MS SQL this will be bigint)
2) Add a value of 4294967295 or any other more 2147483647 (Int32.MaxValue)
3) Select this field.

PS: On MySQL, SQLite, PostgreSQL no problem. Only on MS SQL is reproduced.

Re: LinqConnect Professional Version 4.8.1665 (14-Feb-2019) - Cannot Materialize System.UInt32 for MS SQL

Posted: Fri 29 Mar 2019 20:18
by Shalex
We have reproduced the bug and will notify you when it is fixed.

Re: LinqConnect Professional Version 4.8.1665 (14-Feb-2019) - Cannot Materialize System.UInt32 for MS SQL

Posted: Fri 12 Apr 2019 17:40
by Shalex
The bug with the materialization of UInt32 values greater than Int32.MaxValue is fixed (SQL Server): viewtopic.php?f=31&t=38639.