Migrating from Decimal to Decimal[] breaks

[timsuchanek]

I have this schema in Postgres:

model B {
  id       String    @id @default(cuid())
  float    Float     @db.Real
  dFloat   Float     @db.DoublePrecision
  decFloat Decimal @db.Decimal(20, 10)
  numFloat Decimal @db.Numeric(10, 6)
}

and I want to change it to this:

model B {
  id       String    @id @default(cuid())
  float    Float     @db.Real
  dFloat   Float     @db.DoublePrecision
  decFloat Decimal[] @db.Decimal(20, 10)
  numFloat Decimal[] @db.Numeric(10, 6)
}

It errors like so:

Error: Error querying the database: Null constraint failed: (float)
   0: sql_migration_connector::sql_database_step_applier::apply_step
           with index=0
             at migration-engine/connectors/sql-migration-connector/src/sql_database_step_applier.rs:15
   1: migration_core::api::SchemaPush
             at migration-engine/core/src/api.rs:188

[tomhoule]

There are two issues with this schema:

• Migrations from decimal to array of decimals doesn't work. This is addressed by https://github.com/prisma/prisma-engines/pull/1306
• Something to do with the float columns. This is currently not implemented in the migration engine, it will be part of the native types effort

[tomhoule]

Closing this as there is no other actionable item than "implement native types" — it is work in progress.