ClickHouse/pg_clickhouse v0.1.4

Release v0.1.4

on GitHub

This release makes binary-only changes. Once installed, any existing use of
pg_clickhouse v0.1 will get its benefits on reload without needing to
ALTER EXTENSION UPDATE.

⚡ Improvements

• Added support for the PostgreSQL md5() function, mapped to lower(hex(MD5())) in ClickHouse.
• Added support for mapping PostgreSQL BYTEA columns to ClickHouse String columns.
• Added explicit setting of format_tsv_null_representation and output_format_tsv_crlf_end_of_line to all http requests, as unexpected values will interfere with its operation.
• Improved the error message from the binary driver when attempting to insert a NULL into a column that is not Nullable(T).

🪲 Bug Fixes

• Fixed binary driver errors when attempting to insert a NULL value into Nullable Numeric, Text, Enum, UUID, and INET columns. Thanks to Rahul Mehta for the report (#140).
• Fixed http driver array parsing, which previously did not properly parse string values and would raise an error on values containing brackets ([]). Thanks to Philip Dubé for the spot (#142).
• Fixed a bug where the binary driver would raise an error on an empty array.

📔 Notes

• Refactored and improved the http engine's result processing, bringing it into closer alignment with the binary engine and removing double processing of row values.
• The http driver now ignores the following session settings from the pg_clickhouse.session_settings to prevent them from interfering with its operation: date_time_output_format, format_tsv_null_representation, and output_format_tsv_crlf_end_of_line.

🆚 For more detail compare changes since v0.1.3.