Error: not able to set an empty array as the default value for a field

[AH-dark]

Description

If I use

ColumnDef::new(Items::Children)
  .not_null()
  .array(ColumnType::Uuid)
  .default(Value::Array(ArrayType::Uuid, Some(Box::default()))) 

to try to build a field with an empty array as the default value, the generated SQL is:

ALTER TABLE "items" DROP COLUMN "children", ADD COLUMN "children" uuid[] NOT NULL DEFAULT ARRAY []%

This made it impossible to construct this field via regular ORM operations, and I had to use SimpleExpr::Custom.

Expected Behavior

The normal operation should be ALTER TABLE "items" DROP COLUMN "children", ADD COLUMN "children" uuid[] NOT NULL DEFAULT ARRAY[]::uuid[].

Actual Behavior

Migrator will encounter an error Execution Error: error returned from database: cannot determine type of empty array.

Versions

I'm currently using the version 1.1.2, but this operation is unavailable in all versions.

[AH-dark]

This issue has been raised at SeaQL/sea-query#853 and #2068 and implemented at SeaQL/sea-query#854, but it has not been merged.