DT

Drizzle Team•3y ago

Yarulf

Issue with 'insert on conflict do update where'

I am using
db.insert(lastHeaterMetricsTable)
.values(heaterEntityWithMaxTime)
.onConflictDoUpdate({
target: lastHeaterMetricsTable.deviceId,
set: heaterEntityWithMaxTime,
where: lt(
lastHeaterMetricsTable.receivedAt,
heaterEntityWithMaxTime.receivedAt,
),
})
.execute()

But as the query result I get the following:

where

where

statement is before

do update

do update

, that's why query failes. Drizzle ORM 0.25.4