[MDEV-16108] Discovery of partitioned table fails Created: 2018-05-07  Updated: 2023-12-30

Status: Confirmed
Project: MariaDB Server
Component/s: Partitioning, Storage Engine - Federated
Affects Version/s: 10.0, 10.1, 10.3.6, 10.2, 10.3, 10.4, 10.5, 10.6, 10.11, 11.0, 11.1, 11.2, 11.3
Fix Version/s: 10.4, 10.5, 10.6, 10.11, 11.0, 11.1, 11.2, 11.3

Type: Bug Priority: Major
Reporter: Aleksey Midenkov Assignee: Alexey Botchkov
Resolution: Unresolved Votes: 0
Labels: None


 Description   

Reproduce

install soname 'ha_federatedx';
 
 
 
create or replace table t1 (x int)
 
partition by range columns (x) (
 
    partition p0 values less than (100),
 
    partition p1 values less than (1000));
 
--replace_result $MASTER_MYPORT MASTER_MYPORT
 
eval create or replace table tf engine=FEDERATED connection='mysql://root@127.0.0.1:$MASTER_MYPORT/test/t1';
 
 
 
drop database test;
 
create database test;
 
uninstall soname 'ha_federatedx';

Result

mysqltest: At line 9: query 'create or replace table tf engine=FEDERATED connection='mysql://root@127.0.0.1:$MASTER_MYPORT/test/t1'' failed: 1939: Engine FEDERATED failed to discover table `test`.`tf` with 'CREATE TABLE `t1` (
 
  `x` int(11) DEFAULT NULL
 
)
 
 PARTITION BY RANGE  COLUMNS(`x`)
 
(PARTITION `p0` VALUES LESS THAN (100),
 
 PARTITION `p1` VALUES LESS THAN (1000)) CONNECTION='mysql://root@127.0.0.1:16060/test/t1''

Expected

No error.

 Comments   
Comment by Elena Stepanova [ 2023-12-30 ]

Non-discovery (explicit definition) of a partitioned FederatedX table fails too:

--source include/have_partition.inc
 
 
 
install soname 'ha_federatedx';
 
 
 
create or replace table t1 (x int)
 
partition by range columns (x) (
 
    partition p0 values less than (100));
 
--replace_result $MASTER_MYPORT MASTER_MYPORT
 
eval create or replace table tf (x int) engine=FEDERATED connection='mysql://root@127.0.0.1:$MASTER_MYPORT/test/t1'
 
partition by range columns (x) (
 
    partition p0 values less than (100));
 
 
 
drop database test;
 
create database test;
 
uninstall soname 'ha_federatedx';

10.4 87a5d16911bb94d383480fdd49e20876ed1400f2

 
query 'create or replace table tf (x int) engine=FEDERATED connection='mysql://root@127.0.0.1:$MASTER_MYPORT/test/t1'
 
partition by range columns (x) (
 
partition p0 values less than (100))' failed: 1: server name: '' doesn't exist!

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