Long connection with parameter “externalDatabase" on Clickhouse-server 24.3+

[Trifonov-Artem]

DBeaver version 24.0.1

After updating Clickhouse-server to 24.3.1.2672, we noticed that the connection time to clickhouse increased noticeably, it turned out that the problem was the default parameter “externalDatabase” in the clickhouse jdbc driver for dbeaver, which creates a request when connecting.

select concat('jdbc(''', name, ''')') as table_cat from jdbc('', 'show datasources') order by name;

Previously, in previous versions of LTS 23.8, this request quickly completed with an error "clickhouse-jdbc-bridge is not running" and the connection occurred in a second, now the connection is processed in about 10 seconds

the request below is processed many times longer than in previous versions, and connection many times longer

select concat('jdbc(''', name, ''')') as table_cat from jdbc('', 'show datasources') order by name;