Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-3727

LP:607147 - Maria storage engine not supported with virtual columns

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • None
    • None

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

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          philipstoev Philip Stoev (Inactive) added a comment -

          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; }
          philipstoev Philip Stoev (Inactive) added a comment - 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; }
          ratzpo Rasmus Johansson (Inactive) added a comment -

          Launchpad bug id: 607147

          ratzpo Rasmus Johansson (Inactive) added a comment - Launchpad bug id: 607147

          People

            sanja Oleksandr Byelkin
            philipstoev Philip Stoev (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.