Debian Codegraph @

mysql-test/suite/ndb/t/ndb_backup_print.test

raw
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