RESOLVED: dotconnect for MySQL 8.6.753 (06-Oct-2016) critical bug

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
thoho
Posts: 6
Joined: Mon 11 Jul 2016 07:05

RESOLVED: dotconnect for MySQL 8.6.753 (06-Oct-2016) critical bug

Post by thoho » Sun 09 Oct 2016 18:14

It works OK on 8.6.743

Query:

Code: Select all

var query = from u in DbContext.Users
            join ur in DbContext.UserRoles on u.Id equals ur.UserId
            join r in DbContext.Roles on ur.RoleId equals r.Id
            where u.IsSystem == true && u.DeletedAt == null && ur.DeletedAt == null
            select new Domain.Users.UserWithRole
            {
                Id = u.Id,
                FirstName = u.FirstName,
                LastName = u.LastName,
                Email = u.Email,
                Activated = u.Activated,
                Phone = u.PhoneNumber,
                RoleName = r.Name
            };
return query.ToArray();
Now got critical bug on new update 8.6.753 (06-OCT-2016)

Code: Select all

System.NullReferenceException: Object reference not set to an instance of an object
  at Devart.Common.Entity.w.GenerateLiteral (System.Object value, Microsoft.EntityFrameworkCore.Storage.RelationalTypeMapping typeMapping) [0x00006] in <0fa51f7563e54c7cac3f29362f5a5df3>:0 
  at Microsoft.EntityFrameworkCore.Query.Sql.DefaultQuerySqlGenerator.VisitConstant (System.Linq.Expressions.ConstantExpression expression) [0x0002a] in <861afd9497d04ce091485c713400b127>:0 
  at System.Linq.Expressions.ConstantExpression.Accept (System.Linq.Expressions.ExpressionVisitor visitor) [0x00000] in <63992662b765477a898ef49cdcc99ee2>:0 
  at System.Linq.Expressions.ExpressionVisitor.Visit (System.Linq.Expressions.Expression node) [0x00006] in <63992662b765477a898ef49cdcc99ee2>:0 
Last edited by thoho on Mon 12 Dec 2016 04:01, edited 1 time in total.

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

Re: dotconnect for MySQL 8.6.753 (06-Oct-2016) critical bug

Post by Shalex » Mon 10 Oct 2016 13:58

Please send us a small test project with the corresponding DDL/DML script for reproducing the issue in our environment.

In case of >2MB attachment, we recommend either using some file exchange server (send us the corresponding link) or uploading a test project to our FTP server (the credentials will be provided by email request).

thoho
Posts: 6
Joined: Mon 11 Jul 2016 07:05

Re: dotconnect for MySQL 8.6.753 (06-Oct-2016) critical bug

Post by thoho » Sat 22 Oct 2016 01:16

Got same bug on 8.6.763 (20-Oct-2016)

Code: Select all

Microsoft.EntityFrameworkCore.Query.RelationalQueryCompilationContextFactory[1]
An exception occurred in the database while iterating the results of a query.
System.NullReferenceException: Object reference not set to an instance of an object.
at Devart.Common.Entity.w.GenerateLiteral(Object value, RelationalTypeMapping typeMapping)
at Microsoft.EntityFrameworkCore.Query.Sql.DefaultQuerySqlGenerator.VisitConstant(ConstantExpression expression)
at System.Linq.Expressions.ConstantExpression.Accept(ExpressionVisitor visitor)
at Remotion.Linq.Parsing.ThrowingExpressionVisitor.Visit(Expression expression)
at Microsoft.EntityFrameworkCore.Query.Sql.DefaultQuerySqlGenerator.VisitBinary(BinaryExpression expression)
at Devart.Common.Entity.ar.a(BinaryExpression A_0)

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

Re: dotconnect for MySQL 8.6.753 (06-Oct-2016) critical bug

Post by Shalex » Mon 24 Oct 2016 16:13

We cannot reproduce the error in our environment.

Please send us a small test project with the corresponding DDL/DML script for reproducing the issue in our environment.

In case of >2MB attachment, we recommend either using some file exchange server (send us the corresponding link) or uploading a test project to our FTP server (the credentials will be provided by email request).

thoho
Posts: 6
Joined: Mon 11 Jul 2016 07:05

Re: RESOLVED: dotconnect for MySQL 8.6.753 (06-Oct-2016) critical bug

Post by thoho » Mon 12 Dec 2016 04:10

I not spend time to investigate the root cause. When we try with new version 8.7.794 this morning, the issue is fixed :D

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

Re: RESOLVED: dotconnect for MySQL 8.6.753 (06-Oct-2016) critical bug

Post by Shalex » Mon 12 Dec 2016 10:45

Thank you for letting us know.

Post Reply