Maria storage engine not supported with virtual columns

[Philip Stoev]

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

[Philip Stoev (pstoev-askmonty)]

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;
  }