I am working on the IdentityServer4 with MySQL and .NET Core.
When I generate the token using the link, I get the below attached error.
I converted all the Boolean fields to short.
modelBuilder.Entity<Patient>() .Property(r => r.IsDeleted) .HasConversion(new BoolToZeroOneConverter<short>());
It appears that you're encountering a known bug: https://bugs.mysql.com/bug.php?id=92987
On the similar issue https://bugs.mysql.com/bug.php?id=93028, people have reported success by switching away from
Pomelo.EntityFrameworkCore.MySql (an alternative OSS EF.Core implementation for MySQL). Otherwise, you may just have to wait for Oracle to fix the issue.