HTAP - Replication workflow dependency on the metadata

MariaDB [(none)]> insert into ins.a values(1),(2),(3) ;

Query OK, 3 rows affected (0.005 sec)

Records: 3  Duplicates: 0  Warnings: 0

  Last_SQL_Error: Error 'You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'collectert into collect.a values(1),(2),(3)' at line 1' on query. Default database: ''. Query: 'collectert into collect.a values(1),(2),(3)'

MariaDB [(none)]> select * from collect.a ;

Empty set (0.011 sec)

MariaDB [(none)]> create database ins ;

MariaDB [(none)]> create database collect ;

Query OK, 1 row affected (0.003 sec)

MariaDB [(none)]> create table collect.a ( a int) engine columnstore ;

Query OK, 0 rows affected (0.257 sec)

MariaDB [(none)]>  create table ins.a ( a int) ;

Query OK, 0 rows affected (0.015 sec)

MariaDB [(none)]> select set_replications('a', 'ins', 'collect');

+-----------------------------------------+

| set_replications('a', 'ins', 'collect') |

+-----------------------------------------+

| Success.                                |

+-----------------------------------------+

1 row in set (0.017 sec)

MariaDB [(none)]> insert into ins.a values(1),(2),(3) ;

Query OK, 3 rows affected (0.005 sec)

Records: 3  Duplicates: 0  Warnings: 0

MariaDB [(none)]> select list_replications();

+------------------------------------------------------------------------------------------+

| list_replications()                                                                      |

+------------------------------------------------------------------------------------------+

|

        === replication_filter ===

        table: a

        source database: ins

        target database: collect

 |

+------------------------------------------------------------------------------------------+

1 row in set (0.002 sec)