SET autocommit = 0; START TRANSACTION; *** Disabling query log (we may deadlock and not do this after all) *** Creating temp table with results from query 'SELECT * from t1' unless we deadlock or time out. *** Enabling query log SELECT SLEEP(1); SLEEP(1) 0 *** Disabling query log (we may deadlock and not do this after all) *** Creating temp table with results from query 'SELECT * from t1' unless we deadlock or time out. *** Enabling query log *************************************************************************** * Checking REPEATABLE READ by comparing result sets from same transaction *************************************************************************** *** Query log disabled. See include files used by test for query details. *** Comparing query 1 (A) with query 2 (B): ########################### # Detect missing rows: ########################### A.pk B.pk A.id B.id A.int1 B.int1 A.int1_key B.int1_key A.int1_unique B.int1_unique A.int2 B.int2 A.int2_key B.int2_key A.int2_unique B.int2_unique A.for_update B.for_update A.timestamp B.timestamp A.connection_id B.connection_id A.thread_id B.thread_id A.is_uncommitted B.is_uncommitted A.is_consistent B.is_consistent ########################### # Detect changed rows: ########################### A.pk B.pk A.id B.id A.int1 B.int1 A.int1_key B.int1_key A.int1_unique B.int1_unique A.int2 B.int2 A.int2_key B.int2_key A.int2_unique B.int2_unique A.for_update B.for_update A.timestamp B.timestamp A.connection_id B.connection_id A.thread_id B.thread_id A.is_uncommitted B.is_uncommitted A.is_consistent B.is_consistent COMMIT;
Name | Type | Size | Permission | Actions |
---|---|---|---|---|
init_innodb.result | File | 2.12 KB | 0644 |
|
rr_c_count_not_zero.result | File | 264 B | 0644 |
|
rr_c_stats.result | File | 38 B | 0644 |
|
rr_i_40-44.result | File | 2.12 KB | 0644 |
|
rr_id_3.result | File | 147 B | 0644 |
|
rr_id_900.result | File | 1 KB | 0644 |
|
rr_insert_select_2.result | File | 745 B | 0644 |
|
rr_iud_rollback-multi-50.result | File | 555 B | 0644 |
|
rr_replace_7-8.result | File | 1.08 KB | 0644 |
|
rr_s_select-uncommitted.result | File | 224 B | 0644 |
|
rr_sc_select-limit-nolimit_4.result | File | 4.65 KB | 0644 |
|
rr_sc_select-same_2.result | File | 1.56 KB | 0644 |
|
rr_sc_sum_total.result | File | 141 B | 0644 |
|
rr_u_10-19.result | File | 5.52 KB | 0644 |
|
rr_u_10-19_nolimit.result | File | 5.48 KB | 0644 |
|
rr_u_4.result | File | 333 B | 0644 |
|