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

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

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Affects Version/s: None
        • Fix Version/s: None
        • Component/s: None
        • Labels:

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

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                philipstoev Philip Stoev 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; }
                Show
                philipstoev Philip Stoev 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; }
                Hide
                Permalink
                ratzpo Rasmus Johansson added a comment -

                Launchpad bug id: 607147

                Show
                ratzpo Rasmus Johansson added a comment - Launchpad bug id: 607147

                  People

                  • Assignee:
                    sanja Oleksandr Byelkin
                    Reporter:
                    philipstoev Philip Stoev
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    0 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: