Debian Codegraph @

mysql-test/suite/versioning/r/delete_history,32bit.rdiff

raw
1 --- suite/versioning/r/delete_history.result
2 +++ suite/versioning/r/delete_history.reject
3 @@ -167,7 +167,7 @@
4 id select_type table type possible_keys key key_len ref rows filtered Extra
5 1 SIMPLE t1 ALL NULL NULL NULL NULL 1 100.00 Using where
6 Warnings:
7 -Note 1003 delete from `test`.`t1` FOR SYSTEM_TIME BEFORE TIMESTAMP '2039-01-01 23:00' using dual where `test`.`t1`.`row_end` < TIMESTAMP/*WITH LOCAL TIME ZONE*/'2039-01-01 23:00:00' and is_history(`test`.`t1`.`row_end`)
8 +Note 1003 delete from `test`.`t1` FOR SYSTEM_TIME BEFORE TIMESTAMP '2039-01-01 23:00' using dual where `test`.`t1`.`row_end` < '2039-01-01 23:00' and is_history(`test`.`t1`.`row_end`)
9 create or replace procedure p() delete history from t1 before system_time '2039-01-01 23:00';
10 call p;
11 select * from t1;
12 @@ -275,65 +275,65 @@
13 a row_start row_end
14 1 2000-01-01 00:00:00.000000 2000-01-01 00:00:01.000000
15 2 2000-01-01 00:00:01.000000 2000-01-01 00:00:02.000000
16 -3 2000-01-01 00:00:02.000000 2106-02-07 06:28:15.999999
17 -100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
18 +3 2000-01-01 00:00:02.000000 2038-01-19 03:14:07.999999
19 +100 2000-01-01 00:00:00.000000 2038-01-19 03:14:07.999999
20 select *, row_start, row_end from t for system_time as of @ts1;
21 a row_start row_end
22 -100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
23 +100 2000-01-01 00:00:00.000000 2038-01-19 03:14:07.999999
24 2 2000-01-01 00:00:01.000000 2000-01-01 00:00:02.000000
25 execute immediate "select *, row_start, row_end from t for system_time as of ?" using @ts1;
26 a row_start row_end
27 -100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
28 +100 2000-01-01 00:00:00.000000 2038-01-19 03:14:07.999999
29 2 2000-01-01 00:00:01.000000 2000-01-01 00:00:02.000000
30 prepare stmt from 'select *, row_start, row_end from t for system_time as of ?';
31 execute stmt using @ts1;
32 a row_start row_end
33 -100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
34 +100 2000-01-01 00:00:00.000000 2038-01-19 03:14:07.999999
35 2 2000-01-01 00:00:01.000000 2000-01-01 00:00:02.000000
36 Execute stmt using @ts1;
37 a row_start row_end
38 -100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
39 +100 2000-01-01 00:00:00.000000 2038-01-19 03:14:07.999999
40 2 2000-01-01 00:00:01.000000 2000-01-01 00:00:02.000000
41 select *, row_start, row_end from t for system_time as of @ts2;
42 a row_start row_end
43 -3 2000-01-01 00:00:02.000000 2106-02-07 06:28:15.999999
44 -100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
45 +3 2000-01-01 00:00:02.000000 2038-01-19 03:14:07.999999
46 +100 2000-01-01 00:00:00.000000 2038-01-19 03:14:07.999999
47 execute immediate "select *, row_start, row_end from t for system_time as of ?" using @ts2;
48 a row_start row_end
49 -3 2000-01-01 00:00:02.000000 2106-02-07 06:28:15.999999
50 -100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
51 +3 2000-01-01 00:00:02.000000 2038-01-19 03:14:07.999999
52 +100 2000-01-01 00:00:00.000000 2038-01-19 03:14:07.999999
53 execute stmt using @ts2;
54 a row_start row_end
55 -3 2000-01-01 00:00:02.000000 2106-02-07 06:28:15.999999
56 -100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
57 +3 2000-01-01 00:00:02.000000 2038-01-19 03:14:07.999999
58 +100 2000-01-01 00:00:00.000000 2038-01-19 03:14:07.999999
59 Execute stmt using @ts2;
60 a row_start row_end
61 -3 2000-01-01 00:00:02.000000 2106-02-07 06:28:15.999999
62 -100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
63 +3 2000-01-01 00:00:02.000000 2038-01-19 03:14:07.999999
64 +100 2000-01-01 00:00:00.000000 2038-01-19 03:14:07.999999
65 drop prepare stmt;
66 execute immediate "delete history from t before system_time @ts1";
67 select *, row_start, row_end from t for system_time all order by a;
68 a row_start row_end
69 1 2000-01-01 00:00:00.000000 2000-01-01 00:00:01.000000
70 2 2000-01-01 00:00:01.000000 2000-01-01 00:00:02.000000
71 -3 2000-01-01 00:00:02.000000 2106-02-07 06:28:15.999999
72 -100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
73 +3 2000-01-01 00:00:02.000000 2038-01-19 03:14:07.999999
74 +100 2000-01-01 00:00:00.000000 2038-01-19 03:14:07.999999
75 execute immediate "delete history from t before system_time @ts2";
76 select *, row_start, row_end from t for system_time all order by a;
77 a row_start row_end
78 2 2000-01-01 00:00:01.000000 2000-01-01 00:00:02.000000
79 -3 2000-01-01 00:00:02.000000 2106-02-07 06:28:15.999999
80 -100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
81 +3 2000-01-01 00:00:02.000000 2038-01-19 03:14:07.999999
82 +100 2000-01-01 00:00:00.000000 2038-01-19 03:14:07.999999
83 execute immediate "delete history from t before system_time ?" using @ts3;
84 select *, row_start, row_end from t for system_time all order by a;
85 a row_start row_end
86 -3 2000-01-01 00:00:02.000000 2106-02-07 06:28:15.999999
87 -100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
88 +3 2000-01-01 00:00:02.000000 2038-01-19 03:14:07.999999
89 +100 2000-01-01 00:00:00.000000 2038-01-19 03:14:07.999999
90 execute immediate "delete history from t before system_time ?" using @ts3;
91 select *, row_start, row_end from t for system_time all order by a;
92 a row_start row_end
93 -3 2000-01-01 00:00:02.000000 2106-02-07 06:28:15.999999
94 -100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
95 +3 2000-01-01 00:00:02.000000 2038-01-19 03:14:07.999999
96 +100 2000-01-01 00:00:00.000000 2038-01-19 03:14:07.999999
97 update t set a= a + 1 where a < 100;
98 set @ts4= '2000-01-01 00:00:04';
99 set timestamp= unix_timestamp(@ts4);
100 @@ -342,14 +342,14 @@
101 a row_start row_end
102 3 2000-01-01 00:00:02.000000 2000-01-01 00:00:03.000000
103 4 2000-01-01 00:00:03.000000 2000-01-01 00:00:04.000000
104 -5 2000-01-01 00:00:04.000000 2106-02-07 06:28:15.999999
105 -100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
106 +5 2000-01-01 00:00:04.000000 2038-01-19 03:14:07.999999
107 +100 2000-01-01 00:00:00.000000 2038-01-19 03:14:07.999999
108 execute immediate "delete history from t before system_time ?" using '2000-01-01 00:00:04';
109 select *, row_start, row_end from t for system_time all order by a;
110 a row_start row_end
111 4 2000-01-01 00:00:03.000000 2000-01-01 00:00:04.000000
112 -5 2000-01-01 00:00:04.000000 2106-02-07 06:28:15.999999
113 -100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
114 +5 2000-01-01 00:00:04.000000 2038-01-19 03:14:07.999999
115 +100 2000-01-01 00:00:00.000000 2038-01-19 03:14:07.999999
116 set @ts5= '2000-01-01 00:00:05';
117 set timestamp= unix_timestamp(@ts5);
118 update t set a= a + 1 where a < 100;
119 @@ -365,8 +365,8 @@
120 5 2000-01-01 00:00:04.000000 2000-01-01 00:00:05.000000
121 6 2000-01-01 00:00:05.000000 2000-01-01 00:00:06.000000
122 7 2000-01-01 00:00:06.000000 2000-01-01 00:00:07.000000
123 -8 2000-01-01 00:00:07.000000 2106-02-07 06:28:15.999999
124 -100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
125 +8 2000-01-01 00:00:07.000000 2038-01-19 03:14:07.999999
126 +100 2000-01-01 00:00:00.000000 2038-01-19 03:14:07.999999
127 prepare stmt from 'delete history from t before system_time ?';
128 execute stmt using @ts4;
129 select *, row_start, row_end from t for system_time all order by a;
130 @@ -375,36 +375,36 @@
131 5 2000-01-01 00:00:04.000000 2000-01-01 00:00:05.000000
132 6 2000-01-01 00:00:05.000000 2000-01-01 00:00:06.000000
133 7 2000-01-01 00:00:06.000000 2000-01-01 00:00:07.000000
134 -8 2000-01-01 00:00:07.000000 2106-02-07 06:28:15.999999
135 -100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
136 +8 2000-01-01 00:00:07.000000 2038-01-19 03:14:07.999999
137 +100 2000-01-01 00:00:00.000000 2038-01-19 03:14:07.999999
138 execute stmt using @ts5;
139 select *, row_start, row_end from t for system_time all order by a;
140 a row_start row_end
141 5 2000-01-01 00:00:04.000000 2000-01-01 00:00:05.000000
142 6 2000-01-01 00:00:05.000000 2000-01-01 00:00:06.000000
143 7 2000-01-01 00:00:06.000000 2000-01-01 00:00:07.000000
144 -8 2000-01-01 00:00:07.000000 2106-02-07 06:28:15.999999
145 -100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
146 +8 2000-01-01 00:00:07.000000 2038-01-19 03:14:07.999999
147 +100 2000-01-01 00:00:00.000000 2038-01-19 03:14:07.999999
148 execute stmt using @ts6;
149 select *, row_start, row_end from t for system_time all order by a;
150 a row_start row_end
151 6 2000-01-01 00:00:05.000000 2000-01-01 00:00:06.000000
152 7 2000-01-01 00:00:06.000000 2000-01-01 00:00:07.000000
153 -8 2000-01-01 00:00:07.000000 2106-02-07 06:28:15.999999
154 -100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
155 +8 2000-01-01 00:00:07.000000 2038-01-19 03:14:07.999999
156 +100 2000-01-01 00:00:00.000000 2038-01-19 03:14:07.999999
157 execute stmt using '2000-01-01 00:00:06';
158 select *, row_start, row_end from t for system_time all order by a;
159 a row_start row_end
160 6 2000-01-01 00:00:05.000000 2000-01-01 00:00:06.000000
161 7 2000-01-01 00:00:06.000000 2000-01-01 00:00:07.000000
162 -8 2000-01-01 00:00:07.000000 2106-02-07 06:28:15.999999
163 -100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
164 +8 2000-01-01 00:00:07.000000 2038-01-19 03:14:07.999999
165 +100 2000-01-01 00:00:00.000000 2038-01-19 03:14:07.999999
166 execute stmt using '2000-01-01 00:00:06.000001';
167 select *, row_start, row_end from t for system_time all order by a;
168 a row_start row_end
169 7 2000-01-01 00:00:06.000000 2000-01-01 00:00:07.000000
170 -8 2000-01-01 00:00:07.000000 2106-02-07 06:28:15.999999
171 -100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
172 +8 2000-01-01 00:00:07.000000 2038-01-19 03:14:07.999999
173 +100 2000-01-01 00:00:00.000000 2038-01-19 03:14:07.999999
174 set @ts8= '2000-01-01 00:00:08';
175 set timestamp= unix_timestamp(@ts8);
176 delete from t;
177 @@ -438,8 +438,8 @@
178 1 2000-01-01 00:00:00.000000 2000-01-01 00:00:01.000000
179 2 2000-01-01 00:00:01.000000 2000-01-01 00:00:02.000000
180 3 2000-01-01 00:00:02.000000 2000-01-01 00:00:03.000000
181 -4 2000-01-01 00:00:03.000000 2106-02-07 06:28:15.999999
182 -100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
183 +4 2000-01-01 00:00:03.000000 2038-01-19 03:14:07.999999
184 +100 2000-01-01 00:00:00.000000 2038-01-19 03:14:07.999999
185 execute stmt using @ts1, 0;
186 Warnings:
187 Warning 1292 Truncated incorrect DOUBLE value: '2000-01-01 00:00:01'
188 @@ -452,40 +452,40 @@
189 1 2000-01-01 00:00:00.000000 2000-01-01 00:00:01.000000
190 2 2000-01-01 00:00:01.000000 2000-01-01 00:00:02.000000
191 3 2000-01-01 00:00:02.000000 2000-01-01 00:00:03.000000
192 -4 2000-01-01 00:00:03.000000 2106-02-07 06:28:15.999999
193 -100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
194 +4 2000-01-01 00:00:03.000000 2038-01-19 03:14:07.999999
195 +100 2000-01-01 00:00:00.000000 2038-01-19 03:14:07.999999
196 execute stmt using @ts2, 0;
197 select *, row_start, row_end from t for system_time all order by a;
198 a row_start row_end
199 2 2000-01-01 00:00:01.000000 2000-01-01 00:00:02.000000
200 3 2000-01-01 00:00:02.000000 2000-01-01 00:00:03.000000
201 -4 2000-01-01 00:00:03.000000 2106-02-07 06:28:15.999999
202 -100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
203 +4 2000-01-01 00:00:03.000000 2038-01-19 03:14:07.999999
204 +100 2000-01-01 00:00:00.000000 2038-01-19 03:14:07.999999
205 execute stmt using @@timestamp, NULL;
206 select *, row_start, row_end from t for system_time all order by a;
207 a row_start row_end
208 2 2000-01-01 00:00:01.000000 2000-01-01 00:00:02.000000
209 3 2000-01-01 00:00:02.000000 2000-01-01 00:00:03.000000
210 -4 2000-01-01 00:00:03.000000 2106-02-07 06:28:15.999999
211 -100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
212 +4 2000-01-01 00:00:03.000000 2038-01-19 03:14:07.999999
213 +100 2000-01-01 00:00:00.000000 2038-01-19 03:14:07.999999
214 execute stmt using NULL, NULL;
215 select *, row_start, row_end from t for system_time all order by a;
216 a row_start row_end
217 2 2000-01-01 00:00:01.000000 2000-01-01 00:00:02.000000
218 3 2000-01-01 00:00:02.000000 2000-01-01 00:00:03.000000
219 -4 2000-01-01 00:00:03.000000 2106-02-07 06:28:15.999999
220 -100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
221 +4 2000-01-01 00:00:03.000000 2038-01-19 03:14:07.999999
222 +100 2000-01-01 00:00:00.000000 2038-01-19 03:14:07.999999
223 execute stmt using @ts2, 1;
224 select *, row_start, row_end from t for system_time all order by a;
225 a row_start row_end
226 3 2000-01-01 00:00:02.000000 2000-01-01 00:00:03.000000
227 -4 2000-01-01 00:00:03.000000 2106-02-07 06:28:15.999999
228 -100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
229 +4 2000-01-01 00:00:03.000000 2038-01-19 03:14:07.999999
230 +100 2000-01-01 00:00:00.000000 2038-01-19 03:14:07.999999
231 execute stmt using @ts2, @ts2;
232 select *, row_start, row_end from t for system_time all order by a;
233 a row_start row_end
234 -4 2000-01-01 00:00:03.000000 2106-02-07 06:28:15.999999
235 -100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
236 +4 2000-01-01 00:00:03.000000 2038-01-19 03:14:07.999999
237 +100 2000-01-01 00:00:00.000000 2038-01-19 03:14:07.999999
238 delete from t;
239 select *, row_start, row_end from t for system_time all order by a;
240 a row_start row_end