Maria storage engine not supported with virtual columns
Bug #607147 reported by
Philip Stoev
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Fix Released
|
High
|
Oleksandr "Sanja" Byelkin |
Bug Description
The Maria storage engine is not supported for virtual columns:
mysql> CREATE TABLE IF NOT EXISTS X ( f1 INTEGER, v1 integer AS (f1) VIRTUAL ) engine=Maria;
ERROR 1646 (HY000): 'Specified storage engine' is not yet supported for computed columns
Also, the error message could be improved, at least to include the name of the storage engine in question ( in case it is not specified as part of the CREATE TABLE statement, but instead comes from a server-wide or a session default).
Changed in maria: | |
importance: | Undecided → High |
Changed in maria: | |
milestone: | none → 5.2 |
Changed in maria: | |
assignee: | nobody → Michael Widenius (monty) |
Changed in maria: | |
assignee: | Michael Widenius (monty) → Oleksandr "Sanja" Byelkin (sanja-byelkin) |
Changed in maria: | |
status: | New → Fix Committed |
Changed in maria: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
Here is the section of the code that causes the message to appear:
/* Check virtual columns against table's storage engine. */
((outparam- >file &&
!outparam- >file-> check_if_ supported_ virtual_ columns( )) ||
(!outparam- >file && share->db_type() &&
share- >db_type( )->db_type == DB_TYPE_CSV_DB))) // Workaround for CSV error(ER_ UNSUPPORTED_ ACTION_ ON_VIRTUAL_ COLUMN,
MYF( 0),
" Specified storage engine");
if (share->vfields &&
{
my_
error_reported= TRUE;
goto err;
}