Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
5.5.24, 5.3.7, 5.2.12
-
None
-
None
Description
Trying to use an ENUM data type for a persistent virtual column results in an error
CREATE TABLE table1 (
a INT not null,
b char(2) not null,
c enum("Y","N") as (case when b = "aa" then "Y" else "N" end) persistent
);
ERROR 1033 (HY000): Incorrect information in file: './database/table1.frm'
Changing the datatype results in a successful table creation.
CREATE TABLE table1 (
a INT not null,
b char(2) not null,
c char(1) as (case when b = "aa" then "Y" else "N" end) persistent
);
Query OK, 0 rows affected (0.16 sec)