[MDEV-16130] wrong error message adding AS ROW START to versioned table Created: 2018-05-09  Updated: 2021-03-17  Resolved: 2019-10-09

Status: Closed
Project: MariaDB Server
Component/s: Data Definition - Alter Table, Versioned Tables
Affects Version/s: 10.3
Fix Version/s: 10.3.19, 10.4.9

Type: Bug Priority: Major
Reporter: Sergei Golubchik Assignee: Aleksey Midenkov
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Blocks
blocks MDEV-15408 Confusing error message upon ER_VERS_... Closed
Duplicate
duplicates MDEV-19654 Table `sbtest1` is not system-version... Closed
Relates
relates to MDEV-25172 Wrong error message for ADD COLUMN ..... Closed

 Description    

create table t1 (a int,
 
rs timestamp(6) as row start,
 
re timestamp(6) as row end,
 
period for system_time(rs,re)) with system versioning;
 
alter table t1 add column rss timestamp(6) as row start;


mysqltest: At line 6: query 'alter table t1 add column rss timestamp(6) as row start' failed: 4124: Table `t1` is not system-versioned


Generated at Thu Feb 08 08:26:36 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.