Details
-
New Feature
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
-
Server version: 10.5.6
MCS version: 1.5.4-1
Description
Like InnoDB engine, Columnstore should also support generated columns.
CREATE TABLE t1(c1 INT, c2 INT, c3 INT GENERATED ALWAYS AS (c1 + c2) ) ENGINE=Columnstore;
ERROR 1910 (HY000): Columnstore storage engine does not support generated columns
CREATE TABLE t1(c1 INT, c2 INT, c3 INT GENERATED ALWAYS AS (c1 + c2) ) ENGINE=Innodb; Query OK, 0 rows affected (0.015 sec)