[MDEV-24563] variable federated_pushdown is not documented and buggy Created: 2021-01-11  Updated: 2023-01-11

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - Federated
Affects Version/s: 10.5.8
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Oli Sennhauser Assignee: Unassigned
Resolution: Unresolved Votes: 1
Labels: federatedx
Environment:

Linux, n.a.



 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.



 Comments   
Comment by Simon Avery [ 2023-01-11 ]

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/

Comment by Oli Sennhauser [ 2023-01-11 ]

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

Generated at Thu Feb 08 09:30:55 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.