Overview

Maintenance release improving stability of the deduplication logic, which we introduced in 7.3. For anyone relying on deduplication or considering using it, we recommend to upgrade at the earliest convenience.

What is new

SQL

• make trailing comma optional by @bluestreak01 in https://github.com/questdb/questdb/pull/3684

What is fixed

CORE

• fix alias creation bug by @allegraharris in https://github.com/questdb/questdb/pull/3644
• fix dedup over allocating column space on writing by @ideoma in https://github.com/questdb/questdb/pull/3713
• fix alter table resume wal not having the effect by @ideoma in https://github.com/questdb/questdb/pull/3715
• fix unaligned msync address when merging split partitions by @puzpuzpuz in https://github.com/questdb/questdb/pull/3709
• fix transaction failures caused by global update sql execution by @ideoma in https://github.com/questdb/questdb/pull/3703
• fix incorrect table size when data is deduplicated by @bluestreak01 in https://github.com/questdb/questdb/pull/3704
• fix excessive disk space consumption on Windows under heavy load by @bluestreak01 in https://github.com/questdb/questdb/pull/3724
• improve query cache efficiency in PGWire and HTTP by @puzpuzpuz in https://github.com/questdb/questdb/pull/3725

SQL

• fix SAMPLE BY queries with ORDER BY timestamp DESC by @jerrinot in https://github.com/questdb/questdb/pull/3662
• fix SAMPLE BY fill(null) and fill(value) to support timestamps by @jerrinot in https://github.com/questdb/questdb/pull/3660
• allow quotes around dedup keys by @marregui in https://github.com/questdb/questdb/pull/3691
• fix performance of "distinct" type of queries by @bluestreak01 in https://github.com/questdb/questdb/pull/3399
• fix predicate pushdown into left-joined tables by @bziobrowski in https://github.com/questdb/questdb/pull/3699
• fix reader leak on query with invalid interval filter by @puzpuzpuz in https://github.com/questdb/questdb/pull/3710
• fix queries with limit clause by @bziobrowski in https://github.com/questdb/questdb/pull/3711

PGWire

• fix pg wire network send error by @ideoma in https://github.com/questdb/questdb/pull/3681

HTTP

• improve detection of flat file delimiter by @bluestreak01 in https://github.com/questdb/questdb/pull/3692
• fix NullPointerException on malformed import request by @puzpuzpuz in https://github.com/questdb/questdb/pull/3705

UI

• add the missing data types: ipv4, byte, binary, long256, uuid by @insmac in https://github.com/questdb/ui/pull/191
• allow writing multiple files to the same target table by @insmac in https://github.com/questdb/ui/pull/192
• incorrect timestamp check icon when selected by @insmac in https://github.com/questdb/ui/pull/191
• multiple designated timestamps could be selected by @insmac in https://github.com/questdb/ui/pull/191
• an unnecessary second scrollbar appeared in the UI by @insmac in https://github.com/questdb/ui/pull/191

New Contributors

• @AndreaCAnastasi made their first contribution in https://github.com/questdb/questdb/pull/3687
• @kerimsenturk5734 made their first contribution in https://github.com/questdb/questdb/pull/3671
• @goodroot made their first contribution in https://github.com/questdb/questdb/pull/3696

Full Changelog: https://github.com/questdb/questdb/compare/7.3.1...7.3.2