Debian Codegraph @

mysql-test/suite/engines/rr_trx/r/rr_sc_select-limit-nolimit_4.result

raw
1 SET autocommit = 0;
2 START TRANSACTION;
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.
7 *** Enabling query log
8 *** Filler:
9 SELECT SLEEP(1);
10 SLEEP(1)
11 0
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;
24 a b c
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
29 *** Filler:
30 UPDATE tmpSelectLimitNoLimit SET a = 3;
31 SELECT SLEEP(1);
32 SLEEP(1)
33 0
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
47
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
57
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
67
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
72 COMMIT;