1 include/master-slave.inc
4 a int not null primary key,
7 insert into t1 values(1, repeat('abc',10));
8 insert into t1 values(2, repeat('def',200));
9 insert into t1 values(3, repeat('ghi',3000));
10 select 'M', a, sha1(b) from t1
13 M 1 8a6c4cf7cf97e66c487c3e3b717e9ae13623d07d
14 M 2 0ccd08c0fa6ad6a4382b27b1d36586d6ceb4fffa
15 M 3 75e7b3299e0b776aeac2a4d1542d5b3c0ba2e05e
16 select 'S', a, sha1(b) from t1
19 S 1 8a6c4cf7cf97e66c487c3e3b717e9ae13623d07d
20 S 2 0ccd08c0fa6ad6a4382b27b1d36586d6ceb4fffa
21 S 3 75e7b3299e0b776aeac2a4d1542d5b3c0ba2e05e
24 a int not null primary key,
30 insert into t1 values (
31 0, repeat(@s2,454), 100, repeat(@s2,345), NULL);
32 insert into t1 values (
33 1, repeat(@s0,504), NULL, repeat(@s1,732), repeat(@s1,1));
34 insert into t1 values (
35 2, '', 102, '', repeat(@s2,1));
36 insert into t1 values (
37 3, repeat(@s0,545), 103, repeat(@s2,788), repeat(@s0,1));
38 insert into t1 values (
39 4, repeat(@s1,38), 104, repeat(@s0,260), repeat(@s0,1));
40 insert into t1 values (
41 5, repeat(@s2,12), 105, repeat(@s2,40), repeat(@s1,1));
42 insert into t1 values (
43 6, repeat(@s1,242), 106, NULL, repeat(@s1,1));
44 insert into t1 values (
45 7, repeat(@s1,30), 107, repeat(@s0,161), '');
46 insert into t1 values (
47 8, repeat(@s1,719), 108, repeat(@s2,104), NULL);
48 insert into t1 values (
49 9, repeat(@s2,427), NULL, NULL, NULL);
50 select 'M', a, sha1(b), c, sha1(d), sha1(e)
52 M a sha1(b) c sha1(d) sha1(e)
53 M 0 9538f61e649383c0d1054de2a2f0171188129f33 100 2b6515f29c20b8e9e17cc597527e516c0de8d612 NULL
54 M 1 dcb9a12ca86e718ff2564be041b7c1b3ff5ea559 NULL f23e7439d9a73c3954979b85a7ef6ef35faf4e9d abfe8ae5212b22d023aa6de84beeb1344ac5668a
55 M 2 da39a3ee5e6b4b0d3255bfef95601890afd80709 102 da39a3ee5e6b4b0d3255bfef95601890afd80709 33deebe47470a40e960834bffa4cdc66790845a6
56 M 3 ec8e06d9ac4695d6a898b519ba840590263a9bff 103 278629ad080c3c4377978c006c2e54d0992e43cc 700915801f853603510aeb67b331866d996fdbda
57 M 4 0392fa8c425d293c79291f0f34779d1101d13fcb 104 5084b602c7203e0e9590a163415ac605da17ac32 700915801f853603510aeb67b331866d996fdbda
58 M 5 0f9653f0c7a69cd1c617792d546582e974a7a24d 105 566588a04ff26d05160d61c83435292bfda2978e abfe8ae5212b22d023aa6de84beeb1344ac5668a
59 M 6 a37e8b0ff4fc13a42be02cdecb36186436959bae 106 NULL abfe8ae5212b22d023aa6de84beeb1344ac5668a
60 M 7 a6bae0cfe6b45ff8c3c12d2ce577a1cd3931190f 107 39ee712b4b9e47f2cf3ba7c9790b2bf0d8f378e8 da39a3ee5e6b4b0d3255bfef95601890afd80709
61 M 8 e139adcb7b2974ee7ff227fd405709e5cb7c896c 108 ba8073b0e1a281d4111bd2d82c7722b01574c00b NULL
62 M 9 1fc5168fe4be566b17b658d94e7813f0b5032cdb NULL NULL NULL
63 select 'S', a, sha1(b), c, sha1(d), sha1(e)
65 S a sha1(b) c sha1(d) sha1(e)
66 S 0 9538f61e649383c0d1054de2a2f0171188129f33 100 2b6515f29c20b8e9e17cc597527e516c0de8d612 NULL
67 S 1 dcb9a12ca86e718ff2564be041b7c1b3ff5ea559 NULL f23e7439d9a73c3954979b85a7ef6ef35faf4e9d abfe8ae5212b22d023aa6de84beeb1344ac5668a
68 S 2 da39a3ee5e6b4b0d3255bfef95601890afd80709 102 da39a3ee5e6b4b0d3255bfef95601890afd80709 33deebe47470a40e960834bffa4cdc66790845a6
69 S 3 ec8e06d9ac4695d6a898b519ba840590263a9bff 103 278629ad080c3c4377978c006c2e54d0992e43cc 700915801f853603510aeb67b331866d996fdbda
70 S 4 0392fa8c425d293c79291f0f34779d1101d13fcb 104 5084b602c7203e0e9590a163415ac605da17ac32 700915801f853603510aeb67b331866d996fdbda
71 S 5 0f9653f0c7a69cd1c617792d546582e974a7a24d 105 566588a04ff26d05160d61c83435292bfda2978e abfe8ae5212b22d023aa6de84beeb1344ac5668a
72 S 6 a37e8b0ff4fc13a42be02cdecb36186436959bae 106 NULL abfe8ae5212b22d023aa6de84beeb1344ac5668a
73 S 7 a6bae0cfe6b45ff8c3c12d2ce577a1cd3931190f 107 39ee712b4b9e47f2cf3ba7c9790b2bf0d8f378e8 da39a3ee5e6b4b0d3255bfef95601890afd80709
74 S 8 e139adcb7b2974ee7ff227fd405709e5cb7c896c 108 ba8073b0e1a281d4111bd2d82c7722b01574c00b NULL
75 S 9 1fc5168fe4be566b17b658d94e7813f0b5032cdb NULL NULL NULL
77 CREATE TABLE IF NOT EXISTS t1 (
78 db VARBINARY(63) NOT NULL,
79 name VARBINARY(63) NOT NULL,
80 slock BINARY(32) NOT NULL,
82 node_id INT UNSIGNED NOT NULL,
83 epoch BIGINT UNSIGNED NOT NULL,
84 id INT UNSIGNED NOT NULL,
85 version INT UNSIGNED NOT NULL,
86 type INT UNSIGNED NOT NULL,
87 PRIMARY KEY USING HASH (db,name))
89 insert into t1 values ('test','t1',
90 'abc',repeat(@s0,10), 11,12,13,14,15);
91 insert into t1 values ('test','t2',
92 'def',repeat(@s1,100), 21,22,23,24,25);
93 insert into t1 values ('test','t3',
94 'ghi',repeat(@s2,1000),31,32,33,34,35);
95 insert into t1 values ('testtttttttttt','t1',
96 'abc',repeat(@s0,10), 11,12,13,14,15);
97 insert into t1 values ('testttttttttttt','t1',
98 'def',repeat(@s1,100), 21,22,23,24,25);
99 insert into t1 values ('testtttttttttttt','t1',
100 'ghi',repeat(@s2,1000),31,32,33,34,35);
101 insert into t1 values ('t','t11111111111',
102 'abc',repeat(@s0,10), 11,12,13,14,15);
103 insert into t1 values ('t','t111111111111',
104 'def',repeat(@s1,100), 21,22,23,24,25);
105 insert into t1 values ('t','t1111111111111',
106 'ghi',repeat(@s2,1000),31,32,33,34,35);
107 select 'M', db, name, sha1(query), node_id, epoch, id, version, type
108 from t1 order by db, name;
109 M db name sha1(query) node_id epoch id version type
110 M t t11111111111 8fc937d303ee7e4795c0b964d4066cedd6d74cfd 11 12 13 14 15
111 M t t111111111111 a5229e9f8977bc99afc3b3627c56f083e97e01bd 21 22 23 24 25
112 M t t1111111111111 0820e6ad3eeb06ea60e5e04d0bfe36f286b91098 31 32 33 34 35
113 M test t1 8fc937d303ee7e4795c0b964d4066cedd6d74cfd 11 12 13 14 15
114 M test t2 a5229e9f8977bc99afc3b3627c56f083e97e01bd 21 22 23 24 25
115 M test t3 0820e6ad3eeb06ea60e5e04d0bfe36f286b91098 31 32 33 34 35
116 M testtttttttttt t1 8fc937d303ee7e4795c0b964d4066cedd6d74cfd 11 12 13 14 15
117 M testttttttttttt t1 a5229e9f8977bc99afc3b3627c56f083e97e01bd 21 22 23 24 25
118 M testtttttttttttt t1 0820e6ad3eeb06ea60e5e04d0bfe36f286b91098 31 32 33 34 35
119 select 'S', db, name, sha1(query), node_id, epoch, id, version, type
120 from t1 order by db, name;
121 S db name sha1(query) node_id epoch id version type
122 S t t11111111111 8fc937d303ee7e4795c0b964d4066cedd6d74cfd 11 12 13 14 15
123 S t t111111111111 a5229e9f8977bc99afc3b3627c56f083e97e01bd 21 22 23 24 25
124 S t t1111111111111 0820e6ad3eeb06ea60e5e04d0bfe36f286b91098 31 32 33 34 35
125 S test t1 8fc937d303ee7e4795c0b964d4066cedd6d74cfd 11 12 13 14 15
126 S test t2 a5229e9f8977bc99afc3b3627c56f083e97e01bd 21 22 23 24 25
127 S test t3 0820e6ad3eeb06ea60e5e04d0bfe36f286b91098 31 32 33 34 35
128 S testtttttttttt t1 8fc937d303ee7e4795c0b964d4066cedd6d74cfd 11 12 13 14 15
129 S testttttttttttt t1 a5229e9f8977bc99afc3b3627c56f083e97e01bd 21 22 23 24 25
130 S testtttttttttttt t1 0820e6ad3eeb06ea60e5e04d0bfe36f286b91098 31 32 33 34 35