| 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; |