Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
10.3(EOL)
-
None
Description
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.
Attachments
Issue Links
- relates to
-
MDEV-14702 Not helpful error message upon ER_UNSUPPORTED_ACTION_ON_GENERATED_COLUMN
- Open