Renaming a table doesn't work for databases that are mapped to another name in ClickHouse

[nielsreijers]

Renaming a table doesn't work for databases that are mapped to another name in ClickHouse.

Versions used

MySQL version: 8.0.39
ClickHouse version: 24.8.4.13
Sink connector version: altinity/clickhouse-sink-connector:2.3.1-lt

Steps to reproduce:

• 1. In config.yml set clickhouse.database.override.map: "testdb:testdb_sink"
• 2. In MySQL testdb create table foo (id int primary key), insert into foo(id) values (1) -> table appears in ClickHouse testdb_sink as expected.
• 3. In MySQL testdb rename table foo to bar -> ClickHouse is not updated, and the sink connector's container log shows this error:

clickhouse-sink-connector-lt-1  | 2024-10-08 03:35:59.950 ERROR - Error running DDL Query: java.sql.SQLException: Code: 81. DB::Exception: Database testdb does not exist. (UNKNOWN_DATABASE) (version 24.8.4.13 (official build))
clickhouse-sink-connector-lt-1  | , server ClickHouseNode [uri=http://servername:8123/system, options={custom_settings=allow_experimental_object_type=1,insert_allow_materialized_columns=1,client_name=Client_1}]@-2121739127