#### db_type: crdb #### #### test_type: dda_read_write_skew1_committed #### #### isolation: serializable #### current_result: The query result of the current SQL statement. Each row of table is separated by a space, and the fields in each row are separated by commas expected_result: The expected result is the expected query result for each SQL that conforms to the serializability theory set TXN_ISOLATION = serializable for each session ----------iat_dda_read_write_skew1_committed test prepare---------- Q0-T1 execute sql: 'DROP TABLE IF EXISTS t1;' Q0-T1 execute sql: 'CREATE TABLE t1 (k INT PRIMARY KEY, v INT);' Q0-T1 execute sql: 'INSERT INTO t1 VALUES (0, 0);' Q0-T1 execute sql: 'INSERT INTO t1 VALUES (1, 0);' ----------iat_dda_read_write_skew1_committed test run---------- Q1-T1 execute sql: 'BEGIN TRANSACTION;' Q1 finished at: 2022-4-2 16:53:7:145:274 Q2-T1 execute sql: 'SELECT * FROM t1 WHERE k=0;' current_result: (0,0) *(1) expected_result: (0,0) (2) expected_result: (0,1) Q2 finished at: 2022-4-2 16:53:7:148:534 Q3-T2 execute sql: 'BEGIN TRANSACTION;' Q3 finished at: 2022-4-2 16:53:7:247:353 Q4-T2 execute sql: 'UPDATE t1 SET v=2 WHERE k=1;' Q4 finished at: 2022-4-2 16:53:7:250:486 Q5-T2 execute sql: 'UPDATE t1 SET v=1 WHERE k=0;' Q5 finished at: 2022-4-2 16:53:7:253:575 Q6-T2 execute sql: 'COMMIT TRANSACTION;' Q6 finished at: 2022-4-2 16:53:7:256:516 Q7-T1 execute sql: 'UPDATE t1 SET v=1 WHERE k=1;' Q7 failed reason: Server error [SQL state: 40001]: restart transaction: TransactionRetryWithProtoRefreshError: WriteTooOldError: write at timestamp 1648889587.144869253,0 too old; wrote at 1648889587.246952816,1 errcode: HY000 Q7 failed at: 2022-4-2 16:53:8:48:989 Test Result: Rollback Reason: Server error [SQL state: 40001]: restart transaction: TransactionRetryWithProtoRefreshError: WriteTooOldError: write at timestamp 1648889587.144869253,0 too old; wrote at 1648889587.246952816,1