[MDEV-25834] Federated table with column type "geometry" fails Created: 2021-06-01  Updated: 2021-06-01

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

Type: Bug Priority: Major
Reporter: Raymond Michiels Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None
Environment:

Ubuntu



 Description   

Two servers, both running MariaDB 10.5.9. Server #1 has table:

create table foo ( x geometry );

Server #2 attempts to generate a federated table:

MariaDB [dalo]>   CREATE TABLE foo ENGINE="FEDERATED" CONNECTION='svr1/foo';
ERROR 1939 (HY000): Engine FEDERATED failed to discover table `svr1`.`foo` with 'CREATE TABLE `foo` (
  `x` geometry DEFAULT NULL
) CONNECTION='svr1/foo''

Originally found in a more complex table with multiple geometry columns. Only by removing these columns did the creation of the federated table succeed. Other tables without federated columns all work ok.

As far as I know there is no work-around for this.


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