Debian Codegraph @

mysql-test/suite/engines/rr_trx/r/rr_sc_select-same_2.result

raw
1 SET autocommit = 0;
2 START TRANSACTION;
3 *** Disabling query log (we may deadlock and not do this after all)
4 *** Creating temp table with results from query 'SELECT * from t1' unless we deadlock or time out.
5 *** Enabling query log
6 SELECT SLEEP(1);
7 SLEEP(1)
8 0
9 *** Disabling query log (we may deadlock and not do this after all)
10 *** Creating temp table with results from query 'SELECT * from t1' unless we deadlock or time out.
11 *** Enabling query log
12 ***************************************************************************
13 * Checking REPEATABLE READ by comparing result sets from same transaction
14 ***************************************************************************
15 *** Query log disabled. See include files used by test for query details.
16 *** Comparing query 1 (A) with query 2 (B):
17 ###########################
18 # Detect missing rows:
19 ###########################
20 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
21
22 ###########################
23 # Detect changed rows:
24 ###########################
25 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
26 COMMIT;