#### db_type: tidb #### #### test_type: sda_full_write #### #### isolation: read-committed #### 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 = read-committed for each session ----------wat_sda_full_write 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 opt: 'COMMIT'; ----------wat_sda_full_write test run---------- Q1-T1 execute sql: 'BEGIN OPTIMISTIC;' Q1 finished at: 2022-4-1 17:25:50:592:926 Q2-T1 execute sql: 'UPDATE t1 SET v=1 WHERE k=0;' Q2 finished at: 2022-4-1 17:25:50:594:629 Q3-T2 execute sql: 'BEGIN OPTIMISTIC;' Q3 finished at: 2022-4-1 17:25:50:693:157 Q4-T2 execute sql: 'UPDATE t1 SET v=2 WHERE k=0;' Q4 finished at: 2022-4-1 17:25:50:695:188 Q5-T1 execute sql: 'UPDATE t1 SET v=3 WHERE k=0;' Q5 finished at: 2022-4-1 17:25:50:793:607 Q6-T1 execute opt: 'COMMIT'; Q6 finished at: 2022-4-1 17:25:50:795:52 Q7-T2 execute opt: 'COMMIT'; Q7 failed reason: [MySQL][ODBC 8.0(w) Driver]Write conflict, txnStartTS=432224377423265792, conflictStartTS=432224377396789248, conflictCommitTS=432224377449742336, key={tableID=2613, handle=0} primary=[]byte(nil) [try again later] errcode: HY000 Q7 failed at: 2022-4-1 17:25:51:596:568 Test Result: Rollback [MySQL][ODBC 8.0(w) Driver]Write conflict, txnStartTS=432224377423265792, conflictStartTS=432224377396789248, conflictCommitTS=432224377449742336, key={tableID=2613, handle=0} primary=[]byte(nil) [try again later]