Debian Codegraph @

mysql-test/suite/versioning/r/partition,heap.rdiff

raw
1 --- partition.result
2 +++ partition.reject
3 @@ -2228,85 +2228,6 @@
4 (PARTITION `p0` HISTORY ENGINE = X,
5 PARTITION `pn` CURRENT ENGINE = X)
6 drop tables t1, tp1;
7 -# Complex table
8 -create or replace table t1 (
9 -x int primary key auto_increment,
10 -t timestamp(6) default '2001-11-11 11:11:11',
11 -b blob(4096) compressed null,
12 -c varchar(1033) character set utf8 not null,
13 -u int,
14 -unique key (x, u),
15 -m enum('a', 'b', 'c') not null default 'a' comment 'absolute',
16 -i1 tinyint, i2 smallint, i3 bigint,
17 -index three(i1, i2, i3),
18 -v1 timestamp(6) generated always as (t + interval 1 day),
19 -v2 timestamp(6) generated always as (t + interval 1 month) stored,
20 -s timestamp(6) as row start,
21 -e timestamp(6) as row end,
22 -period for system_time (s, e),
23 -ps date, pe date,
24 -period for app_time (ps, pe),
25 -constraint check_constr check (u > -1))
26 -with system versioning default charset=ucs2
27 -partition by range(x) (
28 -partition p0 values less than (10),
29 -partition p1 values less than (20),
30 -partition pn values less than maxvalue);
31 -alter table t1 convert partition p1 to table tp1;
32 -show create table tp1;
33 -Table Create Table
34 -tp1 CREATE TABLE `tp1` (
35 - `x` int(11) NOT NULL AUTO_INCREMENT,
36 - `t` timestamp(6) NULL DEFAULT '2001-11-11 11:11:11.000000',
37 - `b` blob /*M!100301 COMPRESSED*/ DEFAULT NULL,
38 - `c` varchar(1033) CHARACTER SET utf8mb3 COLLATE utf8mb3_uca1400_ai_ci NOT NULL,
39 - `u` int(11) DEFAULT NULL,
40 - `m` enum('a','b','c') NOT NULL DEFAULT 'a' COMMENT 'absolute',
41 - `i1` tinyint(4) DEFAULT NULL,
42 - `i2` smallint(6) DEFAULT NULL,
43 - `i3` bigint(20) DEFAULT NULL,
44 - `v1` timestamp(6) GENERATED ALWAYS AS (`t` + interval 1 day) VIRTUAL,
45 - `v2` timestamp(6) GENERATED ALWAYS AS (`t` + interval 1 month) STORED,
46 - `s` timestamp(6) GENERATED ALWAYS AS ROW START,
47 - `e` timestamp(6) GENERATED ALWAYS AS ROW END,
48 - `ps` date NOT NULL,
49 - `pe` date NOT NULL,
50 - PERIOD FOR `app_time` (`ps`, `pe`),
51 - PRIMARY KEY (`x`,`e`),
52 - UNIQUE KEY `x` (`x`,`u`,`e`),
53 - KEY `three` (`i1`,`i2`,`i3`),
54 - PERIOD FOR SYSTEM_TIME (`s`, `e`),
55 - CONSTRAINT `check_constr` CHECK (`u` > -1)
56 -) ENGINE=X DEFAULT CHARSET=ucs2 COLLATE=ucs2_uca1400_ai_ci WITH SYSTEM VERSIONING
57 -show create table t1;
58 -Table Create Table
59 -t1 CREATE TABLE `t1` (
60 - `x` int(11) NOT NULL AUTO_INCREMENT,
61 - `t` timestamp(6) NULL DEFAULT '2001-11-11 11:11:11.000000',
62 - `b` blob /*M!100301 COMPRESSED*/ DEFAULT NULL,
63 - `c` varchar(1033) CHARACTER SET utf8mb3 COLLATE utf8mb3_uca1400_ai_ci NOT NULL,
64 - `u` int(11) DEFAULT NULL,
65 - `m` enum('a','b','c') NOT NULL DEFAULT 'a' COMMENT 'absolute',
66 - `i1` tinyint(4) DEFAULT NULL,
67 - `i2` smallint(6) DEFAULT NULL,
68 - `i3` bigint(20) DEFAULT NULL,
69 - `v1` timestamp(6) GENERATED ALWAYS AS (`t` + interval 1 day) VIRTUAL,
70 - `v2` timestamp(6) GENERATED ALWAYS AS (`t` + interval 1 month) STORED,
71 - `s` timestamp(6) GENERATED ALWAYS AS ROW START,
72 - `e` timestamp(6) GENERATED ALWAYS AS ROW END,
73 - `ps` date NOT NULL,
74 - `pe` date NOT NULL,
75 - PERIOD FOR `app_time` (`ps`, `pe`),
76 - PRIMARY KEY (`x`,`e`),
77 - UNIQUE KEY `x` (`x`,`u`,`e`),
78 - KEY `three` (`i1`,`i2`,`i3`),
79 - PERIOD FOR SYSTEM_TIME (`s`, `e`),
80 - CONSTRAINT `check_constr` CHECK (`u` > -1)
81 -) ENGINE=X DEFAULT CHARSET=ucs2 COLLATE=ucs2_uca1400_ai_ci WITH SYSTEM VERSIONING
82 - PARTITION BY RANGE (`x`)
83 -(PARTITION `p0` VALUES LESS THAN (10) ENGINE = X,
84 - PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = X)
85 -drop tables t1, tp1;
86 #
87 # MDEV-29841 Partition by system_time can be converted into table but not back
88 #
89 @@ -2870,134 +2791,6 @@
90 Warning 4114 Versioned table `test`.`t1`: last HISTORY partition (`p0`) is out of INTERVAL, need more HISTORY partitions
91 drop prepare s;
92 affected rows: 0
93 -# Complex table
94 -set timestamp= unix_timestamp('2000-01-01 00:00:00');
95 -affected rows: 0
96 -create or replace table t1 (
97 -x int primary key auto_increment,
98 -t timestamp(6) default '2001-11-11 11:11:11',
99 -b blob(4096) compressed null,
100 -c varchar(1033) character set utf8 not null,
101 -u int unique,
102 -m enum('a', 'b', 'c') not null default 'a' comment 'absolute',
103 -i1 tinyint, i2 smallint, i3 bigint,
104 -index three(i1, i2, i3),
105 -v1 timestamp(6) generated always as (t + interval 1 day),
106 -v2 timestamp(6) generated always as (t + interval 1 month) stored,
107 -s timestamp(6) as row start,
108 -e timestamp(6) as row end,
109 -period for system_time (s, e),
110 -ps date, pe date,
111 -period for app_time (ps, pe),
112 -constraint check_constr check (u > -1))
113 -with system versioning default charset=ucs2
114 -partition by system_time interval 1 hour auto (
115 -partition p2 history,
116 -partition pn current);
117 -affected rows: 0
118 -show create table t1;
119 -Table Create Table
120 -t1 CREATE TABLE `t1` (
121 - `x` int(11) NOT NULL AUTO_INCREMENT,
122 - `t` timestamp(6) NULL DEFAULT '2001-11-11 11:11:11.000000',
123 - `b` blob /*M!100301 COMPRESSED*/ DEFAULT NULL,
124 - `c` varchar(1033) CHARACTER SET utf8mb3 COLLATE utf8mb3_uca1400_ai_ci NOT NULL,
125 - `u` int(11) DEFAULT NULL,
126 - `m` enum('a','b','c') NOT NULL DEFAULT 'a' COMMENT 'absolute',
127 - `i1` tinyint(4) DEFAULT NULL,
128 - `i2` smallint(6) DEFAULT NULL,
129 - `i3` bigint(20) DEFAULT NULL,
130 - `v1` timestamp(6) GENERATED ALWAYS AS (`t` + interval 1 day) VIRTUAL,
131 - `v2` timestamp(6) GENERATED ALWAYS AS (`t` + interval 1 month) STORED,
132 - `s` timestamp(6) GENERATED ALWAYS AS ROW START,
133 - `e` timestamp(6) GENERATED ALWAYS AS ROW END,
134 - `ps` date NOT NULL,
135 - `pe` date NOT NULL,
136 - PERIOD FOR `app_time` (`ps`, `pe`),
137 - PRIMARY KEY (`x`,`e`),
138 - UNIQUE KEY `u` (`u`,`e`),
139 - KEY `three` (`i1`,`i2`,`i3`),
140 - PERIOD FOR SYSTEM_TIME (`s`, `e`),
141 - CONSTRAINT `check_constr` CHECK (`u` > -1)
142 -) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=ucs2 COLLATE=ucs2_uca1400_ai_ci WITH SYSTEM VERSIONING
143 - PARTITION BY SYSTEM_TIME INTERVAL 1 HOUR STARTS TIMESTAMP'2000-01-01 00:00:00' AUTO
144 -(PARTITION `p2` HISTORY ENGINE = DEFAULT_ENGINE,
145 - PARTITION `pn` CURRENT ENGINE = DEFAULT_ENGINE)
146 -affected rows: 1
147 -insert into t1 (x, c, u, i1, i2, i3, ps, pe)
148 -values (1, 'cc', 0, 1, 2, 3, '1999-01-01', '2000-01-01');
149 -affected rows: 1
150 -set timestamp= unix_timestamp('2000-01-01 01:00:00');
151 -affected rows: 0
152 -update t1 set x= x + 8;
153 -affected rows: 1
154 -info: Rows matched: 1 Changed: 1 Inserted: 1 Warnings: 0
155 -show create table t1;
156 -Table Create Table
157 -t1 CREATE TABLE `t1` (
158 - `x` int(11) NOT NULL AUTO_INCREMENT,
159 - `t` timestamp(6) NULL DEFAULT '2001-11-11 11:11:11.000000',
160 - `b` blob /*M!100301 COMPRESSED*/ DEFAULT NULL,
161 - `c` varchar(1033) CHARACTER SET utf8mb3 COLLATE utf8mb3_uca1400_ai_ci NOT NULL,
162 - `u` int(11) DEFAULT NULL,
163 - `m` enum('a','b','c') NOT NULL DEFAULT 'a' COMMENT 'absolute',
164 - `i1` tinyint(4) DEFAULT NULL,
165 - `i2` smallint(6) DEFAULT NULL,
166 - `i3` bigint(20) DEFAULT NULL,
167 - `v1` timestamp(6) GENERATED ALWAYS AS (`t` + interval 1 day) VIRTUAL,
168 - `v2` timestamp(6) GENERATED ALWAYS AS (`t` + interval 1 month) STORED,
169 - `s` timestamp(6) GENERATED ALWAYS AS ROW START,
170 - `e` timestamp(6) GENERATED ALWAYS AS ROW END,
171 - `ps` date NOT NULL,
172 - `pe` date NOT NULL,
173 - PERIOD FOR `app_time` (`ps`, `pe`),
174 - PRIMARY KEY (`x`,`e`),
175 - UNIQUE KEY `u` (`u`,`e`),
176 - KEY `three` (`i1`,`i2`,`i3`),
177 - PERIOD FOR SYSTEM_TIME (`s`, `e`),
178 - CONSTRAINT `check_constr` CHECK (`u` > -1)
179 -) ENGINE=DEFAULT_ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=ucs2 COLLATE=ucs2_uca1400_ai_ci WITH SYSTEM VERSIONING
180 - PARTITION BY SYSTEM_TIME INTERVAL 1 HOUR STARTS TIMESTAMP'2000-01-01 00:00:00' AUTO
181 -(PARTITION `p2` HISTORY ENGINE = DEFAULT_ENGINE,
182 - PARTITION `p1` HISTORY ENGINE = DEFAULT_ENGINE,
183 - PARTITION `pn` CURRENT ENGINE = DEFAULT_ENGINE)
184 -affected rows: 1
185 -set timestamp= unix_timestamp('2000-01-01 02:00:00');
186 -affected rows: 0
187 -update t1 set x= x - 8;
188 -affected rows: 1
189 -info: Rows matched: 1 Changed: 1 Inserted: 1 Warnings: 0
190 -show create table t1;
191 -Table Create Table
192 -t1 CREATE TABLE `t1` (
193 - `x` int(11) NOT NULL AUTO_INCREMENT,
194 - `t` timestamp(6) NULL DEFAULT '2001-11-11 11:11:11.000000',
195 - `b` blob /*M!100301 COMPRESSED*/ DEFAULT NULL,
196 - `c` varchar(1033) CHARACTER SET utf8mb3 COLLATE utf8mb3_uca1400_ai_ci NOT NULL,
197 - `u` int(11) DEFAULT NULL,
198 - `m` enum('a','b','c') NOT NULL DEFAULT 'a' COMMENT 'absolute',
199 - `i1` tinyint(4) DEFAULT NULL,
200 - `i2` smallint(6) DEFAULT NULL,
201 - `i3` bigint(20) DEFAULT NULL,
202 - `v1` timestamp(6) GENERATED ALWAYS AS (`t` + interval 1 day) VIRTUAL,
203 - `v2` timestamp(6) GENERATED ALWAYS AS (`t` + interval 1 month) STORED,
204 - `s` timestamp(6) GENERATED ALWAYS AS ROW START,
205 - `e` timestamp(6) GENERATED ALWAYS AS ROW END,
206 - `ps` date NOT NULL,
207 - `pe` date NOT NULL,
208 - PERIOD FOR `app_time` (`ps`, `pe`),
209 - PRIMARY KEY (`x`,`e`),
210 - UNIQUE KEY `u` (`u`,`e`),
211 - KEY `three` (`i1`,`i2`,`i3`),
212 - PERIOD FOR SYSTEM_TIME (`s`, `e`),
213 - CONSTRAINT `check_constr` CHECK (`u` > -1)
214 -) ENGINE=DEFAULT_ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=ucs2 COLLATE=ucs2_uca1400_ai_ci WITH SYSTEM VERSIONING
215 - PARTITION BY SYSTEM_TIME INTERVAL 1 HOUR STARTS TIMESTAMP'2000-01-01 00:00:00' AUTO
216 -(PARTITION `p2` HISTORY ENGINE = DEFAULT_ENGINE,
217 - PARTITION `p1` HISTORY ENGINE = DEFAULT_ENGINE,
218 - PARTITION `p3` HISTORY ENGINE = DEFAULT_ENGINE,
219 - PARTITION `pn` CURRENT ENGINE = DEFAULT_ENGINE)
220 -affected rows: 1
221 # INSERT .. ON DUPLICATE KEY UPDATE (ODKU)
222 set timestamp= unix_timestamp('2000-01-01 00:00:00');
223 create or replace table t1 (x int primary key) with system versioning