[#MDEV-25172] Wrong error message for ADD COLUMN .. AS ROW START

[MDEV-25172] Wrong error message for ADD COLUMN .. AS ROW START Created: 2021-03-17 Updated: 2021-03-31 Resolved: 2021-03-31
Status:	Closed
Project:	MariaDB Server
Component/s:	Versioned Tables
Affects Version/s:	10.3.28, 10.4.18, 10.5.9, 10.3, 10.4, 10.5
Fix Version/s:	10.3.29, 10.4.19, 10.5.10

Type:

Bug

Priority:

Major

Reporter:

Daniel Black

Assignee:

Aleksey Midenkov

Resolution:

Fixed

Votes:

Labels:

None

Issue Links:

Relates
relates to	~~MDEV-16130~~	wrong error message adding AS ROW STA...	Closed

Description

Not quite all dropped:

CREATE OR REPLACE TABLE t (

x INT

) WITH SYSTEM VERSIONING;

ALTER TABLE t DROP SYSTEM VERSIONING;

ALTER TABLE t ADD COLUMN ts TIMESTAMP(6) GENERATED ALWAYS AS ROW START;

Last alter table results in:

Duplicate ROW START column `ts`

Same error occurs on fresh table. SO its just an odd misleading error message.

Comments

Comment by Alice Sherepa [ 2021-03-17 ]

MariaDB [test]> create table t(i int);

Query OK, 0 rows affected (0.151 sec)

MariaDB [test]> ALTER TABLE t ADD COLUMN ts TIMESTAMP(6) GENERATED ALWAYS AS ROW START;

ERROR 4134 (HY000): Duplicate ROW START column `ts`

Comment by Nikita Malyavin [ 2021-03-25 ]

oktopush

Generated at Thu Feb 08 09:35:41 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.