Debian Codegraph @

mysql-test/suite/ndb/r/ndb_transaction_max_size.result

raw
1 create table t (
2 x int not null,
3 y int not null,
4 primary key (x),
5 unique key (y)
6 ) engine=ndb;
7 insert into t values (16, 16);
8 insert into t values (15, 15);
9 insert into t values (14, 14);
10 insert into t values (13, 13);
11 insert into t values (12, 12);
12 insert into t values (11, 11);
13 insert into t values (10, 10);
14 insert into t values (9, 9);
15 insert into t values (8, 8);
16 insert into t values (7, 7);
17 insert into t values (6, 6);
18 insert into t values (5, 5);
19 insert into t values (4, 4);
20 insert into t values (3, 3);
21 insert into t values (2, 2);
22 insert into t values (1, 1);
23 start transaction;
24 insert into t values (1000, 1000);
25 insert into t select 1000+x, 1000+y from t;
26 Warnings:
27 Warning 1296 Got error 261 'DML count in transaction exceeds config parameter MaxDMLOperationsPerTransaction/MaxNoOfConcurrentOp' from NDB
28 commit;
29 ERROR HY000: Got error 125 - 'Transaction has been rolled back' during COMMIT
30 drop table t;
31 create table t2 (
32 x int not null,
33 y int not null,
34 primary key (x),
35 unique key (y)
36 ) engine=ndb;
37 start transaction;
38 insert into t2 values (1001, 1001);
39 insert into t2 values (1002, 1002);
40 insert into t2 values (1003, 1003);
41 insert into t2 values (1004, 1004);
42 insert into t2 values (1005, 1005);
43 insert into t2 values (1006, 1006);
44 insert into t2 values (1007, 1007);
45 insert into t2 values (1008, 1008);
46 insert into t2 values (1009, 1009);
47 insert into t2 values (1010, 1010);
48 insert into t2 values (1011, 1011);
49 insert into t2 values (1012, 1012);
50 insert into t2 values (1013, 1013);
51 insert into t2 values (1014, 1014);
52 insert into t2 values (1015, 1015);
53 insert into t2 values (1016, 1016);
54 delete from t2 order by x limit 5;
55 show warnings;
56 Level Code Message
57 Warning 1296 Got error 261 'DML count in transaction exceeds config parameter MaxDMLOperationsPerTransaction/MaxNoOfConcurrentOp' from NDB
58 Error 1296 Got error 261 'DML count in transaction exceeds config parameter MaxDMLOperationsPerTransaction/MaxNoOfConcurrentOp' from NDBCLUSTER
59 Error 1622 Storage engine NDB does not support rollback for this statement. Transaction rolled back and must be restarted
60 rollback;
61 show warnings;
62 Level Code Message
63 drop table t2;