[Clickhouse] Cannot import or insert/update timestamp with enabled date formatting

[Matvey16]

Description

Incorrect insert query is generated when date formatting is enabled. DBeaver adds trailing zeroes to the timestamp even if there none in original input. Clickhouse doesn't support that. The same error leads to inability to insert timestamp data in data import. Even if original file have a timestamp without trailing zeroes. Dbeaver will still use them in generated insert statement

DBeaver Version

25.1.0

Operating System

No response

Database and driver

ClickHouse 22.1.3.7 ClickHouse JDBC Driver 0.8.5

Steps to reproduce

1. Enable data formatting
2. Create a table with DateTime column
3. Type a timestamp in appropriate format into a cell e.g. 2013-05-26 14:47:57
4. Click generate script

Expected: UPDATE last_update='2013-05-26 14:47:57' Actual: UPDATE last_update='2013-05-26 14:47:57.000'

Additional context

[Hubbitus]

@Matvey16, does "Use custom data/time format" helps you?

?

[Matvey16]

@Hubbitus This is another case. On your screenshot it is a script generated from the context menu with Generate SQL -> Insert where it does indeed work. I'm talking about the case where script is generated for changes made in data editor as well as insert in data transfer