drizzle-team / drizzle-team/drizzle-orm

[BUG]: sqlite-proxy require `rows: any[]` but runtime expects `undefined` for `get` method no-row result

Open
#5,461 2 comments 1 reaction 0 assignees View on GitHub
bug
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.45.1

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

0.31.9

### Other packages

_No response_

### Describe the Bug

```ts
import { drizzle } from "drizzle-orm/sqlite-proxy"

drizzle((query, values, method) => {
if (method === 'get') {
return { rows: [] /* should use falsy value here to indicate no rows instead */ }
}
}, schema)
```

if returns `[]` as rows a db query like `db.query.table.findFirst({ columns: {id: true} })` will return `{id: undefined}` even if the row does not exist

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.