SeaORM creating NOT NULL constraints for columns marked with .null() and causes NOT NULL violation in Sqlite

[mcfriend99]

Hi,

I have a migration defined as follows:

manager
  .create_table(
    Table::create()
      .table(MyModel::Table)
      .if_not_exists()
      .col(pk_auto(MyModel::Id))
      .col(string(MyModel::Address).unique_key().not_null())
      .col(string(MyModel::Creator))
      .col(string(MyModel::Market).null())
      .col(double(MyModel::Price).default(0.0))
      .col(date_time(MyModel::CreatedAt).default(Expr::current_timestamp()))
      .to_owned(),
  )

But every time I try to insert into the table, I get the following error:

Execution Error: error returned from database: (code: 1299) NOT NULL constraint failed: my_model.market

I'm using SQLite.

I have the following dependencies in my Cargo.toml file:

futures = "0.3.30"
sea-orm = { version = "1.0.0", features = [ "sqlx-sqlite", "runtime-tokio-native-tls", "macros" ] }
sea-orm-migration = "1.0.0"

Any help will be appreciated.

[Borderliner]

Same issue! This is how I create the table:

manager
    .create_table(
        Table::create()
            .table(Users::Table)
            .if_not_exists()
            .col(string(Users::Ulid).primary_key())
            .col(string(Users::Username).unique_key().not_null())
            .col(string(Users::Email).unique_key().not_null())
            .col(string(Users::Password).not_null())
            .col(string(Users::DisplayName).not_null())
            .col(string(Users::Avatar).null())
            .col(integer(Users::Coins).default(0))
            .col(enumeration(Users::Role, Alias::new("role"), Role::iter()).default(Role::Standard))
            .col(date_time(Users::CreatedAt).default(chrono::Utc::now()))
            .col(date_time(Users::UpdatedAt))
            .to_owned(),
    )
    .await?

This is the SQL I'm getting:

CREATE TABLE IF NOT EXISTS "users" ( "ulid" varchar NOT NULL PRIMARY KEY, "username" varchar NOT NULL UNIQUE NOT NULL, "email" varchar NOT NULL UNIQUE NOT NULL, "password" varchar NOT NULL NOT NULL, "display_name" varchar NOT NULL NOT NULL, "avatar" varchar NOT NULL NULL, "coins" integer NOT NULL DEFAULT 0, "role" enum_text NOT NULL DEFAULT 2, "created_at" datetime_text NOT NULL DEFAULT '2024-09-01 16:00:25 +00:00', "updated_at" datetime_text NOT NULL )

where avatar is both NULL and NOT NULL. I have not applied any constraints via sea_orm macro.

[dependencies.sea-orm-migration]
version = "~1.1.0-rc.1" # sea-orm-migration version
features = [
  "runtime-tokio-rustls",
]

[mcfriend99]

I experienced the same. I had to use string_null. For some reasons, it didn't have the same issue.

[Borderliner]

I just found out that too!

[Borderliner]

@billy1624 This is a critical bug, can you please look into it?