Debian Codegraph @

mysql-test/suite/ndb_rpl/r/ndb_rpl_uktest.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 drop table if exists mysql.ndb_replication;
7 Warnings:
8 Note 1051 Unknown table 'mysql.ndb_replication'
9 CREATE TABLE mysql.ndb_replication
10 (db VARBINARY(63),
11 table_name VARBINARY(63),
12 server_id INT UNSIGNED,
13 binlog_type INT UNSIGNED,
14 conflict_fn VARBINARY(128),
15 PRIMARY KEY USING HASH (db,table_name,server_id))
16 ENGINE=NDB PARTITION BY KEY(db,table_name);
17 Populate ndb_replication table as necessary
18 replace into mysql.ndb_replication values
19 ("test", "t1", 0, 7, NULL);
20 create table test.t1 (
21 a int primary key,
22 b int,
23 c int,
24 unique(c)) engine=ndb;
25 Insert some data
26 insert into test.t1 values (1,1,1), (2,2,2), (3,3,3), (4,4,4), (5,5,5);
27 Now try to show problem
28 Generate inserts and updates interleaved
29 Updates are on existing keys, but do not affect existing key values
30 insert into test.t1 values (6,6,6), (7,7,7), (8,8,8);
31 update test.t1 set b=10 where a < 6;
32 select * from t1 order by a;
33 a b c
34 1 10 1
35 2 10 2
36 3 10 3
37 4 10 4
38 5 10 5
39 6 6 6
40 7 7 7
41 8 8 8
42 select * from t1 order by a;
43 a b c
44 1 10 1
45 2 10 2
46 3 10 3
47 4 10 4
48 5 10 5
49 6 6 6
50 7 7 7
51 8 8 8
52 drop table test.t1;
53 drop table mysql.ndb_replication;
54 include/rpl_end.inc