drizzle-team / drizzle-team/drizzle-orm

[BUG]: Not able to use Case-Insensitive Unique indexed column with onConflictDoUpdate target field

Open
#4,596 2 comments 0 reactions 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.43.1

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

0.31.1

### Other packages

_No response_

### Describe the Bug

I have case insensitive email column, I want to use that column in target field of onConflictDoUpdate, it should accept sql template but currently it only accepts IndexColumn or IndexColumn[]. So I am not able to use case insensitive unique indexed columns with onConflictDoUpdate.

Image

Image

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.