[MDEV-32382] FederatedX error on pushdown of statements having CTE Created: 2023-10-09  Updated: 2023-11-23  Resolved: 2023-11-02

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - Federated
Affects Version/s: 11.1, 11.2, 11.3
Fix Version/s: 11.1.3, 11.2.2

Type: Bug Priority: Major
Reporter: Oleg Smirnov Assignee: Oleg Smirnov
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Duplicate

 Description    

--source include/master-slave.inc
 
 
connection slave; 
CREATE TABLE t1 (id int);
 
INSERT INTO t1 VALUES (1),(2),(3);
 
 
connection master;
 
INSTALL SONAME 'ha_federatedx';
 
set global federated_pushdown=1;
 
 
--replace_result $SLAVE_MYPORT SLAVE_PORT
 
eval CREATE TABLE t1 ENGINE="FEDERATED" CONNECTION="mysql://root@127.0.0.1:$SLAVE_MYPORT/test/t1";
 
 
with cte as (select * from t1) select * from cte;

mysqltest: At line 15: query 'with cte as (select * from t1) select * from cte' failed: ER_GET_ERRNO (1030): Got error 10000 "Unknown error 10000" from storage engine FEDERATED

 Comments   
Comment by Oleg Smirnov [ 2023-10-10 ]

psergei, please review this pull request.

Comment by Sergei Petrunia [ 2023-11-01 ]

Ok to push after review input is addressed.

Comment by Oleg Smirnov [ 2023-11-02 ]

Pushed to 11.1

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