[MDEV-3727] LP:607147 - Maria storage engine not supported with virtual columns Created: 2010-07-19  Updated: 2015-02-02  Resolved: 2012-10-04

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Philip Stoev (Inactive) Assignee: Oleksandr Byelkin
Resolution: Fixed Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug607147.xml    

 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).

 Comments   
Comment by Philip Stoev (Inactive) [ 2010-07-19 ]

Re: Maria storage engine not supported with virtual columns
Here is the section of the code that causes the message to appear:

/* Check virtual columns against table's storage engine. */
if (share->vfields &&
((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

{ my_error(ER_UNSUPPORTED_ACTION_ON_VIRTUAL_COLUMN, MYF(0), "Specified storage engine"); error_reported= TRUE; goto err; }
Comment by Rasmus Johansson (Inactive) [ 2011-12-13 ]

Launchpad bug id: 607147

Generated at Thu Feb 08 06:50:46 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.