MariaDB [(none)]> create or replace table target_db.test engine=columnstore select * from source_db.test ;

Query OK, 0 rows affected (0.262 sec)

Records: 0  Duplicates: 0  Warnings: 0

MariaDB [(none)]>  create or replace table target_db.test engine=columnstore select * from source_db.test ;

ERROR 1178 (42000): The storage engine for the table doesn't support The syntax or the data type(s) is not supported by Columnstore. Please check the Columnstore syntax guide for supported syntax or data types.

MariaDB [(none)]> select set_htap_replication('test', 'source_db', 'target_db');

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

| set_htap_replication('test', 'source_db', 'target_db') |

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

| Success.                                               |

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

1 row in set (0.021 sec)

MariaDB [(none)]>  create database source_db ;

Query OK, 1 row affected (0.003 sec)

MariaDB [(none)]>  create database target_db ;

Query OK, 1 row affected (0.004 sec)

MariaDB [(none)]> create table source_db.test ( a int , b varchar(255) ) ;

Query OK, 0 rows affected (0.017 sec)

MariaDB [(none)]> show tables from target_db ;

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

| Tables_in_target_db |

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

| test                |

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

1 row in set (0.000 sec)

MariaDB [(none)]> show create table target_db ;

ERROR 1046 (3D000): No database selected

MariaDB [(none)]> show create table target_db.test ;

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

| Table | Create Table                                                                                                           |

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

| test  | CREATE TABLE `test` (

  `a` int(11) DEFAULT NULL,

  `b` varchar(255) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8 |

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

1 row in set (0.001 sec)

MariaDB [(none)]> create or replace table target_db.test engine=columnstore select * from source_db.test ;

Query OK, 0 rows affected (0.262 sec)

Records: 0  Duplicates: 0  Warnings: 0

MariaDB [(none)]>  create or replace table target_db.test engine=columnstore select * from source_db.test ;

ERROR 1178 (42000): The storage engine for the table doesn't support The syntax or the data type(s) is not supported by Columnstore. Please check the Columnstore syntax guide for supported syntax or data types.

MariaDB [(none)]> insert into source_db.test values (1,'aaaaa') , (2,'bbbbb') , (3, 'cccccc') ;

Query OK, 3 rows affected (0.005 sec)

Records: 3  Duplicates: 0  Warnings: 0

MariaDB [(none)]> select * from  target_db.test ;

Empty set (0.068 sec)

MariaDB [(none)]> select * from  source_db.test ;

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

| a    | b      |

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

|    1 | aaaaa  |

|    2 | bbbbb  |

|    3 | cccccc |

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

3 rows in set (0.000 sec)

MariaDB [(none)]> show slave status \G

*************************** 1. row ***************************

                Slave_IO_State: Waiting for master to send event

                   Master_Host: htap-jens-mariadb-maxscale-replication

                   Master_User: skysql_replication

                   Master_Port: 3309

                 Connect_Retry: 60

               Master_Log_File: mysql-bin.000001

           Read_Master_Log_Pos: 3776

                Relay_Log_File: htap-jens-mdb-cs-single-0-relay-bin.000002

                 Relay_Log_Pos: 1477

         Relay_Master_Log_File: mysql-bin.000001

              Slave_IO_Running: Yes

             Slave_SQL_Running: No

               Replicate_Do_DB:

           Replicate_Ignore_DB:

            Replicate_Do_Table:

        Replicate_Ignore_Table:

       Replicate_Wild_Do_Table:

   Replicate_Wild_Ignore_Table:

                    Last_Errno: 1093

                    Last_Error: Error 'Table 'test' is specified twice, both as a target for 'CREATE' and as a separate source for data' on query. Default database: ''. Query: 'create or replace table target_db.test engine=columnstore select * from target_db.test'

                  Skip_Counter: 0

           Exec_Master_Log_Pos: 3374

               Relay_Log_Space: 2208

               Until_Condition: None

                Until_Log_File:

                 Until_Log_Pos: 0

            Master_SSL_Allowed: No

            Master_SSL_CA_File:

            Master_SSL_CA_Path:

               Master_SSL_Cert:

             Master_SSL_Cipher:

                Master_SSL_Key:

         Seconds_Behind_Master: NULL

 Master_SSL_Verify_Server_Cert: No

                 Last_IO_Errno: 0

                 Last_IO_Error:

                Last_SQL_Errno: 1093

                Last_SQL_Error: Error 'Table 'test' is specified twice, both as a target for 'CREATE' and as a separate source for data' on query. Default database: ''. Query: 'create or replace table target_db.test engine=columnstore select * from target_db.test'

   Replicate_Ignore_Server_Ids:

              Master_Server_Id: 1

                Master_SSL_Crl:

            Master_SSL_Crlpath:

                    Using_Gtid: Slave_Pos

                   Gtid_IO_Pos: 1-1-21

       Replicate_Do_Domain_Ids:

   Replicate_Ignore_Domain_Ids:

                 Parallel_Mode: conservative

                     SQL_Delay: 0

           SQL_Remaining_Delay: NULL

       Slave_SQL_Running_State:

              Slave_DDL_Groups: 35

Slave_Non_Transactional_Groups: 0

    Slave_Transactional_Groups: 2

1 row in set (0.000 sec)