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

SPIDER table error when using GENERATED VIRTUAL columns

    XMLWordPrintable

Details

    Description

      The SPIDER engine doesn't recognize GENERATED VIRTUAL columns, and is still trying to push down the column to the remote backend server. The SPIDER engine, much like other engines, should ignore the GENERATED VIRTUAL column from the storage backend itself.

      CREATE TABLE `tbl` (
        `id` int,
        `testing` int as (1),
      ) ENGINE=SPIDER COMMENT='wrapper "mysql", srv "srv1"';
       
      select * from tbl;
       
      ERROR 1054 (42S22): Unknown column 't0.testing' in 'field list'
      

      Attachments

        Activity

          People

            ycp Yuchen Pei
            darkain Vincent Milum Jr
            Votes:
            1 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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