drizzle-team / drizzle-team/drizzle-orm

[BUG]: Syntax error with generatedAlwaysAs when using `drizzle-kit push`

Open
#2,883 5 comments 0 reactions 0 assignees View on GitHub
docs docs/incorrect
Dominant language
TypeScript
Stars
35.8k
Forks
1.6k
Avg merge
2d 7h
Merged PRs (30d)
4

Description

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

0.33.0

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

0.24.2

### Describe the Bug

Using Postgres and the following table definition:
```typescript
export const users = createTable(
'users',
{
firstName: varchar('firstName', { length: 255 }).notNull(),
lastName: varchar('lastName', { length: 255 }).notNull(),
fullName: varchar('fullName', { length: 512 }).generatedAlwaysAs(
(): SQL => sql`${users.firstName} ${users.lastName}`
),
},
);
```

When I `drizzle-kit push`, I receive a syntax error `PostgresError: syntax error at or near ""users""`

### Expected behavior

No error, and a generated column.

### Environment & setup

_No response_

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.