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

[thoho]

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 

[Shalex]

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]

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]

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]

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

[Shalex]

Thank you for letting us know.