upsert()
not working when trying to update a DateTime
with a higher precision than configured
#18833
Labels
bug/1-unconfirmed
Bug should have enough information for reproduction, but confirmation has not happened yet.
kind/bug
A reported bug.
team/client
Issue for team Client.
tech/engines/query engine
Issue in the Query Engine
topic: dates / DateTime
topic: upsert()
Bug description
When I tried to upsert a timestamp (example:
2023-04-02T10:13:25.915541Z
) into my PostgreSQL DB (whoseDateTime
field uses a default precision of 3), I ran into a unique constraint that I had set for the field.The inserting beforehand worked (when there wasn't a value there).
More info (with a slightly more bloated prisma and code example) can be found in this thread.
How to reproduce
Expected behavior
Expected to upsert the value as expected (maybe with a rounded value)
Prisma information
Code:
Environment & setup
Prisma Version
The text was updated successfully, but these errors were encountered: