create or replace table t1 (i int, j int as (i), s timestamp(6) as row start, e timestamp(6) as row end, period for system_time(s,e)) with system versioning;
|
|
alter table t1 modify s timestamp(6) as row start;
|
ALTER returns the error:
MariaDB [test]> alter table t1 modify s timestamp(6) as row start;
|
ERROR 1907 (HY000): This is not yet supported for generated columns
|
This is strange, because ALTER doesn't even modify anything; and even more strange, because ALTER on the same table for a generated column not related to versioning works all right:
MariaDB [test]> alter table t1 modify j int as (i);
|
Query OK, 0 rows affected (0.00 sec)
|
Records: 0 Duplicates: 0 Warnings: 0
|
It would be understandable if it said that ALTER is not supported for versioning columns (if that's indeed so), but the error as it is now is wrong.
Bug
Minor
