CREATE OR REPLACE .. SELECT of Federated table doesn't store selected values

--source include/have_innodb.inc

install soname 'ha_federatedx';

create table t (a int) engine=InnoDB;

eval create or replace table tf connection 'mysql://root@127.0.0.1:$MASTER_MYPORT/test/t' engine=Federated as select 1 as a;

select * from tf;

# Cleanup

drop table tf, t;

uninstall soname 'ha_federatedx';

select * from tf;

a

drop table tf, t;

commit 93c8252f02faa8ad8dc5f005e52f1990c29d4a0d (HEAD)

Author: Aleksey Midenkov

Date:   Wed Aug 31 11:55:04 2022 +0300

    MDEV-25292 Atomic CREATE OR REPLACE TABLE

                     6 Connect  root@localhost on test using TCP/IP

                     6 Query    set time_zone='+00:00'

                     6 Query    SET AUTOCOMMIT=0

                     6 Query    set time_zone='+00:00'

                     6 Query    SAVEPOINT save1

                     6 Query    set time_zone='+00:00'

                     6 Query    INSERT INTO `t` (`a`)  VALUES  (1)

                     6 Query    set time_zone='+00:00'

                     6 Query    COMMIT

                     4 Query    select * from tf

                     6 Query    set time_zone='+00:00'

...

                     6 Connect  root@localhost on test using TCP/IP

                     6 Query    set time_zone='+00:00'

                     6 Query    SET AUTOCOMMIT=0

                     6 Query    set time_zone='+00:00'

                     6 Query    SAVEPOINT save1

                     6 Query    set time_zone='+00:00'

                     6 Query    INSERT INTO `t` (`a`)  VALUES  (1)

                     6 Quit