3 Comparing results from 2 queries (unless we deadlock or some such)...
4 *** Query 1: SELECT * FROM t1 WHERE `pk` > 1000 ORDER BY `int1_key`
5 *** Disabling query log (we may deadlock and not do this after all)
6 *** Creating temp table with results from query 'SELECT * FROM t1 WHERE `pk` > 1000 ORDER BY `int1_key`' unless we deadlock or time out.
12 *** Query 2: SELECT * FROM t1 WHERE `pk` > 1000 ORDER BY `int1_key` LIMIT 987654321
13 *** Disabling query log (we may deadlock and not do this after all)
14 *** Creating temp table with results from query 'SELECT * FROM t1 WHERE `pk` > 1000 ORDER BY `int1_key` LIMIT 987654321' unless we deadlock or time out.
15 *** Enabling query log
16 *** Filler: Do something other than sleep while waiting for other transactions to do stuff...
17 CREATE TEMPORARY TABLE tmpSelectLimitNoLimit (a INT, b VARCHAR(255), c TIMESTAMP, KEY(a));
18 INSERT INTO tmpSelectLimitNoLimit VALUES
19 (-1, 'This is a filler', NOW()),
20 (0, 'More stuff', NOW()),
21 (999999999, 'Even more bogus data', NOW()),
22 (-98765, 'Even more bogus data', NOW());
23 SELECT * FROM tmpSelectLimitNoLimit WHERE a < -99999999 ORDER BY a;
25 *** Query 3: SELECT * FROM t1 WHERE `pk` > 1000 ORDER BY `int1_key` LIMIT 987654321
26 *** Disabling query log (we may deadlock and not do this after all)
27 *** Creating temp table with results from query 'SELECT * FROM t1 WHERE `pk` > 1000 ORDER BY `int1_key` LIMIT 987654321' unless we deadlock or time out.
28 *** Enabling query log
30 UPDATE tmpSelectLimitNoLimit SET a = 3;
34 *** Query 4: SELECT * FROM t1 WHERE `pk` > 1000 ORDER BY `int1_key`
35 *** Disabling query log (we may deadlock and not do this after all)
36 *** Creating temp table with results from query 'SELECT * FROM t1 WHERE `pk` > 1000 ORDER BY `int1_key`' unless we deadlock or time out.
37 *** Enabling query log
38 ***************************************************************************
39 * Checking REPEATABLE READ by comparing result sets from same transaction
40 ***************************************************************************
41 *** Query log disabled. See include files used by test for query details.
42 *** Comparing query 1 (A) with query 2 (B):
43 ###########################
44 # Detect missing rows:
45 ###########################
46 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
48 ###########################
49 # Detect changed rows:
50 ###########################
51 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
52 *** Comparing query 2 (A) with query 3 (B):
53 ###########################
54 # Detect missing rows:
55 ###########################
56 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
58 ###########################
59 # Detect changed rows:
60 ###########################
61 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
62 *** Comparing query 3 (A) with query 4 (B):
63 ###########################
64 # Detect missing rows:
65 ###########################
66 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
68 ###########################
69 # Detect changed rows:
70 ###########################
71 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