[MDEV-38528] Federated[x] TEMPORARY table creation no longer possible after MDEV-38449 patch - Jira

XML

Word

Printable

Before ~~MDEV-38449~~, it was possible to create TEMPORARY Federated[x] tables:

INSTALL SONAME 'ha_federated';  # or 'ha_federatedx'

CREATE SERVER srv FOREIGN DATA WRAPPER mysql OPTIONS (SOCKET '../socket.sock', DATABASE 'test', USER 'root@localhost', PASSWORD '');

CREATE TABLE t1 (c INT) ENGINE=MyISAM;

CREATE TEMPORARY TABLE t2 (c INT) CONNECTION='srv/t1' ENGINE=Federated;

Leads to (on trunk):

CS 12.2.0 fd15fd2765b53d0c070dd01d86fb231024b8f284 (Debug, Clang 21.1.3-20250923) Build 10/11/2025
12.2.0-dbg>CREATE TEMPORARY TABLE t2 (c INT) CONNECTION='srv/t1' ENGINE=Federated;
Query OK, 0 rows affected (0.000 sec)

Whereas after the ~~MDEV-38449~~ patch, we see:

MDEV-35915-v10b CS 12.2.0 86d9fd540eb171a739b72a4875ae3a92b33c212d (Debug, Clang 21.1.3-20250923) Build 10/01/2026
12.2.0-dbg>CREATE TEMPORARY TABLE t2 (c INT) CONNECTION='srv/t1' ENGINE=Federated;
ERROR 1478 (HY000): Table storage engine 'FEDERATED' does not support the create option 'TEMPORARY'

is caused by

MDEV-35915 Implement Global temporary tables

MDEV-38449 GTT+ha_federatedx: Assertion `sp && savepoint_next && *sp && *sp <= savepoint_level' failed and memory corruption on RELEASE SAVEPOINT

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.