Debian Codegraph @

mysql-test/suite/innodb/r/xa_prepare_unlock_unmodified.result

raw
1 SET @old_innodb_enable_xap_unlock_unmodified_for_primary_debug=
2 @@GLOBAL.innodb_enable_xap_unlock_unmodified_for_primary_debug;
3 SET GLOBAL innodb_enable_xap_unlock_unmodified_for_primary_debug= 1;
4 BEGIN NOT ATOMIC
5 DECLARE c TEXT DEFAULT(
6 SELECT CONCAT(
7 'CREATE TABLE t1(pk',
8 GROUP_CONCAT(seq SEPARATOR ' INT, pk'), ' INT, a',
9 GROUP_CONCAT(seq SEPARATOR ' INT, a'), ' INT, b',
10 GROUP_CONCAT(seq SEPARATOR ' INT, b'), ' INT, c INT, PRIMARY KEY(pk',
11 GROUP_CONCAT(seq SEPARATOR ', pk'), '), INDEX i1(a',
12 GROUP_CONCAT(seq SEPARATOR ', a'), '), INDEX i2(b',
13 GROUP_CONCAT(seq SEPARATOR ', b'), ')) ENGINE=InnoDB;')
14 FROM seq_1_to_32);
15 EXECUTE IMMEDIATE c;
16 END;
17 $$
18 BEGIN NOT ATOMIC
19 DECLARE c TEXT DEFAULT(
20 SELECT CONCAT(
21 'INSERT INTO t1 VALUES (',
22 GROUP_CONCAT('1' SEPARATOR ','), ',',
23 GROUP_CONCAT('1' SEPARATOR ','), ',',
24 GROUP_CONCAT('1' SEPARATOR ','), ',0), (',
25 GROUP_CONCAT('2' SEPARATOR ','), ',',
26 GROUP_CONCAT('1' SEPARATOR ','), ',',
27 GROUP_CONCAT('2' SEPARATOR ','), ',0), (',
28 GROUP_CONCAT('3' SEPARATOR ','), ',',
29 GROUP_CONCAT('2' SEPARATOR ','), ',',
30 GROUP_CONCAT('1' SEPARATOR ','), ',0), (',
31 GROUP_CONCAT('4' SEPARATOR ','), ',',
32 GROUP_CONCAT('2' SEPARATOR ','), ',',
33 GROUP_CONCAT('2' SEPARATOR ','), ',0);')
34 FROM seq_1_to_32);
35 EXECUTE IMMEDIATE c;
36 END;
37 $$
38 SET @old_timeout= @@GLOBAL.innodb_lock_wait_timeout;
39 SET GLOBAL innodb_lock_wait_timeout= 1;
40 XA START "t1";
41 UPDATE t1 FORCE INDEX (i2) SET c=c+1 WHERE a1=1 AND b1=1;
42 XA END "t1";
43 XA PREPARE "t1";
44 connect con1,localhost,root,,;
45 SELECT a1, b1, c FROM t1 FORCE INDEX (i1) WHERE a1=2 AND b1=1 FOR UPDATE;
46 a1 b1 c
47 2 1 0
48 disconnect con1;
49 connection default;
50 XA COMMIT "t1";
51 SET GLOBAL innodb_enable_xap_unlock_unmodified_for_primary_debug=
52 @old_innodb_enable_xap_unlock_unmodified_for_primary_debug;
53 SET GLOBAL innodb_lock_wait_timeout= @old_timeout;
54 BEGIN NOT ATOMIC
55 DECLARE c TEXT DEFAULT(
56 SELECT CONCAT(
57 'ALTER TABLE t1 ADD COLUMN d',
58 GROUP_CONCAT(seq SEPARATOR ' INT, ADD COLUMN d'),
59 ' INT, ADD INDEX i3(d',
60 GROUP_CONCAT(seq SEPARATOR ', d'), ');')
61 FROM seq_1_to_33);
62 EXECUTE IMMEDIATE c;
63 END;
64 $$
65 ERROR 42000: Too many key parts specified; max 32 parts allowed
66 DROP TABLE t1;