Skip to content

Expression 'LOWER(t.NAME)' in the SQL tree does not have a type mapping assigned. #1081

Open
@Norpa

Description

@Norpa

To test:

Add the line:
var query = db.Set()
.CountAsync(u => u.Name.ToLower().Trim() == "foobar" && u.Id != 27);

to the InsertTest.cs file on line 227.
and run FirebirdSql.EntityFrameworkCore.Firebird.Test you will get :

  1. Error : FirebirdSql.EntityFrameworkCore.Firebird.Tests.EndToEnd.InsertTests.TwoComputedInsert
    System.InvalidOperationException : Expression 'LOWER(t.NAME)' in the SQL tree does not have a type mapping assigned.
    at Microsoft.EntityFrameworkCore.Query.RelationalSqlTranslatingExpressionVisitor.SqlTypeMappingVerifyingExpressionVisitor.VisitExtension(Expression extensionExpression)

Metadata

Metadata

Assignees

Labels

Type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions