Debian Codegraph @

mysql-test/suite/engines/funcs/r/rpl_alter,innodb.rdiff

raw
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=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
6 +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
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=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
15 +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
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=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
24 +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
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=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
33 +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
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=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
42 +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
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=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
51 +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
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=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
60 +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
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=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
69 +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
70 drop table t1,t2;
71 #
72 # MDEV-8432: Slave cannot replicate signed integer-type values