[MDEV-31066] Aria Engine Does Not Allow Index On Virtual Columns Created: 2023-04-17  Updated: 2023-04-18  Resolved: 2023-04-17

Status: Closed
Project: MariaDB Server
Component/s: Virtual Columns
Affects Version/s: 10.11.2
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Robert Dayton Assignee: Sergei Golubchik
Resolution: Duplicate Votes: 0
Labels: None
Environment:

Ubuntu

Issue Links:
Duplicate
duplicates MDEV-18812 Add support for generated indexed vir... Open
Relates
relates to MDEV-5800 indexes on virtual (not materialized)... Closed

 Description   

When I alter table from innodb engine to Aria engine, it does not allow the indexes on the virtual columns. I am also unable to add them directly on aria engine with alter table command.

ALTER TABLE `cases` ADD INDEX(`rthirdref`);

gives:

#1904 - Key/Index cannot be defined on a virtual generated column

`rthirdref` varchar(50) GENERATED ALWAYS AS (reverse(`thirdref`)) VIRTUAL,

InnoDB engine works fine.

 Comments   
Comment by Sergei Golubchik [ 2023-04-17 ]

this is MDEV-18812

Generated at Thu Feb 08 10:21:01 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.