ClickHouse/clickhouse-go v2.38.0

on GitHub

What's Changed

Enhancements 🎉

• Dynamic serialization version 3 by @SpencerTorres in #1588
• JSON serialization version 3 by @SpencerTorres in #1589
• Add client_protocol_version param for HTTP interface by @SpencerTorres in #1594
• Add missing interval types by @marcboeker in #1613

Bug fixes 🐛

• fix format function to handle pointer of time.Time by @KimMachineGun in #1559
• Fix variant prefix by @SpencerTorres in #1591
• fix(batch): nested column name parsing #1587 by @RuslanSibgatulin in #1614

Other Changes 🛠

• Bump github.com/andybalholm/brotli from 1.1.1 to 1.2.0 by @dependabot[bot] in #1581
• Bump github.com/docker/docker from 28.2.2+incompatible to 28.3.0+incompatible by @dependabot[bot] in #1583
• Bump go.opentelemetry.io/otel/trace from 1.36.0 to 1.37.0 by @dependabot[bot] in #1584
• Bump github.com/docker/docker from 28.3.0+incompatible to 28.3.1+incompatible by @dependabot[bot] in #1585
• Bump github.com/docker/docker from 28.3.1+incompatible to 28.3.2+incompatible by @dependabot[bot] in #1593
• Bump golang.org/x/net from 0.41.0 to 0.42.0 by @dependabot[bot] in #1595
• add HTTP wait condition for container tests by @SpencerTorres in #1604
• include server revision in block/column parsing by @SpencerTorres in #1605
• Bump github.com/testcontainers/testcontainers-go from 0.37.0 to 0.38.0 by @dependabot[bot] in #1603
• docs: add client configuration options by @shivanshuraj1333 in #1598
• Bump github.com/ClickHouse/ch-go from 0.66.1 to 0.67.0 by @dependabot[bot] in #1609

Upgrades for Dynamic / JSON

Dynamic and JSON were never fully functional in previous versions. If you exceeded the maximum types for Dynamic, the data would become unreadable since it was encoded as a single SharedVariant type. Same for JSON, if you exceeded the maximum dynamic paths the data would also become unreadable since it was stored in a SharedData structure.

In ClickHouse 25.6, a setting was added that abstracts these structures away so that clients don't have to implement them.
To begin using Dynamic and JSON to their fullest ability, upgrade to ClickHouse 25.6 along with clickhouse-go v2.38.0, and enable output_format_native_use_flattened_dynamic_and_json_serialization in your connection settings. This will allow you to read all Dynamic and JSON data, even the portions that are stored in the SharedVariant and SharedData blobs on the server.

If you are using older versions of ClickHouse, things will continue to work as before (with the previously mentioned limitations).

Feel free to create an issue in the clickhouse-go repository to report any concerns or bugs with this change.

New Contributors

• @KimMachineGun made their first contribution in #1559
• @shivanshuraj1333 made their first contribution in #1598
• @RuslanSibgatulin made their first contribution in #1614
• @marcboeker made their first contribution in #1613

Full Changelog: v2.37.2...v2.38.0