79569516

Date: 2025-04-11 18:38:21
Score: 2.5
Natty:
Report link

The initial insert sets ver = 0, and the UPDATE doesn't apply because ver wasn't yet updated in the same statement context. By using a CTE that returns id and time, and then updating based on that, we ensure the inserted values are immediately available to compute ver = id + time.

Reasons:
  • Low length (0.5):
  • No code block (0.5):
  • Single line (0.5):
  • Low reputation (1):
Posted by: Oleksandr Senkiv