1@@ -29,7 +29,7 @@ 2 `a` int(10) unsigned NOT NULL, 3 `b` int(11) DEFAULT NULL, 4 PRIMARY KEY (`a`) 5-) ENGINE=MyISAM DEFAULT CHARSET=latin1 6+) ENGINE=InnoDB DEFAULT CHARSET=latin1 7 insert into t1 (a) values (1),((1<<32)-1); 8 select * from t1; 9 a b 10@@ -42,7 +42,7 @@ 11 `a` bigint(20) NOT NULL, 12 `b` int(11) DEFAULT NULL, 13 PRIMARY KEY (`a`) 14-) ENGINE=MyISAM DEFAULT CHARSET=latin1 15+) ENGINE=InnoDB DEFAULT CHARSET=latin1 16 select * from t1; 17 a b 18 1 NULL 19@@ -54,7 +54,7 @@ 20 `a` int(10) unsigned NOT NULL, 21 `b` int(11) DEFAULT NULL, 22 PRIMARY KEY (`a`) 23-) ENGINE=MyISAM DEFAULT CHARSET=latin1 24+) ENGINE=InnoDB DEFAULT CHARSET=latin1 25 select * from t1; 26 a b 27 1 NULL 28@@ -66,7 +66,7 @@ 29 `a` bigint(20) unsigned NOT NULL, 30 `b` int(11) DEFAULT NULL, 31 PRIMARY KEY (`a`) 32-) ENGINE=MyISAM DEFAULT CHARSET=latin1 33+) ENGINE=InnoDB DEFAULT CHARSET=latin1 34 select * from t1; 35 a b 36 1 NULL 37@@ -83,7 +83,7 @@ 38 `a` bigint(20) unsigned NOT NULL, 39 `b` int(11) DEFAULT NULL, 40 PRIMARY KEY (`a`) 41-) ENGINE=MyISAM DEFAULT CHARSET=latin1 42+) ENGINE=InnoDB DEFAULT CHARSET=latin1 43 connection master; 44 create table t2 (a int unsigned auto_increment primary key, b int); 45 show create table t2; 46@@ -92,7 +92,7 @@ 47 `a` int(10) unsigned NOT NULL AUTO_INCREMENT, 48 `b` int(11) DEFAULT NULL, 49 PRIMARY KEY (`a`) 50-) ENGINE=MyISAM DEFAULT CHARSET=latin1 51+) ENGINE=InnoDB DEFAULT CHARSET=latin1 52 alter table t2 modify a bigint; 53 show create table t2; 54 Table Create Table 55@@ -100,7 +100,7 @@ 56 `a` bigint(20) NOT NULL, 57 `b` int(11) DEFAULT NULL, 58 PRIMARY KEY (`a`) 59-) ENGINE=MyISAM DEFAULT CHARSET=latin1 60+) ENGINE=InnoDB DEFAULT CHARSET=latin1 61 alter table t2 modify a bigint auto_increment; 62 show create table t2; 63 Table Create Table 64@@ -108,7 +108,7 @@ 65 `a` bigint(20) NOT NULL AUTO_INCREMENT, 66 `b` int(11) DEFAULT NULL, 67 PRIMARY KEY (`a`) 68-) ENGINE=MyISAM DEFAULT CHARSET=latin1 69+) ENGINE=InnoDB DEFAULT CHARSET=latin1 70 drop table t1,t2; 71 # 72 # MDEV-8432: Slave cannot replicate signed integer-type values 73