QuestDB 9.4.2

QuestDB 9.4.2 is a hardening release that builds on 9.4.1, driven by continued fuzz testing and stricter query-result assertions. It includes bugfixes for the new posting index, parquet tables, temporal joins, and a variety of other SQL queries. This release also brings a Web Console upgrade, which brings some fixes and a new utility for sharing queries with your colleagues.

For any questions or feedback, please join us on Slack or on Discourse.

See also our prettier release notes page.

Breaking changes 💥

• A plain INDEX TYPE POSTING (no INCLUDE) is now non-covering.
  • cairo.posting.index.auto.include.timestamp=true was not intended to make all posting indexes covering by default.
  • This config flag automatically adds the designated timestamp to your INCLUDE list if you do not include it yourself. \
  • This ensures that queries that return the designated timestamp will be executed via the covering index, and not accidentally fall back to table scans.
• SHOW CREATE TABLE now rejects views and materialized views.
  • Previously it rendered a misleading CREATE TABLE statement for any kind of entity. You should use SHOW CREATE MATERIALIZED VIEW and SHOW CREATE VIEW instead for their corresponding entities.

Highlights

Web Console

You can now share a query quick-link with your colleagues, via a new editor drop-down on the green 'run' button. Simply click the copy list entry and paste the resulting URL to a friend or colleague. The URL will automatically open and run the query, making collaboration easier.

For long-form collaboration, don't forget that you can share and version control entire editor tabs using Tab Exporting, or share production-ready queries via CREATE VIEW.

We've also improved the visibility of Storage Policy (an Enterprise feature) settings, and reduced the eagerness of query validation, which should smooth out the overall editor experience.

Changelist

• chore(ui): upgrade web console to 1.2.3 by @emrberk in #7199
• fix(core): fix posting index crash and missing rows after partition squash by @nwoolmer in #7203
• fix(core): fix all-null Parquet column reads and crashes on malformed files by @glasstiger in #7212
• fix(sql): fix wrong results and memory leaks in posting-index, join and group-by queries by @puzpuzpuz in #7150
• fix(sql): fix a parquet query crash and wrong results in latest-by, ASOF joins, and counts by @bluestreak01 in #7195
• fix(sql): fix count() over a GROUP BY subquery reporting phantom duplicates by @ideoma in #7202
• fix(sql): fix UNION ALL column mismatch under aggregates by @nwoolmer in #7210
• fix(sql): reject views and materialized views in SHOW CREATE TABLE by @nwoolmer in #7208

Full Changelog: 9.4.1...9.4.2