MariaDB 10.3

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();


version()


10.3.28-MariaDB


CREATE OR REPLACE TABLE t (
x INT
) WITH SYSTEM VERSIONING;
ALTER TABLE t DROP SYSTEM VERSIONING;
show create table t


Table
Create Table


t
CREATE TABLE `t` (
  `x` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1


ALTER TABLE t ADD COLUMN ts TIMESTAMP(6) GENERATED ALWAYS AS ROW START
Duplicate ROW START column `ts`

ALTER TABLE t ADD COLUMN ts TIMESTAMP(6) GENERATED ALWAYS AS ROW START,
              ADD COLUMN te TIMESTAMP(6) GENERATED ALWAYS AS ROW END
Duplicate ROW START column `ts`