Debian Codegraph @

mysql-test/suite/rpl/r/rpl_alter.result

raw
1 include/master-slave.inc
2 [connection master]
3 create database mysqltest;
4 create table mysqltest.t1 ( n int);
5 alter table mysqltest.t1 add m int;
6 insert into mysqltest.t1 values (1,2);
7 create table mysqltest.t2 (n int);
8 insert into mysqltest.t2 values (45);
9 rename table mysqltest.t2 to mysqltest.t3, mysqltest.t1 to mysqltest.t2;
10 connection slave;
11 select * from mysqltest.t2;
12 n m
13 1 2
14 select * from mysqltest.t3;
15 n
16 45
17 connection master;
18 drop database mysqltest;
19 connection slave;
20 connection master;
21 use test;
22 #
23 # Test bug where ALTER TABLE MODIFY didn't replicate properly
24 #
25 create table t1 (a int unsigned primary key, b int);
26 show create table t1;
27 Table Create Table
28 t1 CREATE TABLE `t1` (
29 `a` int(10) unsigned NOT NULL,
30 `b` int(11) DEFAULT NULL,
31 PRIMARY KEY (`a`)
32 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
33 insert into t1 (a) values (1),((1<<32)-1);
34 select * from t1;
35 a b
36 1 NULL
37 4294967295 NULL
38 alter table t1 modify a bigint;
39 show create table t1;
40 Table Create Table
41 t1 CREATE TABLE `t1` (
42 `a` bigint(20) NOT NULL,
43 `b` int(11) DEFAULT NULL,
44 PRIMARY KEY (`a`)
45 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
46 select * from t1;
47 a b
48 1 NULL
49 4294967295 NULL
50 alter table t1 modify a int unsigned;
51 show create table t1;
52 Table Create Table
53 t1 CREATE TABLE `t1` (
54 `a` int(10) unsigned NOT NULL,
55 `b` int(11) DEFAULT NULL,
56 PRIMARY KEY (`a`)
57 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
58 select * from t1;
59 a b
60 1 NULL
61 4294967295 NULL
62 alter table t1 modify a bigint unsigned;
63 show create table t1;
64 Table Create Table
65 t1 CREATE TABLE `t1` (
66 `a` bigint(20) unsigned NOT NULL,
67 `b` int(11) DEFAULT NULL,
68 PRIMARY KEY (`a`)
69 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
70 select * from t1;
71 a b
72 1 NULL
73 4294967295 NULL
74 connection slave;
75 use test;
76 select * from t1;
77 a b
78 1 NULL
79 4294967295 NULL
80 show create table t1;
81 Table Create Table
82 t1 CREATE TABLE `t1` (
83 `a` bigint(20) unsigned NOT NULL,
84 `b` int(11) DEFAULT NULL,
85 PRIMARY KEY (`a`)
86 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
87 connection master;
88 create table t2 (a int unsigned auto_increment primary key, b int);
89 show create table t2;
90 Table Create Table
91 t2 CREATE TABLE `t2` (
92 `a` int(10) unsigned NOT NULL AUTO_INCREMENT,
93 `b` int(11) DEFAULT NULL,
94 PRIMARY KEY (`a`)
95 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
96 alter table t2 modify a bigint;
97 show create table t2;
98 Table Create Table
99 t2 CREATE TABLE `t2` (
100 `a` bigint(20) NOT NULL,
101 `b` int(11) DEFAULT NULL,
102 PRIMARY KEY (`a`)
103 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
104 alter table t2 modify a bigint auto_increment;
105 show create table t2;
106 Table Create Table
107 t2 CREATE TABLE `t2` (
108 `a` bigint(20) NOT NULL AUTO_INCREMENT,
109 `b` int(11) DEFAULT NULL,
110 PRIMARY KEY (`a`)
111 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
112 drop table t1,t2;
113 #
114 # MDEV-8432: Slave cannot replicate signed integer-type values
115 # with high bit set to 1
116 # Test replication when we have int on master and bigint on slave
117 #
118 create table t1 (a int unsigned primary key, b int);
119 connection slave;
120 SET GLOBAL SLAVE_TYPE_CONVERSIONS='ALL_NON_LOSSY';
121 alter table t1 modify a bigint unsigned;
122 connection master;
123 insert into t1 (a) values (1),((1<<32)-1);
124 connection slave;
125 select * from t1;
126 a b
127 1 NULL
128 4294967295 NULL
129 SET GLOBAL SLAVE_TYPE_CONVERSIONS='';
130 connection master;
131 drop table t1;
132 include/rpl_end.inc