|
CREATE TABLE t1 (a DATE DEFAULT '2000-01-01', b DATE DEFAULT '2020-01-01', PERIOD FOR app(a,b));
|
INSERT INTO t1 VALUES ('2000-01-01','2010-01-01'),('2011-01-01','2020-01-01');
|
DELETE FROM t1 FOR PORTION OF app FROM '2004-01-01 12:00:00' TO '2020-02-19 19:50:10';
|
|
# Cleanup
|
DROP TABLE t1;
|
|
10.4 6a634576
|
mysqltest: At line 3: query 'DELETE FROM t1 FOR PORTION OF app FROM '2004-01-01 12:00:00' TO '2020-02-19 19:50:10'' failed: 1030: Got error 3 "No such process" from storage engine MyISAM
|
Reproducible on 10.4, 10.5, debug and non-debug alike, with at least InnoDB and MyISAM.
|