#### db_type: oracle #### #### test_type: dda_full_write_skew_committed #### #### 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 ----------wat_dda_full_write_skew_committed test prepare---------- Q0-T1 execute sql: 'DROP TABLE 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);' Q0-T1 execute opt: 'COMMIT;' ----------wat_dda_full_write_skew_committed test run---------- Q1-T1 execute opt: 'BEGIN;' Q1 finished at: 2022-5-20 15:16:15:618:533 Q2-T1 execute sql: 'UPDATE t1 SET v=1 WHERE k=0;' Q2 finished at: 2022-5-20 15:16:15:622:503 Q3-T2 execute opt: 'BEGIN;' Q3 finished at: 2022-5-20 15:16:15:718:456 Q4-T2 execute sql: 'UPDATE t1 SET v=2 WHERE k=1;' Q4 finished at: 2022-5-20 15:16:15:721:839 Q5-T2 execute sql: 'UPDATE t1 SET v=2 WHERE k=0;' Q7-T1 execute sql: 'UPDATE t1 SET v=1 WHERE k=1;' Q5 failed reason: [Oracle][ODBC][Ora]ORA-00060: deadlock detected while waiting for resource errcode: HY000 Q5 failed at: 2022-5-20 15:16:19:530:552 Q7 failed reason: [Oracle][ODBC][Ora]ORA-01013: user requested cancel of current operation errcode: HYT00 Q7 failed at: 2022-5-20 15:16:28:948:801 Test Result: Rollback Reason: [Oracle][ODBC][Ora]ORA-00060: deadlock detected while waiting for resource