include/master-slave.inc
Warnings:
Note	####	Sending passwords in plain text without SSL/TLS is extremely insecure.
Note	####	Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
[connection master]
SET SESSION DEBUG="+d,ndb_crash_on_drop_SUB_TABLE_DATA";
CREATE TABLE t (
pk01 BINARY(192) NOT NULL,
pk02 BINARY(192) NOT NULL DEFAULT 0,
pk03 BINARY(192) NOT NULL DEFAULT 0,
pk04 BINARY(192) NOT NULL DEFAULT 0,
pk05 BINARY(192) NOT NULL DEFAULT 0,
pk06 BINARY(192) NOT NULL DEFAULT 0,
pk07 BINARY(192) NOT NULL DEFAULT 0,
pk08 BINARY(192) NOT NULL DEFAULT 0,
pk09 BINARY(192) NOT NULL DEFAULT 0,
pk10 BINARY(192) NOT NULL DEFAULT 0,
pk11 BINARY(192) NOT NULL DEFAULT 0,
pk12 BINARY(192) NOT NULL DEFAULT 0,
pk13 BINARY(192) NOT NULL DEFAULT 0,
pk14 BINARY(192) NOT NULL DEFAULT 0,
pk15 BINARY(192) NOT NULL DEFAULT 0,
pk16 BINARY(192) NOT NULL DEFAULT 0,
data VARBINARY(10294) NOT NULL,
PRIMARY KEY(pk01,pk02,pk03,pk04,pk05,pk06,pk07,pk08,pk09,pk10,pk11,pk12,pk13,pk14,pk15,pk16))
ENGINE ndb;
SHOW WARNINGS;
Level	Code	Message
INSERT INTO t (pk01, data) VALUES (REPEAT(' ', 192), REPEAT('.', 10294));
SELECT LENGTH(pk01), CRC32(pk01), LENGTH(data), CRC32(data) FROM t;
LENGTH(pk01)	CRC32(pk01)	LENGTH(data)	CRC32(data)
192	1459861267	10294	304092973
UPDATE t SET data = repeat(':', 10294) where pk01 = REPEAT(' ', 192);
SELECT LENGTH(pk01), CRC32(pk01), LENGTH(data), CRC32(data) FROM t;
LENGTH(pk01)	CRC32(pk01)	LENGTH(data)	CRC32(data)
192	1459861267	10294	382912181
******* Select from Slave *************

SELECT LENGTH(pk01), CRC32(pk01), LENGTH(data), CRC32(data) FROM t;
LENGTH(pk01)	CRC32(pk01)	LENGTH(data)	CRC32(data)
192	1459861267	10294	382912181
DELETE FROM t where pk01 = REPEAT(' ', 192);
SELECT LENGTH(pk01), CRC32(pk01), LENGTH(data), CRC32(data) FROM t;
LENGTH(pk01)	CRC32(pk01)	LENGTH(data)	CRC32(data)
******* Select from Slave *************

SELECT LENGTH(pk01), CRC32(pk01), LENGTH(data), CRC32(data) FROM t;
LENGTH(pk01)	CRC32(pk01)	LENGTH(data)	CRC32(data)
SET SESSION DEBUG="-d,ndb_crash_on_drop_SUB_TABLE_DATA";
DROP TABLE t;
include/rpl_end.inc