The ANSI/ISO standard SQL 92 refers to three different read phenomena when Transaction 1 reads data that Transaction 2 might have changed.
In the following examples, two transactions take place. In the first, Query 1 is performed. Then, in the second transaction, Query 2 is performed and committed. Finally, in the first transaction, Query 1 is performed again.
The queries use the following data table:
| id | name | age |
|---|---|---|
| 1 | Joe | 20 |
| 2 | Jill | 25 |
Read more about this topic: Isolation (database Systems)
Famous quotes containing the words read and/or phenomena:
“... a friend told me that she had read of a woman who had knitted a wash rag for President Wilson. She was eighty years old and her friends thought it remarkable that she could knit a wash rag! I thought that if a woman of eighty could knit a wash rage for a Democratic President it behooved one of ninety-six to make something more than a wash rag for a Republican President.”
—Maria D. Brown (1827–1927)
“War seems to be one of the most salutary phenomena for the culture of human nature; and it is not without regret that I see it disappearing more and more from the scene.”
—Karl Wilhelm Von Humboldt (1767–1835)