| 1 |
-- source include/have_ndb.inc |
| 2 |
-- source suite/ndb/include/backup_restore_setup.inc |
| 3 |
|
| 4 |
echo Start first backup; |
| 5 |
--replace_regex /[0-9]+/X/ |
| 6 |
--exec $NDB_MGM -e "start backup" |
| 7 |
|
| 8 |
create table t1 |
| 9 |
(pk int key |
| 10 |
,a1 BIT(1), a2 BIT(5), a3 BIT(33), a4 BIT(63), a5 BIT(64) |
| 11 |
,b1 TINYINT, b2 TINYINT UNSIGNED |
| 12 |
,c1 SMALLINT, c2 SMALLINT UNSIGNED |
| 13 |
,d1 INT, d2 INT UNSIGNED |
| 14 |
,e1 BIGINT, e2 BIGINT UNSIGNED |
| 15 |
,f1 CHAR(1) BINARY, f2 CHAR(32) BINARY, f3 CHAR(255) BINARY |
| 16 |
,g1 VARCHAR(32) BINARY, g2 VARCHAR(255) BINARY, g3 VARCHAR(1000) BINARY |
| 17 |
,h1 BINARY(1), h2 BINARY(8), h3 BINARY(255) |
| 18 |
,i1 VARBINARY(32), i2 VARBINARY(255), i3 VARBINARY(1000) |
| 19 |
) engine ndb; |
| 20 |
|
| 21 |
insert into t1 values |
| 22 |
(1 |
| 23 |
,0x1, 0x17, 0x789a, 0x789abcde, 0xfedc0001 |
| 24 |
,127, 255 |
| 25 |
,32767, 65535 |
| 26 |
,2147483647, 4294967295 |
| 27 |
,9223372036854775807, 18446744073709551615 |
| 28 |
,'1','12345678901234567890123456789012','123456789' |
| 29 |
,'1','12345678901234567890123456789012','123456789' |
| 30 |
,0x12,0x123456789abcdef0, 0x012345 |
| 31 |
,0x12,0x123456789abcdef0, 0x00123450 |
| 32 |
); |
| 33 |
|
| 34 |
insert into t1 values |
| 35 |
(2 |
| 36 |
,0, 0, 0, 0, 0 |
| 37 |
,-128, 0 |
| 38 |
,-32768, 0 |
| 39 |
,-2147483648, 0 |
| 40 |
,-9223372036854775808, 0 |
| 41 |
,'','','' |
| 42 |
,'','','' |
| 43 |
,0x0,0x0,0x0 |
| 44 |
,0x0,0x0,0x0 |
| 45 |
); |
| 46 |
|
| 47 |
insert into t1 values |
| 48 |
(3 |
| 49 |
,NULL,NULL,NULL,NULL,NULL |
| 50 |
,NULL,NULL |
| 51 |
,NULL,NULL |
| 52 |
,NULL,NULL |
| 53 |
,NULL,NULL |
| 54 |
,NULL,NULL,NULL |
| 55 |
,NULL,NULL,NULL |
| 56 |
,NULL,NULL,NULL |
| 57 |
,NULL,NULL,NULL |
| 58 |
); |
| 59 |
|
| 60 |
echo Start second backup; |
| 61 |
--replace_regex /[0-9]+/X/ |
| 62 |
--exec $NDB_MGM -e "start backup" |
| 63 |
|
| 64 |
drop table t1; |
| 65 |
--source suite/ndb/include/backup_restore_cleanup.inc |