79655054

Date: 2025-06-05 18:46:07
Score: 1
Natty:
Report link

For an SQL-compliant database, the answer is no.

A single UPDATE statement is atomic, in your scenario there is no way your SELECT statement can return a mix of old and new values.

source: SQL specifications 4.30-4-Statement Atomicity

Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (1):
Posted by: ShiftHappens