Debian Codegraph @

mysql-test/suite/ndb_rpl/r/ndb_rpl_myisam2ndb.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 SET default_storage_engine=myisam;
7 supports_native_partitioning: 0
8 --- Start test 1 Basic testing ---
9 --- Create Table Section ---
10 CREATE TABLE t1 (id MEDIUMINT NOT NULL, b1 BIT(8), vc VARCHAR(255),
11 bc CHAR(255), d DECIMAL(10,4) DEFAULT 0,
12 f FLOAT DEFAULT 0, total BIGINT UNSIGNED,
13 y YEAR, t DATE,PRIMARY KEY(id));
14 --- Show table on master ---
15 SHOW CREATE TABLE t1;
16 Table Create Table
17 t1 CREATE TABLE `t1` (
18 `id` mediumint NOT NULL,
19 `b1` bit(8) DEFAULT NULL,
20 `vc` varchar(255) DEFAULT NULL,
21 `bc` char(255) DEFAULT NULL,
22 `d` decimal(10,4) DEFAULT '0.0000',
23 `f` float DEFAULT '0',
24 `total` bigint unsigned DEFAULT NULL,
25 `y` year DEFAULT NULL,
26 `t` date DEFAULT NULL,
27 PRIMARY KEY (`id`)
28 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
29 --- Show table on slave ---
30 SHOW CREATE TABLE t1;
31 Table Create Table
32 t1 CREATE TABLE `t1` (
33 `id` mediumint NOT NULL,
34 `b1` bit(8) DEFAULT NULL,
35 `vc` varchar(255) DEFAULT NULL,
36 `bc` char(255) DEFAULT NULL,
37 `d` decimal(10,4) DEFAULT '0.0000',
38 `f` float DEFAULT '0',
39 `total` bigint unsigned DEFAULT NULL,
40 `y` year DEFAULT NULL,
41 `t` date DEFAULT NULL,
42 PRIMARY KEY (`id`)
43 ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
44 --- Perform basic operation on master ---
45 --- and ensure replicated correctly ---
46 "--- Insert into t1 --" as "";
47 --- Select from t1 on master ---
48 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
49 id hex(b1) vc bc d f total y t
50 2 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 1965-11-14
51 4 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 1985-11-14
52 42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 1905-11-14
53 142 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 1995-11-14
54 412 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14
55 --- Select from t1 on slave ---
56 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
57 id hex(b1) vc bc d f total y t
58 2 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 1965-11-14
59 4 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 1985-11-14
60 42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 1905-11-14
61 142 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 1995-11-14
62 412 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14
63 --- Update t1 on master --
64 UPDATE t1 SET b1 = 0, t="2006-02-22" WHERE id = 412;
65 --- Check the update on master ---
66 SELECT id,hex(b1),vc,bc,d,f,total,y,t FROM t1 WHERE id = 412;
67 id hex(b1) vc bc d f total y t
68 412 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2006-02-22
69 --- Check Update on slave ---
70 SELECT id,hex(b1),vc,bc,d,f,total,y,t FROM t1 WHERE id = 412;
71 id hex(b1) vc bc d f total y t
72 412 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2006-02-22
73 --- Remove a record from t1 on master ---
74 DELETE FROM t1 WHERE id = 42;
75 --- Show current count on master for t1 ---
76 SELECT COUNT(*) FROM t1;
77 COUNT(*)
78 4
79 --- Show current count on slave for t1 ---
80 SELECT COUNT(*) FROM t1;
81 COUNT(*)
82 4
83 DELETE FROM t1;
84 --- Check that simple Alter statements are replicated correctly --
85 ALTER TABLE t1 DROP PRIMARY KEY, ADD PRIMARY KEY(id, total);
86 ALTER TABLE t1 MODIFY vc TEXT;
87 --- Show the new improved table on the master ---
88 SHOW CREATE TABLE t1;
89 Table Create Table
90 t1 CREATE TABLE `t1` (
91 `id` mediumint NOT NULL,
92 `b1` bit(8) DEFAULT NULL,
93 `vc` text,
94 `bc` char(255) DEFAULT NULL,
95 `d` decimal(10,4) DEFAULT '0.0000',
96 `f` float DEFAULT '0',
97 `total` bigint unsigned NOT NULL,
98 `y` year DEFAULT NULL,
99 `t` date DEFAULT NULL,
100 PRIMARY KEY (`id`,`total`)
101 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
102 --- Make sure that our tables on slave are still same engine ---
103 --- and that the alter statements replicated correctly ---
104 SHOW CREATE TABLE t1;
105 Table Create Table
106 t1 CREATE TABLE `t1` (
107 `id` mediumint NOT NULL,
108 `b1` bit(8) DEFAULT NULL,
109 `vc` text,
110 `bc` char(255) DEFAULT NULL,
111 `d` decimal(10,4) DEFAULT '0.0000',
112 `f` float DEFAULT '0',
113 `total` bigint unsigned NOT NULL,
114 `y` year DEFAULT NULL,
115 `t` date DEFAULT NULL,
116 PRIMARY KEY (`id`,`total`)
117 ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
118 --- Perform basic operation on master ---
119 --- and ensure replicated correctly ---
120 "--- Insert into t1 --" as "";
121 --- Select from t1 on master ---
122 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
123 id hex(b1) vc bc d f total y t
124 2 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 1965-11-14
125 4 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 1985-11-14
126 42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 1905-11-14
127 142 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 1995-11-14
128 412 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14
129 --- Select from t1 on slave ---
130 select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
131 id hex(b1) vc bc d f total y t
132 2 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 1965-11-14
133 4 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 1985-11-14
134 42 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 1905-11-14
135 142 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 1995-11-14
136 412 1 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2005-11-14
137 --- Update t1 on master --
138 UPDATE t1 SET b1 = 0, t="2006-02-22" WHERE id = 412;
139 --- Check the update on master ---
140 SELECT id,hex(b1),vc,bc,d,f,total,y,t FROM t1 WHERE id = 412;
141 id hex(b1) vc bc d f total y t
142 412 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2006-02-22
143 --- Check Update on slave ---
144 SELECT id,hex(b1),vc,bc,d,f,total,y,t FROM t1 WHERE id = 412;
145 id hex(b1) vc bc d f total y t
146 412 0 Testing MySQL databases is a cool Must make it bug free for the customer 654321.4321 15.21 0 1965 2006-02-22
147 --- Remove a record from t1 on master ---
148 DELETE FROM t1 WHERE id = 42;
149 --- Show current count on master for t1 ---
150 SELECT COUNT(*) FROM t1;
151 COUNT(*)
152 4
153 --- Show current count on slave for t1 ---
154 SELECT COUNT(*) FROM t1;
155 COUNT(*)
156 4
157 DELETE FROM t1;
158 --- End test 1 Basic testing ---
159 --- Do Cleanup --
160 DROP TABLE IF EXISTS t1;
161 include/rpl_end.inc