drizzle-team / drizzle-team/drizzle-orm
Error in generateMigration when change varchar to jsonb
Open
db/postgres
drizzle/kit
improvement
- Dominant language
- TypeScript
- Stars
- 35.8k
- Forks
- 1.6k
- Avg merge
- 2d 7h
- Merged PRs (30d)
- 4
Description
## Description
Reproduction is in https://github.com/SimYunSup/example-list/tree/drizzle-kit/jsonb-error
When Changing `varchar()` to `jsonb()`, `generateMigration` generate like below.
```sql
ALTER TABLE "tests" ALTER COLUMN "json" SET DATA TYPE jsonb;
```
It generate migration error as `Token "json" is invalid.`.
So I think it must be like below.
```sql
ALTER TABLE "tests" ALTER COLUMN "json" SET DATA TYPE jsonb USING to_jsonb("json");
```
Related in [payloadcms/payload#6633](https://github.com/payloadcms/payload/issues/6633)
Contributor guide
Assessment
This issue has not been assessed yet.