fix DB::Exception: Missing columns: 'version'

[StyopinN]

"SELECT version" not working, there is only "version()" function exists. This causes an exception in logs and incorrect version detection (=> always using default latest version 22.8.15).

Affected for client version 1.0.3 and later

You could see log example below:

<Error> executeQuery: Code: 47, e.displayText() = DB::Exception: Missing columns: 'version' while processing query: 'SELECT version', required columns: 'version', source columns: 'dummy' (version 20.8.18.32 (official build)) (from <hidden_hostname>:51350) (in query: select version ), Stack trace (when copying this message, always include the lines below):

<Error> DynamicQueryHandler: Code: 47, e.displayText() = DB::Exception: Missing columns: 'version' while processing query: 'SELECT version', required columns: 'version', source columns: 'dummy', Stack trace (when copying this message, always include the lines below):

Clickhouse documentation: https://clickhouse.com/docs/en/sql-reference/functions/other-functions#version

[lwolters]

Looks good. I'll merge after the tasks complete successfully!

[StyopinN]

@lwolters When do you plan to publish release with this fix?

I undestand that it's very small increment for next release, but we use this library in our project and our users worried about exception in logs. We would like to update library rather than explain that this is not a critical issue.

Thanks!

[lwolters]

Did a release but some things appeared not to be working smooth. Although the release is available, please let me know if all is fine. Unfortunately I can't overwrite artifacts in sonatype so if somehting is wrong, i need to release again.

Anyway, please let me know if all is fine now.

Take care,

Leonard