Debian Codegraph @

mysql-test/suite/ndb_rpl/r/ndb_rpl_blob.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 create table t1 (
7 a int not null primary key,
8 b text not null
9 ) engine=ndb;
10 insert into t1 values(1, repeat('abc',10));
11 insert into t1 values(2, repeat('def',200));
12 insert into t1 values(3, repeat('ghi',3000));
13 select 'M', a, sha1(b) from t1
14 order by a;
15 M a sha1(b)
16 M 1 8a6c4cf7cf97e66c487c3e3b717e9ae13623d07d
17 M 2 0ccd08c0fa6ad6a4382b27b1d36586d6ceb4fffa
18 M 3 75e7b3299e0b776aeac2a4d1542d5b3c0ba2e05e
19 select 'S', a, sha1(b) from t1
20 order by a;
21 S a sha1(b)
22 S 1 8a6c4cf7cf97e66c487c3e3b717e9ae13623d07d
23 S 2 0ccd08c0fa6ad6a4382b27b1d36586d6ceb4fffa
24 S 3 75e7b3299e0b776aeac2a4d1542d5b3c0ba2e05e
25 update t1 set b = repeat('xyz',3000) where a = 1;
26 delete from t1 where a = 2;
27 update t1 set b = concat(b,'xyz') where a = 3;
28 select 'M', a, sha1(b) from t1
29 order by a;
30 M a sha1(b)
31 M 1 00fb68a43c526c2b7e3466ddcf2b3e39277d0fe1
32 M 3 e731e68ab2482967619b62a69a5d03dfcbb9ce16
33 select 'S', a, sha1(b) from t1
34 order by a;
35 S a sha1(b)
36 S 1 00fb68a43c526c2b7e3466ddcf2b3e39277d0fe1
37 S 3 e731e68ab2482967619b62a69a5d03dfcbb9ce16
38 drop table t1;
39 create table t1 (
40 a int not null primary key,
41 b text not null,
42 c int,
43 d longblob,
44 e tinyblob
45 ) engine=ndbcluster;
46 insert into t1 values (
47 0, repeat(@s2,454), 100, repeat(@s2,345), NULL);
48 insert into t1 values (
49 1, repeat(@s0,504), NULL, repeat(@s1,732), repeat(@s1,1));
50 insert into t1 values (
51 2, '', 102, '', repeat(@s2,1));
52 insert into t1 values (
53 3, repeat(@s0,545), 103, repeat(@s2,788), repeat(@s0,1));
54 insert into t1 values (
55 4, repeat(@s1,38), 104, repeat(@s0,260), repeat(@s0,1));
56 insert into t1 values (
57 5, repeat(@s2,12), 105, repeat(@s2,40), repeat(@s1,1));
58 insert into t1 values (
59 6, repeat(@s1,242), 106, NULL, repeat(@s1,1));
60 insert into t1 values (
61 7, repeat(@s1,30), 107, repeat(@s0,161), '');
62 insert into t1 values (
63 8, repeat(@s1,719), 108, repeat(@s2,104), NULL);
64 insert into t1 values (
65 9, repeat(@s2,427), NULL, NULL, NULL);
66 select 'M', a, sha1(b), c, sha1(d), sha1(e)
67 from t1 order by a;
68 M a sha1(b) c sha1(d) sha1(e)
69 M 0 9538f61e649383c0d1054de2a2f0171188129f33 100 2b6515f29c20b8e9e17cc597527e516c0de8d612 NULL
70 M 1 dcb9a12ca86e718ff2564be041b7c1b3ff5ea559 NULL f23e7439d9a73c3954979b85a7ef6ef35faf4e9d abfe8ae5212b22d023aa6de84beeb1344ac5668a
71 M 2 da39a3ee5e6b4b0d3255bfef95601890afd80709 102 da39a3ee5e6b4b0d3255bfef95601890afd80709 33deebe47470a40e960834bffa4cdc66790845a6
72 M 3 ec8e06d9ac4695d6a898b519ba840590263a9bff 103 278629ad080c3c4377978c006c2e54d0992e43cc 700915801f853603510aeb67b331866d996fdbda
73 M 4 0392fa8c425d293c79291f0f34779d1101d13fcb 104 5084b602c7203e0e9590a163415ac605da17ac32 700915801f853603510aeb67b331866d996fdbda
74 M 5 0f9653f0c7a69cd1c617792d546582e974a7a24d 105 566588a04ff26d05160d61c83435292bfda2978e abfe8ae5212b22d023aa6de84beeb1344ac5668a
75 M 6 a37e8b0ff4fc13a42be02cdecb36186436959bae 106 NULL abfe8ae5212b22d023aa6de84beeb1344ac5668a
76 M 7 a6bae0cfe6b45ff8c3c12d2ce577a1cd3931190f 107 39ee712b4b9e47f2cf3ba7c9790b2bf0d8f378e8 da39a3ee5e6b4b0d3255bfef95601890afd80709
77 M 8 e139adcb7b2974ee7ff227fd405709e5cb7c896c 108 ba8073b0e1a281d4111bd2d82c7722b01574c00b NULL
78 M 9 1fc5168fe4be566b17b658d94e7813f0b5032cdb NULL NULL NULL
79 select 'S', a, sha1(b), c, sha1(d), sha1(e)
80 from t1 order by a;
81 S a sha1(b) c sha1(d) sha1(e)
82 S 0 9538f61e649383c0d1054de2a2f0171188129f33 100 2b6515f29c20b8e9e17cc597527e516c0de8d612 NULL
83 S 1 dcb9a12ca86e718ff2564be041b7c1b3ff5ea559 NULL f23e7439d9a73c3954979b85a7ef6ef35faf4e9d abfe8ae5212b22d023aa6de84beeb1344ac5668a
84 S 2 da39a3ee5e6b4b0d3255bfef95601890afd80709 102 da39a3ee5e6b4b0d3255bfef95601890afd80709 33deebe47470a40e960834bffa4cdc66790845a6
85 S 3 ec8e06d9ac4695d6a898b519ba840590263a9bff 103 278629ad080c3c4377978c006c2e54d0992e43cc 700915801f853603510aeb67b331866d996fdbda
86 S 4 0392fa8c425d293c79291f0f34779d1101d13fcb 104 5084b602c7203e0e9590a163415ac605da17ac32 700915801f853603510aeb67b331866d996fdbda
87 S 5 0f9653f0c7a69cd1c617792d546582e974a7a24d 105 566588a04ff26d05160d61c83435292bfda2978e abfe8ae5212b22d023aa6de84beeb1344ac5668a
88 S 6 a37e8b0ff4fc13a42be02cdecb36186436959bae 106 NULL abfe8ae5212b22d023aa6de84beeb1344ac5668a
89 S 7 a6bae0cfe6b45ff8c3c12d2ce577a1cd3931190f 107 39ee712b4b9e47f2cf3ba7c9790b2bf0d8f378e8 da39a3ee5e6b4b0d3255bfef95601890afd80709
90 S 8 e139adcb7b2974ee7ff227fd405709e5cb7c896c 108 ba8073b0e1a281d4111bd2d82c7722b01574c00b NULL
91 S 9 1fc5168fe4be566b17b658d94e7813f0b5032cdb NULL NULL NULL
92 drop table t1;
93 CREATE TABLE IF NOT EXISTS t1 (
94 db VARBINARY(63) NOT NULL,
95 name VARBINARY(63) NOT NULL,
96 slock BINARY(32) NOT NULL,
97 query BLOB NOT NULL,
98 node_id INT UNSIGNED NOT NULL,
99 epoch BIGINT UNSIGNED NOT NULL,
100 id INT UNSIGNED NOT NULL,
101 version INT UNSIGNED NOT NULL,
102 type INT UNSIGNED NOT NULL,
103 PRIMARY KEY USING HASH (db,name))
104 ENGINE=NDB;
105 insert into t1 values ('test','t1',
106 'abc',repeat(@s0,10), 11,12,13,14,15);
107 insert into t1 values ('test','t2',
108 'def',repeat(@s1,100), 21,22,23,24,25);
109 insert into t1 values ('test','t3',
110 'ghi',repeat(@s2,1000),31,32,33,34,35);
111 insert into t1 values ('testtttttttttt','t1',
112 'abc',repeat(@s0,10), 11,12,13,14,15);
113 insert into t1 values ('testttttttttttt','t1',
114 'def',repeat(@s1,100), 21,22,23,24,25);
115 insert into t1 values ('testtttttttttttt','t1',
116 'ghi',repeat(@s2,1000),31,32,33,34,35);
117 insert into t1 values ('t','t11111111111',
118 'abc',repeat(@s0,10), 11,12,13,14,15);
119 insert into t1 values ('t','t111111111111',
120 'def',repeat(@s1,100), 21,22,23,24,25);
121 insert into t1 values ('t','t1111111111111',
122 'ghi',repeat(@s2,1000),31,32,33,34,35);
123 select 'M', db, name, sha1(query), node_id, epoch, id, version, type
124 from t1 order by db, name;
125 M db name sha1(query) node_id epoch id version type
126 M t t11111111111 8fc937d303ee7e4795c0b964d4066cedd6d74cfd 11 12 13 14 15
127 M t t111111111111 a5229e9f8977bc99afc3b3627c56f083e97e01bd 21 22 23 24 25
128 M t t1111111111111 0820e6ad3eeb06ea60e5e04d0bfe36f286b91098 31 32 33 34 35
129 M test t1 8fc937d303ee7e4795c0b964d4066cedd6d74cfd 11 12 13 14 15
130 M test t2 a5229e9f8977bc99afc3b3627c56f083e97e01bd 21 22 23 24 25
131 M test t3 0820e6ad3eeb06ea60e5e04d0bfe36f286b91098 31 32 33 34 35
132 M testtttttttttt t1 8fc937d303ee7e4795c0b964d4066cedd6d74cfd 11 12 13 14 15
133 M testttttttttttt t1 a5229e9f8977bc99afc3b3627c56f083e97e01bd 21 22 23 24 25
134 M testtttttttttttt t1 0820e6ad3eeb06ea60e5e04d0bfe36f286b91098 31 32 33 34 35
135 select 'S', db, name, sha1(query), node_id, epoch, id, version, type
136 from t1 order by db, name;
137 S db name sha1(query) node_id epoch id version type
138 S t t11111111111 8fc937d303ee7e4795c0b964d4066cedd6d74cfd 11 12 13 14 15
139 S t t111111111111 a5229e9f8977bc99afc3b3627c56f083e97e01bd 21 22 23 24 25
140 S t t1111111111111 0820e6ad3eeb06ea60e5e04d0bfe36f286b91098 31 32 33 34 35
141 S test t1 8fc937d303ee7e4795c0b964d4066cedd6d74cfd 11 12 13 14 15
142 S test t2 a5229e9f8977bc99afc3b3627c56f083e97e01bd 21 22 23 24 25
143 S test t3 0820e6ad3eeb06ea60e5e04d0bfe36f286b91098 31 32 33 34 35
144 S testtttttttttt t1 8fc937d303ee7e4795c0b964d4066cedd6d74cfd 11 12 13 14 15
145 S testttttttttttt t1 a5229e9f8977bc99afc3b3627c56f083e97e01bd 21 22 23 24 25
146 S testtttttttttttt t1 0820e6ad3eeb06ea60e5e04d0bfe36f286b91098 31 32 33 34 35
147 drop table t1;
148 include/rpl_end.inc