drizzle-team / drizzle-orm

Headless TypeScript ORM with a head. Runs on Node, Bun and Deno. Lives on the Edge and yes, it's a JavaScript ORM too 😅
https://orm.drizzle.team
Apache License 2.0
24.61k stars 649 forks source link

[BUG]: it's still showing that the column types are incompatible even though I have changed the type #3589

Open Boby900 opened 1 day ago

Boby900 commented 1 day ago

Report hasn't been filed before.

What version of drizzle-orm are you using?

^0.36.0

What version of drizzle-kit are you using?

^0.27.1

Other packages

No response

Describe the Bug

I have changed the type of the user_id column from integer to text, I was referencing this column in two other columns as well so even though in my migrations files it's showing that it altered the type of all the tables("foreign key included") it's saying that types are incompatible. I have some existing data in the tables which is of type integer but from now on I want to change the type of all tables from integer to text

Screenshot (705)

Boby900 commented 1 day ago

Screenshot (706)