79451654

Date: 2025-02-19 14:18:48
Score: 1
Natty:
Report link

From my understanding non-repaetable read means you read something start of transaction and in the if you read the same you get different result , but in phantom reads it mostly occurs in range queries , so if you send same query anytime in transaction if there is no new data added you will get sam result because it locks , existing infos but can not lock new one for this reason in the second query you will get different result, but if there is just update not insert you will get same result in phantom reads and it will not be phantom reads :).

Reasons:
  • Long answer (-0.5):
  • No code block (0.5):
  • Single line (0.5):
  • Low reputation (0.5):
Posted by: Habibov Ulug'bek