insertOnConflictUpdate not changing null value on nullable fields

[Enhed]

can its be fixed?

import 'package:moor/moor.dart';

class OperationCargos extends Table {
  TextColumn get id => text()();
  TextColumn get cargo => text()();
  TextColumn get weight => text().nullable()();
  TextColumn get volume => text().nullable()();
  TextColumn get length => text().nullable()();
  TextColumn get width => text().nullable()();
  TextColumn get height => text().nullable()();
  TextColumn get plan => text()();

  BoolColumn get changed => boolean().clientDefault(() => false)();

  @JsonKey('barcode_plan') TextColumn get barcodePlan => text()();
  @JsonKey('barcode_fact') TextColumn get barcodeFact => text().nullable()();

  @override
  Set<Column>? get primaryKey => { id };
}

@UseMoor(
  tables: [OperationCargos]
)
class AppDatabase extends _$AppDatabase {
  AppDatabase() : super(_openConnection());

  @override
  int get schemaVersion => 1;

  Future foo() async {
    final original = OperationCargo(
      id: 'some_id',
      barcodePlan: '',
      cargo: '',
      changed: false,
      plan: '',
      width: '1',
      height: '2',
      length: '3',
      volume: '4',
      weight: '5'
    );
    
    await into(operationCargos).insertOnConflictUpdate(original);
    
    final copy = original.copyWith(
        width: null,
        height: null,
        length: null,
        volume: null,
        weight: null
    );

    await into(operationCargos).insertOnConflictUpdate(copy);
  }
}

fields width, height, length, volume, weight not changes, stay as in original object

ps. without method copyWith will be same problem

[simolus3]

Can you post a relevant table definition and a way to reproduce the behavior you're describing?

[simolus3]

Where do you get that error? After enabling the option, you'll have to use Value for all nullable columns.

[Enhed]

[simolus3]

weight: Value(weight ?? null) would be the equivalent.

[Enhed]

[simolus3]

Did you enable the option and re-run the build? Is weight even nullable?