| 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 |