[MDEV-26889] Allow create index on system versioning columns row_start and row_end Created: 2021-10-22  Updated: 2021-10-25  Resolved: 2021-10-25

Status: Closed
Project: MariaDB Server
Component/s: Data Definition - Alter Table
Fix Version/s: N/A

Type: Task Priority: Major
Reporter: Edward Stoever Assignee: Sergei Golubchik
Resolution: Won't Fix Votes: 0
Labels: None


 Description    

MariaDB [tdb]> alter table test_versioning ADD SYSTEM VERSIONING;
 
MariaDB [tdb]> alter table test_versioning add index rs_re_index(row_start,row_end);
 
ERROR 1072 (42000): Key column 'row_start' doesn't exist in table
 
MariaDB [tdb]>

Can this feature be added?

 Comments   
Comment by Sergei Golubchik [ 2021-10-25 ]

No, it cannot be added. If you haven't created a column — it doesn't exist. If the column doesn't exist — you cannot index it.

If you want to index a column, you have to create the column to index.

Comment by Edward Stoever [ 2021-10-25 ]

Thank you Sergei!!!

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