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

variable federated_pushdown is not documented and buggy

Details

    Description

      The variable federated_pushdown is not well documented:

      https://mariadb.com/kb/en/about-federatedx/
      https://mariadb.com/kb/en/server-system-variables/
      http://lists.askmonty.org/pipermail/commits/2019-February/013402.html
      https://jira.mariadb.org/browse/MDEV-23803

      The only information found was this:

      storage/federatedx/federatedx_pushdown.cc:

      /*
      This is a quick a dirty implemention of the derived_handler and select_handler
      interfaces to be used to push select queries and the queries specifying
      derived tables into FEDERATEDX engine.
      The functions
      create_federatedx_derived_handler and
      create_federatedx_select_handler
      that return the corresponding interfaces for pushdown capabilities do
      not check a lot of things. In particular they do not check that the tables
      of the pushed queries belong to the same foreign server.

      The implementation is provided purely for testing purposes.
      The pushdown capabilities are enabled by turning on the plugin system
      variable federated_pushdown:
      set global federated_pushdown=1;
      */

      It looks like it works like this:

      set global federated_pushdown=off;
      select id, data from test_fed where id = 1;
      -> Query on remote system: SELECT `id`, `data`, `ts` FROM `test` WHERE (`id` = 1)

      set global federated_pushdown=on;
      select id, data from test_fed where id = 1;
      -> Query on remote system: select id, data from test_fed where id = 1

      But this miserably failed with the following error (which is the/a bug):

      ERROR 1030 (HY000): Got error 10000 "Unknown error 10000" from storage engine FEDERATED

      Would be a cool feature to reduce traffic between the 2 systems, if it worked.

      Attachments

        Activity

          digdilem Simon Avery added a comment -

          Surprising that this has been open for two years now, and still the highest google hit for "mariadb" + "federated_pushdown" brings you here.

          I was looking for information on this variable after upgrading to 10.6 and finding it in SHOW VARIABLES. It is not mentioned with the rest of the mariadb vars at https://mariadb.com/kb/en/server-system-variables/

          digdilem Simon Avery added a comment - Surprising that this has been open for two years now, and still the highest google hit for "mariadb" + "federated_pushdown" brings you here. I was looking for information on this variable after upgrading to 10.6 and finding it in SHOW VARIABLES. It is not mentioned with the rest of the mariadb vars at https://mariadb.com/kb/en/server-system-variables/

          FederatedX is possibly not top on the MariaDB priority list. If this issue is split into a docu issue and a bug a least the docu issue is possibly solved. But I cannot do this. Somebody of MariaDB has to do it...

          oli Oli Sennhauser added a comment - FederatedX is possibly not top on the MariaDB priority list. If this issue is split into a docu issue and a bug a least the docu issue is possibly solved. But I cannot do this. Somebody of MariaDB has to do it...

          People

            Unassigned Unassigned
            oli Oli Sennhauser
            Votes:
            1 Vote for this issue
            Watchers:
            2 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.