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 MySql.Data.EntityFramework
to Pomelo.EntityFrameworkCore.MySql
(an alternative OSS EF.Core implementation for MySQL). Otherwise, you may just have to wait for Oracle to fix the issue.