| 1 |
create table t1 (a1 int primary key, b1 int) engine ndb; |
| 2 |
create table t2 (a2 int primary key, b2 text) engine ndb; |
| 3 |
insert into t1 values (1,11),(2,22); |
| 4 |
insert into t2 values (1,repeat('x',10000)),(2,repeat('y',20000)); |
| 5 |
select a1,crc32(b2) from t1,t2 where a1=a2 order by a1; |
| 6 |
a1 crc32(b2) |
| 7 |
1 223716515 |
| 8 |
2 715074126 |
| 9 |
# run backup |
| 10 |
drop table t1,t2; |
| 11 |
# error insert 6215 |
| 12 |
# run restore |
| 13 |
# error insert clear |
| 14 |
select a1,crc32(b2) from t1,t2 where a1=a2 order by a1; |
| 15 |
a1 crc32(b2) |
| 16 |
1 223716515 |
| 17 |
2 715074126 |
| 18 |
drop table t1,t2; |