Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL)
-
None
Description
INSTALL SONAME 'ha_federatedx'; |
|
eval CREATE SERVER fedlink FOREIGN DATA WRAPPER mysql OPTIONS (USER 'root', HOST '127.0.0.1', DATABASE 'test1', PORT $MASTER_MYPORT); |
|
create database test1; |
create table test1.t1 (a int, b int); |
create table test1.t2 (a int, b int); |
|
CREATE TABLE t1 ENGINE=FEDERATED connection='fedlink/t1'; |
CREATE TABLE t2 ENGINE=FEDERATED connection='fedlink/t2'; |
|
set global federated_pushdown=1; |
|
insert into t1 values (1,1),(2,2); |
insert into t2 values (1,1),(2,2),(3,3); |
|
update t1,t2 set t1.a=5 where t1.a=t2.a; |
|
|
DROP TABLE t1,t2,test1.t1,test1.t2; |
UNINSTALL SONAME 'ha_federatedx'; |