drizzle-team / drizzle-team/drizzle-orm

[BUG]: Drizzle-Kit Push errors with generation expression is not immutable

Open
#4,953 2 comments 0 reactions 0 assignees View on GitHub
bug bug/fixed-in-beta
Dominant language
TypeScript
Stars
35.8k
Forks
1.6k
Avg merge
2d 7h
Merged PRs (30d)
4

Description

### Report hasn't been filed before.

- [x] I have verified that the bug I'm about to report hasn't been filed before.

### What version of `drizzle-orm` are you using?

0.44.4

### What version of `drizzle-kit` are you using?

0.31.4

### Other packages

_No response_

### Describe the Bug

Attempting to `drizzle-kit push` a generated columns fails with `error: generation expression is not immutable`

```
export const userDevice = app.table('user_device', {
id: uuid('id').defaultRandom().primaryKey(),
mode: varchar('device_mode')
.notNull()
userId: varchar('user_id')
.notNull()
.references(() => users.id, { onDelete: 'cascade' }),
userIdDeviceMode: varchar('user_id_device_mode4').generatedAlwaysAs(
() => sql`${userDevice.userId} || ${userDevice.mode}`
),
});
```

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.