Debian Codegraph @

mysql-test/suite/ndb_rpl/r/ndb_rpl_bug_13440282.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 CREATE TABLE `loadreptable` (
7 `nid` int(11) NOT NULL,
8 `nom` char(255) DEFAULT NULL,
9 `prenom` char(255) DEFAULT NULL,
10 `abc` char(255) DEFAULT NULL,
11 `wkz` char(255) DEFAULT NULL,
12 `xyz` char(255) DEFAULT NULL,
13 PRIMARY KEY (`nid`) USING HASH
14 ) ENGINE=ndbcluster DEFAULT CHARSET=latin1;
15 Warnings:
16 Warning 1681 Integer display width is deprecated and will be removed in a future release.
17 CREATE PROCEDURE MAJ ()
18 BEGIN
19 DECLARE fini INT default 0;
20 WHILE fini < 20 DO
21 DELETE FROM loadreptable WHERE nid > 2;
22 UPDATE loadreptable SET nid=nid+1 ORDER BY nid DESC;
23 UPDATE loadreptable SET
24 nom="xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
25 xxx";
26 INSERT INTO loadreptable VALUES(1,"w","t","y","k","b");
27 SET fini=fini+1;
28 END WHILE;
29 END ;
30 //
31 call MAJ();
32 "master"
33 select count(*) from loadreptable;
34 count(*)
35 3
36 "slave"
37 select count(*) from loadreptable;
38 count(*)
39 3
40 call MAJ();
41 "master"
42 select count(*) from loadreptable;
43 count(*)
44 3
45 "slave"
46 select count(*) from loadreptable;
47 count(*)
48 3
49 call MAJ();
50 "master"
51 select count(*) from loadreptable;
52 count(*)
53 3
54 "slave"
55 select count(*) from loadreptable;
56 count(*)
57 3
58 call MAJ();
59 "master"
60 select count(*) from loadreptable;
61 count(*)
62 3
63 "slave"
64 select count(*) from loadreptable;
65 count(*)
66 3
67 call MAJ();
68 "master"
69 select count(*) from loadreptable;
70 count(*)
71 3
72 "slave"
73 select count(*) from loadreptable;
74 count(*)
75 3
76 call MAJ();
77 "master"
78 select count(*) from loadreptable;
79 count(*)
80 3
81 "slave"
82 select count(*) from loadreptable;
83 count(*)
84 3
85 call MAJ();
86 "master"
87 select count(*) from loadreptable;
88 count(*)
89 3
90 "slave"
91 select count(*) from loadreptable;
92 count(*)
93 3
94 call MAJ();
95 "master"
96 select count(*) from loadreptable;
97 count(*)
98 3
99 "slave"
100 select count(*) from loadreptable;
101 count(*)
102 3
103 call MAJ();
104 "master"
105 select count(*) from loadreptable;
106 count(*)
107 3
108 "slave"
109 select count(*) from loadreptable;
110 count(*)
111 3
112 call MAJ();
113 "master"
114 select count(*) from loadreptable;
115 count(*)
116 3
117 "slave"
118 select count(*) from loadreptable;
119 count(*)
120 3
121 drop table loadreptable;
122 drop procedure MAJ;
123 include/rpl_end.inc