An exception is thrown when Enum values are compared

[ilyapavlovdx]

An exception with the following message is thrown when Enum values are compared by "<" or ">":

System.InvalidOperationException: The LINQ expression 'DbSet()
.Where(n => n.Status.CompareTo((object)Read) < 0)' could not be translated.

The issue is reproduced in EF Core v5.06

Filter:

[[["status","<",1],"or",["status","=",null]],"or",[["status","=",1],"and",[[["id","<",99],"or",["id","=",null]],"or",[["id","=",99],"and",["id","<",99]]]]]

Data model:

public class Note
    {
        public int Id { get; set; }
        public string Text { get; set; }
        public Status Status { get; set; }
    }
    public enum Status
    {
        Unread = 0,
        Read = 1,
    }

[AlekseyMartynov]

Thanks @ilyapavlovdx

Possibly related: #493 (comment)