drizzle-team / drizzle-team/drizzle-orm

[BUG]: Cannot read properties of undefined (reading 'replace')

Open
#5,699 3 comments 0 reactions 0 assignees View on GitHub
bug bug/cant-reproduce
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?

1.0.0-beta.21

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

1.0.0-beta.21

### Other packages

@effect/sql@0.51.0, @effect/sql-pg@0.52.1

### Describe the Bug

The database is PostgreSQL. Most queries work well. Even this particular query works sometimes, but it fails in some conditions (it works reliably in some tests, and fails reliably in others, even when there seems to be no difference).

Good to know: there are differences between the tests and staging. During the tests it works for some tests (temporary databases created by Docker), in staging it never works.

The command that throws the error:
```typescript
db.query.myTable.findFirst({
where: { id: { eq: id } },
})
```

The error when it's catched in drizzle
```
Exception has occurred: TypeError: Cannot read properties of undefined (reading 'replace')
at escapeName (file:///home/myuser/Workspaces/myproject/node_modules/.pnpm/drizzle-orm@1.0.0-beta.21_@effect+sql-pg@0.52.1_@effect+experimental@0.60.0_@effect+pla_04de123abaa87869d115665adc932943/node_modules/drizzle-orm/pg-core/dialect.js:27:19)
at file:///home/myuser/Workspaces/myproject/node_modules/.pnpm/drizzle-orm@1.0.0-beta.21_@effect+sql-pg@0.52.1_@effect+experimental@0.60.0_@effect+pla_04de123abaa87869d115665adc932943/node_modules/drizzle-orm/sql/sql.js:87:10
at Array.map ()
at SQL.buildQueryFromSourceParams (file:///home/myuser/Workspaces/myproject/node_modules/.pnpm/drizzle-orm@1.0.0-beta.21_@effect+sql-pg@0.52.1_@effect+experimental@0.60.0_@effect+pla_04de123abaa87869d115665adc932943/node_modules/drizzle-orm/sql/sql.js:81:30)
at file:///home/myuser/Workspaces/myproject/node_modules/.pnpm/drizzle-orm@1.0.0-beta.21_@effect+sql-pg@0.52.1_@effect+experimental@0.60.0_@effect+pla_04de123abaa87869d115665adc932943/node_modules/drizzle-orm/sql/sql.js:103:36
at Array.map ()
at SQL.buildQueryFromSourceParams (file:///home/myuser/Workspaces/myproject/node_modules/.pnpm/drizzle-orm@1.0.0-beta.21_@effect+sql-pg@0.52.1_@effect+experimental@0.60.0_@effect+pla_04de123abaa87869d115665adc932943/node_modules/drizzle-orm/sql/sql.js:81:30)
at file:///home/myuser/Workspaces/myproject/node_modules/.pnpm/drizzle-orm@1.0.0-beta.21_@effect+sql-
```
Any pointer is welcome, thanks in advance!

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.