Schema used for reproduction

Initial:

generator client {
  provider = "prisma-client-js"
}

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

model Test {
  id   String @id @default(cuid())
  name String
  cat  Cat    @default(PERSIAN)
}

enum Cat {
  PERSIAN
  BLACK
}

Final:

generator client {
  provider = "prisma-client-js"
}

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

model Test {
  id   String @id @default(cuid())
  name String
  cat  Cat    @default(PERSIAN)
}

enum Cat {
  PERSIAN
  NORI
}

generated migrations:

-- CreateEnum
CREATE TYPE "Cat" AS ENUM ('PERSIAN', 'BLACK');

-- CreateTable
CREATE TABLE "Test" (
    "id" TEXT NOT NULL,
    "name" TEXT NOT NULL,
    "cat" "Cat" NOT NULL DEFAULT E'PERSIAN',

    PRIMARY KEY ("id")
);

/*
  Warnings:

  - The migration will remove the values [BLACK] on the enum `Cat`. If these variants are still used in the database, the migration will fail.

*/
-- AlterEnum
BEGIN;
CREATE TYPE "Cat_new" AS ENUM ('PERSIAN', 'NORI');
ALTER TABLE "public"."Test" ALTER COLUMN "cat" TYPE "Cat_new" USING ("cat"::text::"Cat_new");
ALTER TYPE "Cat" RENAME TO "Cat_old";
ALTER TYPE "Cat_new" RENAME TO "Cat";
DROP TYPE "Cat_old";
COMMIT;

Version:

Environment variables loaded from prisma/.env
@prisma/cli          : 2.14.0-dev.39
@prisma/client       : 2.14.0-dev.39
Current platform     : darwin
Query Engine         : query-engine af950b3705ef175e85492660c621085eb7f99557 (at node_modules/@prisma/engines/query-engine-darwin)
Migration Engine     : migration-engine-cli af950b3705ef175e85492660c621085eb7f99557 (at node_modules/@prisma/engines/migration-engine-darwin)
Introspection Engine : introspection-core af950b3705ef175e85492660c621085eb7f99557 (at node_modules/@prisma/engines/introspection-engine-darwin)
Format Binary        : prisma-fmt af950b3705ef175e85492660c621085eb7f99557 (at node_modules/@prisma/engines/prisma-fmt-darwin)
Studio               : 0.331.0

Change enum values when there is a default enum value fails migration #4696

Description

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions