[MDEV-28577] Table discovery allows unsupported Federated structure Created: 2022-05-16  Updated: 2023-04-27

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - Federated, Virtual Columns
Affects Version/s: 10.2, 10.3, 10.4, 10.5, 10.6, 10.7, 10.8
Fix Version/s: 10.4, 10.5, 10.6

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Oleksandr Byelkin
Resolution: Unresolved Votes: 0
Labels: None


 Description    

--source suite/federated/have_federatedx.inc
 
 
 
create table t (a int, b int as (a));
 
--eval create table tf connection 'mysql://root@127.0.0.1:$MASTER_MYPORT/test/t' engine=Federated
 
 
 
show create table tf;
 
 
 
# Cleanup
 
drop table tf, t;

In the test case above, the table is created without errors or warnings, but then any action on this table fails with ER_UNSUPPORTED_ENGINE_FOR_GENERATED_COLUMNS:

10.3 730eb1c4

 
mysqltest: At line 6: query 'show create table tf' failed: 1910: FEDERATED storage engine does not support generated columns

The unpleasant (and possibly realistic) side-effect is that such tables break mysqldump and some queries from INFORMATION_SCHEMA.


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