drizzle-team / drizzle-team/drizzle-orm

Error in generateMigration when change varchar to jsonb

Open
#3,351 2 comments 4 reactions 0 assignees View on GitHub
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.