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

ALTER TABLE ENGINE doesn't copy data from SPIDER tables

    XMLWordPrintable

Details

    Description

      If I use the CONNECT engine to federate data from another table, and then issue something like the following on the CONNECT table:

      ALTER TABLE tbl1 ENGINE=InnoDB
      

      When converting from CONNECT to InnoDB, both the schema and table contents will be copied.

      If I instead use the SPIDER engine to federate the access, only the schema definition is modified with the previous SQL statement, but no data is copied into the local table, instead the table remain empty.

      My particular intent is to archive legacy data, moving it from one physical server to another after it has aged out.

      I would simply use the CONNECT engine itself, but it fails to support SETs, ENUMs, and NULLable indexes.

      Attachments

        Issue Links

          Activity

            People

              ycp Yuchen Pei
              darkain Vincent Milum Jr
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.