Debian Codegraph @

mysql-test/suite/ndb_rpl/t/ndb_rpl_rowsize.inc

raw
1 --source include/have_debug.inc
2 --source include/have_ndb.inc
3 --source include/have_binlog_format_mixed_or_row.inc
4 --source suite/ndb_rpl/ndb_master-slave.inc
5
6 SET SESSION DEBUG="+d,ndb_crash_on_drop_SUB_TABLE_DATA";
7
8 error 0,1005;
9 eval CREATE TABLE t (
10 pk01 BINARY(192) NOT NULL,
11 pk02 BINARY(192) NOT NULL DEFAULT 0,
12 pk03 BINARY(192) NOT NULL DEFAULT 0,
13 pk04 BINARY(192) NOT NULL DEFAULT 0,
14 pk05 BINARY(192) NOT NULL DEFAULT 0,
15 pk06 BINARY(192) NOT NULL DEFAULT 0,
16 pk07 BINARY(192) NOT NULL DEFAULT 0,
17 pk08 BINARY(192) NOT NULL DEFAULT 0,
18 pk09 BINARY(192) NOT NULL DEFAULT 0,
19 pk10 BINARY(192) NOT NULL DEFAULT 0,
20 pk11 BINARY(192) NOT NULL DEFAULT 0,
21 pk12 BINARY(192) NOT NULL DEFAULT 0,
22 pk13 BINARY(192) NOT NULL DEFAULT 0,
23 pk14 BINARY(192) NOT NULL DEFAULT 0,
24 pk15 BINARY(192) NOT NULL DEFAULT 0,
25 pk16 BINARY(192) NOT NULL DEFAULT 0,
26 data VARBINARY($varsize) NOT NULL,
27 PRIMARY KEY(pk01,pk02,pk03,pk04,pk05,pk06,pk07,pk08,pk09,pk10,pk11,pk12,pk13,pk14,pk15,pk16))
28 ENGINE ndb;
29 SHOW WARNINGS;
30
31 eval INSERT INTO t (pk01, data) VALUES (REPEAT(' ', 192), REPEAT('.', $varsize));
32 SELECT LENGTH(pk01), CRC32(pk01), LENGTH(data), CRC32(data) FROM t;
33
34 eval UPDATE t SET data = repeat(':', $varsize) where pk01 = REPEAT(' ', 192);
35 SELECT LENGTH(pk01), CRC32(pk01), LENGTH(data), CRC32(data) FROM t;
36
37 sync_slave_with_master;
38 --echo ******* Select from Slave *************
39 --echo
40 SELECT LENGTH(pk01), CRC32(pk01), LENGTH(data), CRC32(data) FROM t;
41
42 connection default;
43
44 DELETE FROM t where pk01 = REPEAT(' ', 192);
45 SELECT LENGTH(pk01), CRC32(pk01), LENGTH(data), CRC32(data) FROM t;
46
47 sync_slave_with_master;
48 --echo ******* Select from Slave *************
49 --echo
50 SELECT LENGTH(pk01), CRC32(pk01), LENGTH(data), CRC32(data) FROM t;
51
52 connection default;
53 SET SESSION DEBUG="-d,ndb_crash_on_drop_SUB_TABLE_DATA";
54
55 connection master;
56 DROP TABLE t;
57
58 ################################
59 # Test case added for bug#34388068:
60 # NDB: Update to char data type columns in primay keys are lost on replica
61 #
62 # Changed PK values may now be included in the BEFORE trigger values as well.
63 # Check that SUMA buffering is still able to handle the larger 'values'
64
65 eval CREATE TABLE t (
66 pk01 CHAR(255) NOT NULL,
67 pk02 CHAR(255) NOT NULL,
68 pk03 CHAR(255) NOT NULL,
69 data VARBINARY($varsize) NOT NULL,
70 PRIMARY KEY(pk01,pk02,pk03)
71 ) ENGINE ndb;
72
73 eval INSERT INTO t (pk01, pk02, pk03, data) VALUES ("xyz", "xyz", "xyz", REPEAT('.', $varsize));
74 SELECT pk01, LENGTH(data), CRC32(data) FROM t;
75
76 connection master;
77 --echo Update PK's to an 'equal' 'XYZ' value which is now included in BEFORE values
78 eval UPDATE t SET
79 pk01 = "XYZ", pk02 = "XYZ", pk03 = "XYZ", data = repeat(':', $varsize)
80 where pk01 = "xyz";
81 SELECT pk01, LENGTH(data), CRC32(data) FROM t;
82
83 sync_slave_with_master;
84 --echo ******* Select from Slave *************
85 --echo
86 SELECT pk01, LENGTH(data), CRC32(data) FROM t;
87
88 connection master;
89 --echo Update PK's to non-equal 'XXX' values -> Update as delete+insert
90 --echo All PK values is included in BEFORE values
91 eval UPDATE t SET
92 pk01 = "XXX", pk02 = "XXX", pk03 = "XXX", data = repeat(':', $varsize)
93 where pk01 = "xyz";
94 SELECT pk01, LENGTH(data), CRC32(data) FROM t;
95
96 sync_slave_with_master;
97 --echo ******* Select from Slave *************
98 --echo
99 SELECT pk01, LENGTH(data), CRC32(data) FROM t;
100
101 connection default;
102
103 DELETE FROM t;
104 SELECT pk01, LENGTH(data), CRC32(data) FROM t;
105
106 sync_slave_with_master;
107 --echo ******* Select from Slave *************
108 --echo
109 SELECT pk01, LENGTH(data), CRC32(data) FROM t;
110
111 connection master;
112 DROP TABLE t;
113
114 sync_slave_with_master;
115
116 --source include/rpl_end.inc