Skip to content

Instantly share code, notes, and snippets.

@yfuruyama

yfuruyama/spanner_phantom_read_ro.txt

Created December 2, 2018 08:38
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save yfuruyama/3ac84e0c5d2a3a7a02cf8738b24e35ca to your computer and use it in GitHub Desktop.
Save yfuruyama/3ac84e0c5d2a3a7a02cf8738b24e35ca to your computer and use it in GitHub Desktop.
Download ZIP
Raw
spanner_phantom_read_ro.txt
+---------------------------------------------------------------------+-------------------------------------------------------------------------------------+
| tx1 | tx2 |
+---------------------------------------------------------------------+-------------------------------------------------------------------------------------+
| spanner> BEGIN RO; | |
| Query OK, 0 rows affected (0.00 sec) | |
| | |
| | spanner> BEGIN; |
| | Query OK, 0 rows affected (4.12 sec) |
| | |
| spanner> SELECT * FROM Accounts WHERE UserId >= 1 AND UserId <= 10; | |
| +--------+---------+----------+ | |
| | UserId | Balance | Type | | |
| +--------+---------+----------+ | |
| | 1 | 1000 | Checking | | |
| | 2 | 1000 | Checking | | |
| | 3 | 1000 | Checking | | |
| +--------+---------+----------+ | |
| 3 rows in set (3.34 msecs) | |
| | |
| | spanner> INSERT INTO Accounts (UserId, Balance, Type) VALUES (4, 1000, 'Checking'); |
| | Query OK, 1 rows affected (0.83 sec) |
| | |
| | spanner> COMMIT; |
| | Query OK, 0 rows affected (0.25 sec) |
| | |
| spanner> SELECT * FROM Accounts WHERE UserId >= 1 AND UserId <= 10; | |
| +--------+---------+----------+ | |
| | UserId | Balance | Type | | |
| +--------+---------+----------+ | |
| | 1 | 1000 | Checking | | |
| | 2 | 1000 | Checking | | |
| | 3 | 1000 | Checking | | |
| +--------+---------+----------+ | |
| 3 rows in set (35.66 msecs) | |
| | |
| spanner> CLOSE; | |
| Query OK, 0 rows affected (0.00 sec) | |
| | |
+---------------------------------------------------------------------+-------------------------------------------------------------------------------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment