[BUG]: Introspect migration has unterminated comment

[jansedlon]

What version of drizzle-orm are you using?

0.30.7

What version of drizzle-kit are you using?

0.20.14

Describe the Bug

1. Have an existing Prisma DB
2. Create drizzle config
3. Run drizzle-kit introspect:pg
4. Run the generated migration

It throws

error: unterminated /* comment at or near "/*
DO $$ BEGIN
 CREATE TYPE "UserRole" AS ENUM('ADMIN', 'USER');
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;
"
error: unterminated /* comment at or near "/*
DO $$ BEGIN
 CREATE TYPE "UserRole" AS ENUM('ADMIN', 'USER');
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;
"

Expected behavior

It shouldn't do anything since the whole migration is commented

The initial migration looks like this

-- Current sql file was generated after introspecting the database
-- If you want to run this migration please uncomment this code before executing migrations
/*
DO $$ BEGIN
 CREATE TYPE "UserRole" AS ENUM('ADMIN', 'USER');
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;

-- Rest of the migration
-- ...

Environment & setup

No response

[jansedlon]

Reading the comment in the initial migration again.. I'm not sure if it means that commenting this is optional is I most likely have an already setup database and this migrations shouldn't run or the comment syntax is wrong on purpose and I should specifically remove the comment :D

But seems like the C like syntax is supported

[ovistoica]

I have the same bug and I can't finish the migration from prisma

[jpgcarvalho]

I'm facing the same error. What can i do to solve that problem?