Debian Codegraph @

mysql-test/suite/versioning/r/delete_history.result

raw
1 call mtr.add_suppression("need more HISTORY partitions");
2 create table t (a int);
3 delete history from t before system_time now();
4 ERROR HY000: Table `t` is not system-versioned
5 create or replace table t (
6 a int,
7 row_start SYS_TYPE as row start invisible,
8 row_end SYS_TYPE as row end invisible,
9 period for system_time (row_start, row_end))
10 with system versioning;
11 insert into t values (1);
12 update t set a=2;
13 set @test = 'correct';
14 create trigger trg_before before delete on t for each row set @test = 'incorrect';
15 create trigger trg_after after delete on t for each row set @test = 'incorrect';
16 delete history from t;
17 select @test from t;
18 @test
19 correct
20 drop table t;
21 create or replace table t (
22 a int,
23 row_start SYS_TYPE as row start invisible,
24 row_end SYS_TYPE as row end invisible,
25 period for system_time (row_start, row_end))
26 with system versioning;
27 insert into t values (1), (2);
28 update t set a=11 where a=1;
29 set @ts1=now(6);
30 update t set a=22 where a=2;
31 select * from t for system_time all;
32 a
33 11
34 22
35 1
36 2
37 delete history from t before system_time timestamp @ts1;
38 select * from t for system_time all;
39 a
40 11
41 22
42 2
43 prepare stmt from 'delete history from t';
44 execute stmt;
45 drop prepare stmt;
46 select * from t for system_time all;
47 a
48 11
49 22
50 delete from t;
51 create or replace procedure truncate_sp()
52 begin
53 delete history from t before system_time timestamp now(6);
54 end~~
55 call truncate_sp;
56 select * from t for system_time all;
57 a
58 drop procedure truncate_sp;
59 # Truncate partitioned
60 create or replace table t (a int) with system versioning
61 partition by system_time limit 1 partitions 3;
62 insert into t values (1);
63 update t set a= 2;
64 update t set a= 3;
65 Warnings:
66 Warning 4114 Versioned table `test`.`t`: last HISTORY partition (`p1`) is out of LIMIT, need more HISTORY partitions
67 # You see warning above ^
68 delete history from t;
69 select * from t for system_time all;
70 a
71 3
72 # VIEW
73 create or replace table t (
74 i int,
75 row_start SYS_TYPE as row start invisible,
76 row_end SYS_TYPE as row end invisible,
77 period for system_time (row_start, row_end))
78 with system versioning;
79 delete history from t;
80 create or replace view v as select * from t;
81 delete history from v;
82 ERROR 42S02: 'v' is a view
83 create or replace table t (i int);
84 delete history from t;
85 ERROR HY000: Table `t` is not system-versioned
86 create or replace view v as select * from t;
87 delete history from v;
88 ERROR 42S02: 'v' is a view
89 prepare stmt from 'delete history from t';
90 ERROR HY000: Table `t` is not system-versioned
91 drop table t;
92 drop view v;
93 create or replace table t (i int);
94 create or replace view v as select * from t;
95 drop table v;
96 ERROR 42S02: 'test.v' is a view
97 lock table v write;
98 delete history from v before system_time now(6);
99 ERROR 42S02: 'v' is a view
100 unlock tables;
101 drop view v;
102 drop table t;
103 create table t1 (i int) with system versioning;
104 create procedure pr() delete history from t1 before system_time now();
105 call pr;
106 call pr;
107 drop procedure pr;
108 drop table t1;
109 # MDEV-15966 Behavior for TRUNCATE versioned table is not documented and not covered by tests
110 create or replace table t1 (id int);
111 create or replace table t2 (id int) with system versioning;
112 # force cleaning table shares
113 flush tables t1, t2;
114 truncate table t1;
115 truncate table t2;
116 ERROR HY000: System-versioned tables do not support TRUNCATE TABLE
117 # fetch table shares
118 describe t1;
119 Field Type Null Key Default Extra
120 id int(11) YES NULL
121 describe t2;
122 Field Type Null Key Default Extra
123 id int(11) YES NULL
124 truncate table t1;
125 truncate table t2;
126 ERROR HY000: System-versioned tables do not support TRUNCATE TABLE
127 # enter locked tables mode
128 lock tables t1 WRITE, t2 WRITE;
129 truncate t1;
130 truncate t2;
131 ERROR HY000: System-versioned tables do not support TRUNCATE TABLE
132 unlock tables;
133 drop table t2;
134 #
135 # MDEV-19814 Assertion `update->n_fields < ulint(table->n_cols + table->n_v_cols)' on DELETE HISTORY
136 #
137 create or replace table t1 (
138 f varchar(1),
139 row_start SYS_TYPE as row start,
140 row_end SYS_TYPE as row end,
141 period for system_time (row_start, row_end))
142 with system versioning;
143 insert into t1 (f) values ('a'), ('b'), ('c'), ('d'), ('e'), ('f'), ('g'), ('h');
144 delete from t1;
145 delete history from t1;
146 drop table t1;
147 #
148 # MDEV-20186 Wrong result or Assertion on INSERT after DELETE HISTORY
149 #
150 create or replace table t1 (a int check (a > 0)) with system versioning;
151 delete history from t1;
152 insert into t1 values (1);
153 select * from t1;
154 a
155 1
156 drop table t1;
157 #
158 # MDEV-25468 DELETE HISTORY may delete current data on system-versioned table
159 #
160 create or replace table t1 (x int) with system versioning;
161 insert into t1 values (1);
162 delete history from t1 before system_time '2039-01-01 23:00';
163 select * from t1;
164 x
165 1
166 explain extended delete history from t1 before system_time '2039-01-01 23:00';
167 id select_type table type possible_keys key key_len ref rows filtered Extra
168 1 SIMPLE t1 ALL NULL NULL NULL NULL 1 100.00 Using where
169 Warnings:
170 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`)
171 create or replace procedure p() delete history from t1 before system_time '2039-01-01 23:00';
172 call p;
173 select * from t1;
174 x
175 1
176 call p;
177 select * from t1;
178 x
179 1
180 drop procedure p;
181 prepare stmt from "delete history from t1 before system_time '2039-01-01 23:00'";
182 execute stmt;
183 select * from t1;
184 x
185 1
186 execute stmt;
187 select * from t1;
188 x
189 1
190 drop prepare stmt;
191 drop table t1;
192 #
193 # MDEV-25004 Missing row in FTS_DOC_ID_INDEX during DELETE HISTORY
194 #
195 create table t1 (a integer, c0 varchar(255), fulltext key (c0))
196 with system versioning engine innodb stats_persistent=0;
197 set system_versioning_alter_history= keep;
198 alter table t1 drop system versioning;
199 alter table t1 add system versioning;
200 insert into t1 values (1, 'politician');
201 update t1 set c0= 'criminal';
202 InnoDB 0 transactions not purged
203 delete history from t1;
204 drop table t1;
205 create table t1 (id int primary key, ftx varchar(255))
206 with system versioning engine innodb stats_persistent=0;
207 insert into t1 values (1, 'c');
208 delete from t1;
209 alter table t1 add fulltext key(ftx);
210 drop table t1;
211 #
212 # MDEV-28201 Server crashes upon SHOW ANALYZE/EXPLAIN FORMAT=JSON
213 #
214 CREATE TABLE t1 (a INT) WITH SYSTEM VERSIONING;
215 CREATE ALGORITHM=TEMPTABLE VIEW v1 AS SELECT * FROM t1;
216 SET optimizer_trace= 'enabled=on';
217 DELETE HISTORY FROM v1 BEFORE SYSTEM_TIME '2021-01-01';
218 ERROR HY000: The target table v1 of the DELETE is not updatable
219 DELETE HISTORY FROM v1;
220 ERROR HY000: The target table v1 of the DELETE is not updatable
221 DROP VIEW v1;
222 DROP TABLE t1;
223 # End of 10.4 tests
224 #
225 # MDEV-33470 Unique hash index is broken on DML for system-versioned table
226 #
227 create or replace table t (
228 c int, unique (c) using hash)
229 with system versioning;
230 insert into t values (0);
231 delete from t;
232 delete history from t;
233 drop table t;
234 # End of 10.5 tests
235 #
236 # MDEV-17554 Auto-create new partition for system versioned tables with history partitioned by INTERVAL/LIMIT
237 #
238 # Don't auto-create new partition on DELETE HISTORY:
239 set timestamp= unix_timestamp('2000-01-01 00:00:00');
240 create or replace table t (a int) with system versioning
241 partition by system_time interval 1 hour auto;
242 set timestamp= unix_timestamp('2000-01-01 10:00:00');
243 delete history from t;
244 set timestamp= default;
245 show create table t;
246 Table Create Table
247 t CREATE TABLE `t` (
248 `a` int(11) DEFAULT NULL
249 ) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci WITH SYSTEM VERSIONING
250 PARTITION BY SYSTEM_TIME INTERVAL 1 HOUR STARTS TIMESTAMP'2000-01-01 00:00:00' AUTO
251 PARTITIONS 2
252 drop table t;
253 # End of 10.9 tests
254 #
255 # MDEV-34046 Parameterized PS converts error to warning, causes replication problems
256 #
257 create table t (a int) with system versioning;
258 set timestamp= unix_timestamp('2000-01-01 00:00:00');
259 insert into t values (1), (100);
260 delete history from t before system_time @@timestamp;
261 ERROR HY000: Illegal parameter data type double for operation 'FOR SYSTEM_TIME'
262 execute immediate "delete history from t before system_time @@timestamp";
263 ERROR HY000: Illegal parameter data type double for operation 'FOR SYSTEM_TIME'
264 execute immediate "delete history from t before system_time ?" using @@timestamp;
265 ERROR HY000: Illegal parameter data type double for operation 'FOR SYSTEM_TIME'
266 set @ts1= '2000-01-01 00:00:01';
267 set timestamp= unix_timestamp(@ts1);
268 update t set a= a + 1 where a < 100;
269 set @ts2= '2000-01-01 00:00:02';
270 set timestamp= unix_timestamp(@ts2);
271 update t set a= a + 1 where a < 100;
272 set @ts3= '2000-01-01 00:00:03';
273 set timestamp= unix_timestamp(@ts3);
274 select *, row_start, row_end from t for system_time all order by a;
275 a row_start row_end
276 1 2000-01-01 00:00:00.000000 2000-01-01 00:00:01.000000
277 2 2000-01-01 00:00:01.000000 2000-01-01 00:00:02.000000
278 3 2000-01-01 00:00:02.000000 2106-02-07 06:28:15.999999
279 100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
280 select *, row_start, row_end from t for system_time as of @ts1;
281 a row_start row_end
282 100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
283 2 2000-01-01 00:00:01.000000 2000-01-01 00:00:02.000000
284 execute immediate "select *, row_start, row_end from t for system_time as of ?" using @ts1;
285 a row_start row_end
286 100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
287 2 2000-01-01 00:00:01.000000 2000-01-01 00:00:02.000000
288 prepare stmt from 'select *, row_start, row_end from t for system_time as of ?';
289 execute stmt using @ts1;
290 a row_start row_end
291 100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
292 2 2000-01-01 00:00:01.000000 2000-01-01 00:00:02.000000
293 Execute stmt using @ts1;
294 a row_start row_end
295 100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
296 2 2000-01-01 00:00:01.000000 2000-01-01 00:00:02.000000
297 select *, row_start, row_end from t for system_time as of @ts2;
298 a row_start row_end
299 3 2000-01-01 00:00:02.000000 2106-02-07 06:28:15.999999
300 100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
301 execute immediate "select *, row_start, row_end from t for system_time as of ?" using @ts2;
302 a row_start row_end
303 3 2000-01-01 00:00:02.000000 2106-02-07 06:28:15.999999
304 100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
305 execute stmt using @ts2;
306 a row_start row_end
307 3 2000-01-01 00:00:02.000000 2106-02-07 06:28:15.999999
308 100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
309 Execute stmt using @ts2;
310 a row_start row_end
311 3 2000-01-01 00:00:02.000000 2106-02-07 06:28:15.999999
312 100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
313 drop prepare stmt;
314 execute immediate "delete history from t before system_time @ts1";
315 select *, row_start, row_end from t for system_time all order by a;
316 a row_start row_end
317 1 2000-01-01 00:00:00.000000 2000-01-01 00:00:01.000000
318 2 2000-01-01 00:00:01.000000 2000-01-01 00:00:02.000000
319 3 2000-01-01 00:00:02.000000 2106-02-07 06:28:15.999999
320 100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
321 execute immediate "delete history from t before system_time @ts2";
322 select *, row_start, row_end from t for system_time all order by a;
323 a row_start row_end
324 2 2000-01-01 00:00:01.000000 2000-01-01 00:00:02.000000
325 3 2000-01-01 00:00:02.000000 2106-02-07 06:28:15.999999
326 100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
327 execute immediate "delete history from t before system_time ?" using @ts3;
328 select *, row_start, row_end from t for system_time all order by a;
329 a row_start row_end
330 3 2000-01-01 00:00:02.000000 2106-02-07 06:28:15.999999
331 100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
332 execute immediate "delete history from t before system_time ?" using @ts3;
333 select *, row_start, row_end from t for system_time all order by a;
334 a row_start row_end
335 3 2000-01-01 00:00:02.000000 2106-02-07 06:28:15.999999
336 100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
337 update t set a= a + 1 where a < 100;
338 set @ts4= '2000-01-01 00:00:04';
339 set timestamp= unix_timestamp(@ts4);
340 update t set a= a + 1 where a < 100;
341 select *, row_start, row_end from t for system_time all order by a;
342 a row_start row_end
343 3 2000-01-01 00:00:02.000000 2000-01-01 00:00:03.000000
344 4 2000-01-01 00:00:03.000000 2000-01-01 00:00:04.000000
345 5 2000-01-01 00:00:04.000000 2106-02-07 06:28:15.999999
346 100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
347 execute immediate "delete history from t before system_time ?" using '2000-01-01 00:00:04';
348 select *, row_start, row_end from t for system_time all order by a;
349 a row_start row_end
350 4 2000-01-01 00:00:03.000000 2000-01-01 00:00:04.000000
351 5 2000-01-01 00:00:04.000000 2106-02-07 06:28:15.999999
352 100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
353 set @ts5= '2000-01-01 00:00:05';
354 set timestamp= unix_timestamp(@ts5);
355 update t set a= a + 1 where a < 100;
356 set @ts6= '2000-01-01 00:00:06';
357 set timestamp= unix_timestamp(@ts6);
358 update t set a= a + 1 where a < 100;
359 set @ts7= '2000-01-01 00:00:07';
360 set timestamp= unix_timestamp(@ts7);
361 update t set a= a + 1 where a < 100;
362 select *, row_start, row_end from t for system_time all order by a;
363 a row_start row_end
364 4 2000-01-01 00:00:03.000000 2000-01-01 00:00:04.000000
365 5 2000-01-01 00:00:04.000000 2000-01-01 00:00:05.000000
366 6 2000-01-01 00:00:05.000000 2000-01-01 00:00:06.000000
367 7 2000-01-01 00:00:06.000000 2000-01-01 00:00:07.000000
368 8 2000-01-01 00:00:07.000000 2106-02-07 06:28:15.999999
369 100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
370 prepare stmt from 'delete history from t before system_time ?';
371 execute stmt using @ts4;
372 select *, row_start, row_end from t for system_time all order by a;
373 a row_start row_end
374 4 2000-01-01 00:00:03.000000 2000-01-01 00:00:04.000000
375 5 2000-01-01 00:00:04.000000 2000-01-01 00:00:05.000000
376 6 2000-01-01 00:00:05.000000 2000-01-01 00:00:06.000000
377 7 2000-01-01 00:00:06.000000 2000-01-01 00:00:07.000000
378 8 2000-01-01 00:00:07.000000 2106-02-07 06:28:15.999999
379 100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
380 execute stmt using @ts5;
381 select *, row_start, row_end from t for system_time all order by a;
382 a row_start row_end
383 5 2000-01-01 00:00:04.000000 2000-01-01 00:00:05.000000
384 6 2000-01-01 00:00:05.000000 2000-01-01 00:00:06.000000
385 7 2000-01-01 00:00:06.000000 2000-01-01 00:00:07.000000
386 8 2000-01-01 00:00:07.000000 2106-02-07 06:28:15.999999
387 100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
388 execute stmt using @ts6;
389 select *, row_start, row_end from t for system_time all order by a;
390 a row_start row_end
391 6 2000-01-01 00:00:05.000000 2000-01-01 00:00:06.000000
392 7 2000-01-01 00:00:06.000000 2000-01-01 00:00:07.000000
393 8 2000-01-01 00:00:07.000000 2106-02-07 06:28:15.999999
394 100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
395 execute stmt using '2000-01-01 00:00:06';
396 select *, row_start, row_end from t for system_time all order by a;
397 a row_start row_end
398 6 2000-01-01 00:00:05.000000 2000-01-01 00:00:06.000000
399 7 2000-01-01 00:00:06.000000 2000-01-01 00:00:07.000000
400 8 2000-01-01 00:00:07.000000 2106-02-07 06:28:15.999999
401 100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
402 execute stmt using '2000-01-01 00:00:06.000001';
403 select *, row_start, row_end from t for system_time all order by a;
404 a row_start row_end
405 7 2000-01-01 00:00:06.000000 2000-01-01 00:00:07.000000
406 8 2000-01-01 00:00:07.000000 2106-02-07 06:28:15.999999
407 100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
408 set @ts8= '2000-01-01 00:00:08';
409 set timestamp= unix_timestamp(@ts8);
410 delete from t;
411 select *, row_start, row_end from t for system_time all order by a;
412 a row_start row_end
413 7 2000-01-01 00:00:06.000000 2000-01-01 00:00:07.000000
414 8 2000-01-01 00:00:07.000000 2000-01-01 00:00:08.000000
415 100 2000-01-01 00:00:00.000000 2000-01-01 00:00:08.000000
416 execute immediate "delete history from t before system_time from_unixtime(?)" using @@timestamp;
417 select *, row_start, row_end from t for system_time all order by a;
418 a row_start row_end
419 8 2000-01-01 00:00:07.000000 2000-01-01 00:00:08.000000
420 100 2000-01-01 00:00:00.000000 2000-01-01 00:00:08.000000
421 execute stmt using '2020-01-01';
422 select *, row_start, row_end from t for system_time all order by a;
423 a row_start row_end
424 drop prepare stmt;
425 set timestamp= unix_timestamp('2000-01-01 00:00:00');
426 insert into t values (1), (100);
427 set @ts1= '2000-01-01 00:00:01';
428 set timestamp= unix_timestamp(@ts1);
429 update t set a= a + 1 where a < 100;
430 set timestamp= @@timestamp + 1;
431 set @ts2= @@timestamp;
432 update t set a= a + 1 where a < 100;
433 set timestamp= @@timestamp + 1;
434 update t set a= a + 1 where a < 100;
435 prepare stmt from 'delete history from t before system_time from_unixtime(? + ?)';
436 select *, row_start, row_end from t for system_time all order by a;
437 a row_start row_end
438 1 2000-01-01 00:00:00.000000 2000-01-01 00:00:01.000000
439 2 2000-01-01 00:00:01.000000 2000-01-01 00:00:02.000000
440 3 2000-01-01 00:00:02.000000 2000-01-01 00:00:03.000000
441 4 2000-01-01 00:00:03.000000 2106-02-07 06:28:15.999999
442 100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
443 execute stmt using @ts1, 0;
444 Warnings:
445 Warning 1292 Truncated incorrect DOUBLE value: '2000-01-01 00:00:01'
446 Warning 1292 Truncated incorrect DOUBLE value: '2000-01-01 00:00:01'
447 Warning 1292 Truncated incorrect DOUBLE value: '2000-01-01 00:00:01'
448 Warning 1292 Truncated incorrect DOUBLE value: '2000-01-01 00:00:01'
449 Warning 1292 Truncated incorrect DOUBLE value: '2000-01-01 00:00:01'
450 select *, row_start, row_end from t for system_time all order by a;
451 a row_start row_end
452 1 2000-01-01 00:00:00.000000 2000-01-01 00:00:01.000000
453 2 2000-01-01 00:00:01.000000 2000-01-01 00:00:02.000000
454 3 2000-01-01 00:00:02.000000 2000-01-01 00:00:03.000000
455 4 2000-01-01 00:00:03.000000 2106-02-07 06:28:15.999999
456 100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
457 execute stmt using @ts2, 0;
458 select *, row_start, row_end from t for system_time all order by a;
459 a row_start row_end
460 2 2000-01-01 00:00:01.000000 2000-01-01 00:00:02.000000
461 3 2000-01-01 00:00:02.000000 2000-01-01 00:00:03.000000
462 4 2000-01-01 00:00:03.000000 2106-02-07 06:28:15.999999
463 100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
464 execute stmt using @@timestamp, NULL;
465 select *, row_start, row_end from t for system_time all order by a;
466 a row_start row_end
467 2 2000-01-01 00:00:01.000000 2000-01-01 00:00:02.000000
468 3 2000-01-01 00:00:02.000000 2000-01-01 00:00:03.000000
469 4 2000-01-01 00:00:03.000000 2106-02-07 06:28:15.999999
470 100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
471 execute stmt using NULL, NULL;
472 select *, row_start, row_end from t for system_time all order by a;
473 a row_start row_end
474 2 2000-01-01 00:00:01.000000 2000-01-01 00:00:02.000000
475 3 2000-01-01 00:00:02.000000 2000-01-01 00:00:03.000000
476 4 2000-01-01 00:00:03.000000 2106-02-07 06:28:15.999999
477 100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
478 execute stmt using @ts2, 1;
479 select *, row_start, row_end from t for system_time all order by a;
480 a row_start row_end
481 3 2000-01-01 00:00:02.000000 2000-01-01 00:00:03.000000
482 4 2000-01-01 00:00:03.000000 2106-02-07 06:28:15.999999
483 100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
484 execute stmt using @ts2, @ts2;
485 select *, row_start, row_end from t for system_time all order by a;
486 a row_start row_end
487 4 2000-01-01 00:00:03.000000 2106-02-07 06:28:15.999999
488 100 2000-01-01 00:00:00.000000 2106-02-07 06:28:15.999999
489 delete from t;
490 select *, row_start, row_end from t for system_time all order by a;
491 a row_start row_end
492 4 2000-01-01 00:00:03.000000 2000-01-01 00:00:03.000000
493 100 2000-01-01 00:00:00.000000 2000-01-01 00:00:03.000000
494 execute stmt using @ts2, @ts2;
495 select *, row_start, row_end from t for system_time all order by a;
496 a row_start row_end
497 drop prepare stmt;
498 drop table t;
499 set timestamp= default;
500 #
501 # MDEV-37164 Assertion `vers_conditions.delete_history' failed upon PREPARE
502 #
503 create table t (a int) with system versioning;
504 insert into t values (1),(2);
505 prepare stmt from 'select * from t for system_time as of timestamp ?';
506 drop table t;
507 # End of 10.11 tests