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

Discussion of open issues, suggestions and bugs regarding LinqConnect – Devart's LINQ to SQL compatible ORM
Post Reply
AKRRKA
Posts: 198
Joined: Thu 26 Jan 2012 15:07
Location: Russia
Contact:

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

Post by AKRRKA » Mon 25 Mar 2019 14:56

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.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

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

Post by Shalex » Fri 29 Mar 2019 20:18

We have reproduced the bug and will notify you when it is fixed.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

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

Post by Shalex » Fri 12 Apr 2019 17:40

The bug with the materialization of UInt32 values greater than Int32.MaxValue is fixed (SQL Server): viewtopic.php?f=31&t=38639.

Post Reply