EF Core 8.0: ORA-00932 - expected - got CLOB

[arthur-liberman]

Hi, I think this issue might be related to an earlier issue #296 I opened, or maybe not. It's very easy to reproduce. Consider this query (not very imaginative, but it reproduces) var res = await dbContext.Categories.Where(c=>c.Name.Contains(c.SubName)).ToListAsync();

• Please note that in case of NVARCHAR2 and NCLOB combination there is the same problem.

  public class Category
  {
  public int CatId { get; set; }
  public string Name { get; set; }
  public string SubName { get; set; }
  public string Description { get; set; }
  }
  public class CategoryConfiguration : IEntityTypeConfiguration<Category>
  {
  public void Configure(EntityTypeBuilder<Category> builder)
  {
      builder.ToTable("Category");
      builder.HasKey(o => o.CatId);
      builder.Property(t => t.CatId).ValueGeneratedOnAdd();
      builder.Property(t => t.Name).HasMaxLength(int.MaxValue); // CLOB
      builder.Property(t => t.SubName).HasMaxLength(256);       // VARCHAR2(256)
  }
  }

[alexkeh]

Did this problem start occurring with EF Core 8.0.2?

If so, the problem could be the same as #362, which is a result of EF Core base bug: https://github.com/dotnet/efcore/issues/33218

[arthur-liberman]

It's not the same, I applied AppContext.SetSwitch("Microsoft.EntityFrameworkCore.Issue32325", true); and it solved another issue where strings were concatenated, but this issue remains. Please try to reproduce, you should see that the workaround has no effect.

[alexkeh]

I was able to reproduce your error. I have filed a bug (36790369) to have the Oracle .NET dev team investigate. Thanks for reporting the issue!