Debian Codegraph @

mysql-test/suite/ndb_rpl/r/ndb_rpl_rowsize14000.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 SET SESSION DEBUG="+d,ndb_crash_on_drop_SUB_TABLE_DATA";
7 CREATE TABLE t (
8 pk01 BINARY(192) NOT NULL,
9 pk02 BINARY(192) NOT NULL DEFAULT 0,
10 pk03 BINARY(192) NOT NULL DEFAULT 0,
11 pk04 BINARY(192) NOT NULL DEFAULT 0,
12 pk05 BINARY(192) NOT NULL DEFAULT 0,
13 pk06 BINARY(192) NOT NULL DEFAULT 0,
14 pk07 BINARY(192) NOT NULL DEFAULT 0,
15 pk08 BINARY(192) NOT NULL DEFAULT 0,
16 pk09 BINARY(192) NOT NULL DEFAULT 0,
17 pk10 BINARY(192) NOT NULL DEFAULT 0,
18 pk11 BINARY(192) NOT NULL DEFAULT 0,
19 pk12 BINARY(192) NOT NULL DEFAULT 0,
20 pk13 BINARY(192) NOT NULL DEFAULT 0,
21 pk14 BINARY(192) NOT NULL DEFAULT 0,
22 pk15 BINARY(192) NOT NULL DEFAULT 0,
23 pk16 BINARY(192) NOT NULL DEFAULT 0,
24 data VARBINARY(10294) NOT NULL,
25 PRIMARY KEY(pk01,pk02,pk03,pk04,pk05,pk06,pk07,pk08,pk09,pk10,pk11,pk12,pk13,pk14,pk15,pk16))
26 ENGINE ndb;
27 Warnings:
28 Warning 1296 Specified key 'PRIMARY' was too long (max = 3056 bytes); statistics will not be generated
29 SHOW WARNINGS;
30 Level Code Message
31 Warning 1296 Specified key 'PRIMARY' was too long (max = 3056 bytes); statistics will not be generated
32 INSERT INTO t (pk01, data) VALUES (REPEAT(' ', 192), REPEAT('.', 10294));
33 SELECT LENGTH(pk01), CRC32(pk01), LENGTH(data), CRC32(data) FROM t;
34 LENGTH(pk01) CRC32(pk01) LENGTH(data) CRC32(data)
35 192 1459861267 10294 304092973
36 UPDATE t SET data = repeat(':', 10294) where pk01 = REPEAT(' ', 192);
37 SELECT LENGTH(pk01), CRC32(pk01), LENGTH(data), CRC32(data) FROM t;
38 LENGTH(pk01) CRC32(pk01) LENGTH(data) CRC32(data)
39 192 1459861267 10294 382912181
40 ******* Select from Slave *************
41
42 SELECT LENGTH(pk01), CRC32(pk01), LENGTH(data), CRC32(data) FROM t;
43 LENGTH(pk01) CRC32(pk01) LENGTH(data) CRC32(data)
44 192 1459861267 10294 382912181
45 DELETE FROM t where pk01 = REPEAT(' ', 192);
46 SELECT LENGTH(pk01), CRC32(pk01), LENGTH(data), CRC32(data) FROM t;
47 LENGTH(pk01) CRC32(pk01) LENGTH(data) CRC32(data)
48 ******* Select from Slave *************
49
50 SELECT LENGTH(pk01), CRC32(pk01), LENGTH(data), CRC32(data) FROM t;
51 LENGTH(pk01) CRC32(pk01) LENGTH(data) CRC32(data)
52 SET SESSION DEBUG="-d,ndb_crash_on_drop_SUB_TABLE_DATA";
53 DROP TABLE t;
54 CREATE TABLE t (
55 pk01 CHAR(255) NOT NULL,
56 pk02 CHAR(255) NOT NULL,
57 pk03 CHAR(255) NOT NULL,
58 data VARBINARY(10294) NOT NULL,
59 PRIMARY KEY(pk01,pk02,pk03)
60 ) ENGINE ndb;
61 Warnings:
62 Warning 1296 Specified key 'PRIMARY' was too long (max = 3056 bytes); statistics will not be generated
63 INSERT INTO t (pk01, pk02, pk03, data) VALUES ("xyz", "xyz", "xyz", REPEAT('.', 10294));
64 SELECT pk01, LENGTH(data), CRC32(data) FROM t;
65 pk01 LENGTH(data) CRC32(data)
66 xyz 10294 304092973
67 Update PK's to an 'equal' 'XYZ' value which is now included in BEFORE values
68 UPDATE t SET
69 pk01 = "XYZ", pk02 = "XYZ", pk03 = "XYZ", data = repeat(':', 10294)
70 where pk01 = "xyz";
71 SELECT pk01, LENGTH(data), CRC32(data) FROM t;
72 pk01 LENGTH(data) CRC32(data)
73 XYZ 10294 382912181
74 ******* Select from Slave *************
75
76 SELECT pk01, LENGTH(data), CRC32(data) FROM t;
77 pk01 LENGTH(data) CRC32(data)
78 XYZ 10294 382912181
79 Update PK's to non-equal 'XXX' values -> Update as delete+insert
80 All PK values is included in BEFORE values
81 UPDATE t SET
82 pk01 = "XXX", pk02 = "XXX", pk03 = "XXX", data = repeat(':', 10294)
83 where pk01 = "xyz";
84 SELECT pk01, LENGTH(data), CRC32(data) FROM t;
85 pk01 LENGTH(data) CRC32(data)
86 XXX 10294 382912181
87 ******* Select from Slave *************
88
89 SELECT pk01, LENGTH(data), CRC32(data) FROM t;
90 pk01 LENGTH(data) CRC32(data)
91 XXX 10294 382912181
92 DELETE FROM t;
93 SELECT pk01, LENGTH(data), CRC32(data) FROM t;
94 pk01 LENGTH(data) CRC32(data)
95 ******* Select from Slave *************
96
97 SELECT pk01, LENGTH(data), CRC32(data) FROM t;
98 pk01 LENGTH(data) CRC32(data)
99 DROP TABLE t;
100 include/rpl_end.inc