[MCOL-369] support virtual / computed columns in columnstore Created: 2016-10-19  Updated: 2022-11-05  Resolved: 2022-11-05

Status: Closed
Project: MariaDB ColumnStore
Component/s: N/A
Affects Version/s: 1.0.3
Fix Version/s: Icebox

Type: New Feature Priority: Major
Reporter: David Thompson (Inactive) Assignee: Todd Stoffel (Inactive)
Resolution: Won't Do Votes: 1
Labels: None

Epic Link: ColumnStore Compatibility Improvements

 Description   

If you declare a computed column in a table then an error is returned stating that these are not supported:
MariaDB [test]> create table test(i1 int, c1 varchar(7), d varchar(5) as (left(C1,5)) virtual) engine=columnstore;
ERROR 1910 (HY000): Columnstore storage engine does not support computed columns
MariaDB [test]> create table test(i1 int, c1 varchar(7), d varchar(5) as (left(C1,5)) persistent) engine=columnstore;
ERROR 1910 (HY000): Columnstore storage engine does not support computed columns
MariaDB [test]>

We should consider supporting these, for more details:
https://mariadb.com/kb/en/mariadb/virtual-computed-columns/

 Comments   
Comment by Todd Stoffel (Inactive) [ 2022-11-05 ]

Item is out of date. Closing due to inactivity. If you feel this was done in error please open a new ticket.

Generated at Thu Feb 08 02:20:33 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.