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;