/dports/databases/postgresql10-plperl/postgresql-10.19/src/test/isolation/expected/ |
H A D | read-only-anomaly-2.out | 4 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 10 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 16 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 22 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 24 step s2wx: UPDATE bank_account SET balance = -11 WHERE id = 'X'; 29 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 35 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 41 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 47 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 49 step s3r: SELECT id, balance FROM bank_account WHERE id IN ('X', 'Y') ORDER BY id; [all …]
|
/dports/databases/postgresql10-docs/postgresql-10.19/src/test/isolation/expected/ |
H A D | read-only-anomaly-2.out | 4 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 10 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 16 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 22 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 24 step s2wx: UPDATE bank_account SET balance = -11 WHERE id = 'X'; 29 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 35 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 41 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 47 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 49 step s3r: SELECT id, balance FROM bank_account WHERE id IN ('X', 'Y') ORDER BY id; [all …]
|
/dports/databases/postgresql10-pltcl/postgresql-10.19/src/test/isolation/expected/ |
H A D | read-only-anomaly-2.out | 4 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 10 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 16 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 22 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 24 step s2wx: UPDATE bank_account SET balance = -11 WHERE id = 'X'; 29 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 35 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 41 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 47 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 49 step s3r: SELECT id, balance FROM bank_account WHERE id IN ('X', 'Y') ORDER BY id; [all …]
|
/dports/databases/postgresql10-contrib/postgresql-10.19/src/test/isolation/expected/ |
H A D | read-only-anomaly-2.out | 4 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 10 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 16 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 22 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 24 step s2wx: UPDATE bank_account SET balance = -11 WHERE id = 'X'; 29 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 35 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 41 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 47 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 49 step s3r: SELECT id, balance FROM bank_account WHERE id IN ('X', 'Y') ORDER BY id; [all …]
|
/dports/databases/postgresql10-client/postgresql-10.19/src/test/isolation/expected/ |
H A D | read-only-anomaly-2.out | 4 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 10 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 16 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 22 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 24 step s2wx: UPDATE bank_account SET balance = -11 WHERE id = 'X'; 29 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 35 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 41 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 47 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 49 step s3r: SELECT id, balance FROM bank_account WHERE id IN ('X', 'Y') ORDER BY id; [all …]
|
/dports/databases/postgresql10-plpython/postgresql-10.19/src/test/isolation/expected/ |
H A D | read-only-anomaly-2.out | 4 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 10 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 16 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 22 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 24 step s2wx: UPDATE bank_account SET balance = -11 WHERE id = 'X'; 29 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 35 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 41 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 47 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 49 step s3r: SELECT id, balance FROM bank_account WHERE id IN ('X', 'Y') ORDER BY id; [all …]
|
/dports/databases/postgresql11-docs/postgresql-11.14/src/test/isolation/expected/ |
H A D | read-only-anomaly-2.out | 4 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 10 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 16 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 22 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 24 step s2wx: UPDATE bank_account SET balance = -11 WHERE id = 'X'; 29 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 35 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 41 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 47 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 49 step s3r: SELECT id, balance FROM bank_account WHERE id IN ('X', 'Y') ORDER BY id; [all …]
|
/dports/databases/postgresql11-plperl/postgresql-11.14/src/test/isolation/expected/ |
H A D | read-only-anomaly-2.out | 4 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 10 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 16 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 22 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 24 step s2wx: UPDATE bank_account SET balance = -11 WHERE id = 'X'; 29 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 35 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 41 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 47 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 49 step s3r: SELECT id, balance FROM bank_account WHERE id IN ('X', 'Y') ORDER BY id; [all …]
|
/dports/databases/postgresql11-contrib/postgresql-11.14/src/test/isolation/expected/ |
H A D | read-only-anomaly-2.out | 4 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 10 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 16 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 22 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 24 step s2wx: UPDATE bank_account SET balance = -11 WHERE id = 'X'; 29 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 35 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 41 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 47 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 49 step s3r: SELECT id, balance FROM bank_account WHERE id IN ('X', 'Y') ORDER BY id; [all …]
|
/dports/databases/postgresql11-client/postgresql-11.14/src/test/isolation/expected/ |
H A D | read-only-anomaly-2.out | 4 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 10 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 16 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 22 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 24 step s2wx: UPDATE bank_account SET balance = -11 WHERE id = 'X'; 29 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 35 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 41 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 47 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 49 step s3r: SELECT id, balance FROM bank_account WHERE id IN ('X', 'Y') ORDER BY id; [all …]
|
/dports/databases/postgresql11-pltcl/postgresql-11.14/src/test/isolation/expected/ |
H A D | read-only-anomaly-2.out | 4 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 10 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 16 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 22 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 24 step s2wx: UPDATE bank_account SET balance = -11 WHERE id = 'X'; 29 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 35 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 41 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 47 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 49 step s3r: SELECT id, balance FROM bank_account WHERE id IN ('X', 'Y') ORDER BY id; [all …]
|
/dports/databases/postgresql10-server/postgresql-10.19/src/test/isolation/expected/ |
H A D | read-only-anomaly-2.out | 4 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 10 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 16 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 22 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 24 step s2wx: UPDATE bank_account SET balance = -11 WHERE id = 'X'; 29 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 35 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 41 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 47 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 49 step s3r: SELECT id, balance FROM bank_account WHERE id IN ('X', 'Y') ORDER BY id; [all …]
|
/dports/databases/postgresql12-client/postgresql-12.9/src/test/isolation/expected/ |
H A D | read-only-anomaly-2.out | 4 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 10 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 16 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 22 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 24 step s2wx: UPDATE bank_account SET balance = -11 WHERE id = 'X'; 29 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 35 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 41 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 47 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 49 step s3r: SELECT id, balance FROM bank_account WHERE id IN ('X', 'Y') ORDER BY id; [all …]
|
H A D | serializable-parallel.out | 4 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 10 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 16 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 22 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 24 step s2wx: UPDATE bank_account SET balance = -11 WHERE id = 'X'; 29 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 35 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 41 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 47 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 49 step s3r: SELECT id, balance FROM bank_account WHERE id IN ('X', 'Y') ORDER BY id; [all …]
|
/dports/databases/postgresql11-server/postgresql-11.14/src/test/isolation/expected/ |
H A D | read-only-anomaly-2.out | 4 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 10 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 16 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 22 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 24 step s2wx: UPDATE bank_account SET balance = -11 WHERE id = 'X'; 29 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 35 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 41 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 47 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 49 step s3r: SELECT id, balance FROM bank_account WHERE id IN ('X', 'Y') ORDER BY id; [all …]
|
/dports/databases/postgresql11-plpython/postgresql-11.14/src/test/isolation/expected/ |
H A D | read-only-anomaly-2.out | 4 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 10 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 16 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 22 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 24 step s2wx: UPDATE bank_account SET balance = -11 WHERE id = 'X'; 29 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 35 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 41 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 47 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 49 step s3r: SELECT id, balance FROM bank_account WHERE id IN ('X', 'Y') ORDER BY id; [all …]
|
/dports/databases/postgresql14-pltcl/postgresql-14.1/src/test/isolation/expected/ |
H A D | read-only-anomaly-2.out | 4 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 10 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 16 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 22 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 24 step s2wx: UPDATE bank_account SET balance = -11 WHERE id = 'X'; 29 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 35 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 41 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 47 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 49 step s3r: SELECT id, balance FROM bank_account WHERE id IN ('X', 'Y') ORDER BY id; [all …]
|
H A D | serializable-parallel.out | 4 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 10 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 16 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 22 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 24 step s2wx: UPDATE bank_account SET balance = -11 WHERE id = 'X'; 29 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 35 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 41 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 47 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 49 step s3r: SELECT id, balance FROM bank_account WHERE id IN ('X', 'Y') ORDER BY id; [all …]
|
/dports/databases/postgresql14-server/postgresql-14.1/src/test/isolation/expected/ |
H A D | read-only-anomaly-2.out | 4 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 10 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 16 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 22 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 24 step s2wx: UPDATE bank_account SET balance = -11 WHERE id = 'X'; 29 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 35 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 41 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 47 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 49 step s3r: SELECT id, balance FROM bank_account WHERE id IN ('X', 'Y') ORDER BY id; [all …]
|
H A D | serializable-parallel.out | 4 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 10 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 16 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 22 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 24 step s2wx: UPDATE bank_account SET balance = -11 WHERE id = 'X'; 29 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 35 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 41 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 47 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 49 step s3r: SELECT id, balance FROM bank_account WHERE id IN ('X', 'Y') ORDER BY id; [all …]
|
/dports/databases/postgresql14-plperl/postgresql-14.1/src/test/isolation/expected/ |
H A D | serializable-parallel.out | 4 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 10 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 16 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 22 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 24 step s2wx: UPDATE bank_account SET balance = -11 WHERE id = 'X'; 29 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 35 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 41 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 47 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 49 step s3r: SELECT id, balance FROM bank_account WHERE id IN ('X', 'Y') ORDER BY id; [all …]
|
/dports/databases/postgresql14-plpython/postgresql-14.1/src/test/isolation/expected/ |
H A D | read-only-anomaly-2.out | 4 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 10 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 16 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 22 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 24 step s2wx: UPDATE bank_account SET balance = -11 WHERE id = 'X'; 29 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 35 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 41 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 47 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 49 step s3r: SELECT id, balance FROM bank_account WHERE id IN ('X', 'Y') ORDER BY id; [all …]
|
H A D | serializable-parallel.out | 4 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 10 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 16 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 22 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 24 step s2wx: UPDATE bank_account SET balance = -11 WHERE id = 'X'; 29 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 35 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 41 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 47 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 49 step s3r: SELECT id, balance FROM bank_account WHERE id IN ('X', 'Y') ORDER BY id; [all …]
|
/dports/databases/postgresql14-docs/postgresql-14.1/src/test/isolation/expected/ |
H A D | read-only-anomaly-2.out | 4 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 10 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 16 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 22 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 24 step s2wx: UPDATE bank_account SET balance = -11 WHERE id = 'X'; 29 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 35 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 41 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 47 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 49 step s3r: SELECT id, balance FROM bank_account WHERE id IN ('X', 'Y') ORDER BY id; [all …]
|
H A D | serializable-parallel.out | 4 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 10 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 16 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 22 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 24 step s2wx: UPDATE bank_account SET balance = -11 WHERE id = 'X'; 29 step s2rx: SELECT balance FROM bank_account WHERE id = 'X'; 35 step s2ry: SELECT balance FROM bank_account WHERE id = 'Y'; 41 step s1ry: SELECT balance FROM bank_account WHERE id = 'Y'; 47 step s1wy: UPDATE bank_account SET balance = 20 WHERE id = 'Y'; 49 step s3r: SELECT id, balance FROM bank_account WHERE id IN ('X', 'Y') ORDER BY id; [all …]
|