Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
-
None
Description
MariaDB [test]> create or replace table t1 (i int);
|
Query OK, 0 rows affected (0,046 sec)
|
|
MariaDB [test]> insert into t1 values (1),(2);
|
Query OK, 2 rows affected (0,014 sec)
|
Records: 2 Duplicates: 0 Warnings: 0
|
|
MariaDB [test]> create table t ENGINE=FEDERATED CONNECTION="mysql://root@127.0.0.1:3315/test/t1";
|
Query OK, 0 rows affected (0,025 sec)
|
|
MariaDB [test]> set global federated_pushdown=1;
|
Query OK, 0 rows affected (0,000 sec)
|
|
MariaDB [test]> select * from t;
|
ERROR 1030 (HY000): Got error 10000 "Unknown error 10000" from storage engine FEDERATED
|
|
MariaDB [test]> set global federated_pushdown=0;
|
Query OK, 0 rows affected (0,000 sec)
|
|
MariaDB [test]> select * from t;
|
+------+
|
| i |
|
+------+
|
| 1 |
|
| 2 |
|
+------+
|
2 rows in set (0,003 sec)
|
|
--source have_federatedx.inc
|
--source include/federated.inc
|
|
connection slave; |
|
create table t1(i int); |
insert into t1 values (1),(2); |
|
--replace_result $SLAVE_MYPORT SLAVE_PORT
|
eval
|
CREATE TABLE t1_fed ENGINE="FEDERATED" CONNECTION='mysql://root@127.0.0.1:$SLAVE_MYPORT/test/t1'; |
|
set global federated_pushdown=0; |
select * from t1_fed; |
|
set global federated_pushdown=1; |
select * from t1_fed; |
|
source include/federated_cleanup.inc;
|
Attachments
Issue Links
- relates to
-
MDEV-25080 Allow pushdown of queries involving UNIONs in outer select to foreign engines
- Closed