drizzle-team / drizzle-team/drizzle-orm
[BUG]: Cannot read properties of undefined (reading 'replace')
- 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
Assessment
This issue has not been assessed yet.