Debian Codegraph @

mysql-test/suite/ndb_rpl/r/ndb_rpl_hidden_pk.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 #
7 # Bug#33974581 Update of table with hidden key stops applier
8 #
9 # When Applier process changes to a hidden key table it need to read
10 # from NDB instead of just defining another update or write. Before the
11 # read can take place, any already defined operations need to be sent to
12 # NDB. This is done both in order to "read your own writes" as well as
13 # handle constraint violation and missing row errors in the same way as
14 # if the table with hidden key was not changed.
15 #
16 #
17 # 1) This test shows "read your own write" for table with hidden pk.
18 # Since the table has hidden pk the UPDATE will need to read rows
19 # from NDB, find the ones that match the condition and then update those.
20 # In order to make it possible for NDB to return the first INSERT it
21 # need to be prepared/flushed before starting to read.
22 #
23 [connection master]
24 CREATE TABLE t1 (a INT, b INT) engine = NDB;
25 INSERT INTO t1 VALUES (1, 1);
26 UPDATE t1 SET a=NULL where b=1;
27 include/sync_slave_sql_with_master.inc
28 [connection master]
29 DROP TABLE t1;
30 include/sync_slave_sql_with_master.inc
31 #
32 # 2) This tests show that applying changes to table with hidden pk
33 # ignore error(s) from previously defined changes (in the same epoch
34 # transaction) as they should.
35 #
36 [connection master]
37 CREATE TABLE t1 (a INT PRIMARY KEY, b INT) engine = NDB;
38 CREATE TABLE t2_hidden_pk (a INT, b INT) engine = NDB;
39 CREATE TABLE t3_hidden_pk_unique (a INT, b INT, unique(b)) engine = NDB;
40 CREATE TABLE t4_hidden_pk_index (a INT, b INT, index(b)) engine = NDB;
41 INSERT INTO t1 VALUES (1,1), (2,2), (3,3), (4,4), (5,5);
42 INSERT INTO t2_hidden_pk VALUES (1,1), (2,2), (3,3), (4,4), (5,5);
43 INSERT INTO t3_hidden_pk_unique VALUES (1,1), (2,2), (3,3), (4,4), (5,5);
44 INSERT INTO t4_hidden_pk_index VALUES (1,1), (2,2), (3,3), (4,4), (5,5);
45 include/sync_slave_sql_with_master.inc
46 [connection slave]
47 ## Delete rows on replica to make it possible to change something
48 ## on the source that would then fail when applied on the replica.
49 DELETE FROM t1 WHERE a = 5;
50 DELETE FROM t2_hidden_pk WHERE a = 5;
51 DELETE FROM t3_hidden_pk_unique WHERE a = 5;
52 DELETE FROM t4_hidden_pk_index WHERE a = 5;
53 ## Case 1, pk table (the "normal" case)
54 ## - update row that does not exist on replica
55 ## - update pk table -> direct update
56 [connection master]
57 BEGIN;
58 UPDATE t1 SET b = 0 WHERE a = 5;
59 UPDATE t1 SET b = 10 WHERE a = 1;
60 COMMIT;
61 include/sync_slave_sql_with_master.inc
62 ## Case 2, hidden pk table
63 ## - update row that does not exist on replica
64 ## - update hidden pk table -> uses scan
65 [connection master]
66 BEGIN;
67 UPDATE t1 SET b = 0 WHERE a = 5;
68 UPDATE t2_hidden_pk SET b = 10 WHERE a = 1;
69 COMMIT;
70 include/sync_slave_sql_with_master.inc
71 ## Case 3, hidden pk table with unique index
72 ## - update row that does not exist on replica
73 ## - update hidden pk table with unique index -> uses index scan
74 [connection master]
75 BEGIN;
76 UPDATE t1 SET b = 0 WHERE a = 5;
77 UPDATE t3_hidden_pk_unique SET a = 30 WHERE b < 3;
78 COMMIT;
79 include/sync_slave_sql_with_master.inc
80 ## Case 4, hidden pk table with index
81 ## - update row that does not exist on replica
82 ## - update hidden pk table with index -> uses index scan
83 [connection master]
84 BEGIN;
85 UPDATE t1 SET b = 0 WHERE a = 5;
86 UPDATE t4_hidden_pk_index SET a = 40 WHERE b < 4;
87 COMMIT;
88 include/sync_slave_sql_with_master.inc
89 # Cleanup
90 [connection master]
91 DROP TABLE t1, t2_hidden_pk, t3_hidden_pk_unique, t4_hidden_pk_index;
92 include/sync_slave_sql_with_master.inc
93 include/rpl_end.inc