[MySql/MariaDb] Insert an boolean type has invalid result (Always insert true in a bit column)

[Cyril12740]

Hi,

With the following code, i have 2 different behaviours when the column's type is bit or tiny(1).

var items = new List<ConsoleApp1.BooleanBulkInsertDbContext.TestClass>()
{
    new()
    {
        Name = "Is active is true",
        IsActive = true,
    },
    new()
    {
        Name = "Is active is false",
        IsActive = false,
    }
};


DbContext context = GetDbContext();

context.BulkInsert(items);

When the column's type is tinyint(1), the inserted result is :

When the column's type is bit, the inserted result is :

[borisdj]

Unable to reproduce it.
I have added in Test InsertTestMySql in entity 2 new columns:

public bool IsActiveFirst { get; set; } // in db becomes TINYINT(1) by default

[Column(TypeName = "BIT")]
public bool IsActiveSecond { get; set; } // in db becomes BIT(1)

Then in test set:
IsActiveFirst = i % 2 == 0 ? true : false,
IsActiveSecond = i % 2 == 0 ? true : false,

In db first 4 rows are:
1 __ 0 __ 0
2 __ 1 __ 1
3 __ 0 __ 0
4 __ 1 __ 1
...

[borisdj]

Closing this for now, if you manage to make it reproducible, write it here and will reopen.

[chasse20]

Open this back up please. This is reproduceable and always outputs 1 even if the DTO's bool was set to false.

MySQL: 8.0.25
EFCore.BulkExtensions: 8.1.0
EFCore: 8.0.8

DTO:

public class DailyOption
{
	public int DailyOptionId { get; set; }
	public DateOnly Time { get; set; }
	public bool IsCall { get; set; }
}

Database Table:

CREATE TABLE `DailyOption` (
  `DailyOptionId` int NOT NULL AUTO_INCREMENT,
  `Time` date NOT NULL,
  `IsCall` bit(1) NOT NULL,
  PRIMARY KEY (`DailyOptionId`),
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;