questdb/questdb 6.7

on GitHub

Overview

🚀 New Features

• 128-bit UUID column type to make storage and queries more efficient (#2769)
• explain SQL to show insights into query execution plan (#2680)
• Trigonometric functions and a performance improvement for SQL queries (#2890)

❗ Breaking changes

• As of this release, it is strongly discouraged to modify or delete table directories in the db directory or delete table directories while the database instance is still running. It is still safe to do those activities while database is shut down. (#2752)

• If multiple database instances share the same db directory, you will now have to declare all but one of them as read-only instances via their configuration. (#2752)

What is new

CORE

• add rss memory metric by @bziobrowski in #2899
• improve instance start-up speed by @zhmaeff in #2871
• support partition by ISO week and ISO week format by @stephenspol in #2779
• make partitions attached via soft link read-only, protected from upserts by @marregui in #2710
• support auto log file delete in rolling log writer by @Belair34 in #2740

SQL

• add trigonometric functions sin, cos, tan, cot, asin, acos, atan, atan2, toRadians, fromRadians, pi by @marregui in #2890
• implement explain SQL statement by @bziobrowski in #2680
• optimize hash map used in joins, group by, sample by and other queries by @puzpuzpuz in #2903
• implement UUID column type by @jerrinot in #2769
• fix long256 comparisons on different columns of the same table @jerrinot #2924
• optimize aggregates and add count(column) function by @bziobrowski in #2896

PGWire

• add support for configurable read-only user by @puzpuzpuz in #2855
• fix duplicate rows in result set when Fetch Size specified by @ideoma in #2874

ILP

• allow conversion to symbol from valid ILP types by @glasstiger in #2826

What we fixed

CORE

• fix results returned in wrong order from parallel filter query by @puzpuzpuz in #2810
• refuse GSSAPI authentication gracefully (#2820) by @vjuranek in #2821
• fix intermittent errors during table reads by @bluestreak01 in #2838
• fix possible database crash on Windows when disk runs out of space by @bluestreak01 in #2827
• fix partition does not exist error after partition drop by @ideoma in #2864
• fix symbol reader lookups at minimal capacity by @bziobrowski in #2928

SQL

• fix parsing and execution of indexed symbol predicates by @bziobrowski in #2817
• fix incorrect partition name shown in repair table hint by @puzpuzpuz in #2851
• fix timestamp interval optimizer case sensitivity by @puzpuzpuz in #2859
• fix slowness due to redundant disk reads in LIMIT K,N filtered queries by @puzpuzpuz in #2849
• fix empty result set occasionally returned from latest on indexed symbol query by @puzpuzpuz in #2848
• fix insert as select with group by expression and constant literals by @glasstiger in #2883
• fix results when combining negative limit, column aliasing and predicate by @jerrinot in #2882
• fix internal error when using empty quoted strings in queries by @jerrinot in #2839
• fix left join with complex expressions by @bziobrowski in #2852
• fix out-of-memory errors when using count_distinct() symbol function by @puzpuzpuz in #2897
• fix timestamp column required error in sample by with sub-queries by @puzpuzpuz in #2923

HTTP

• fix unexpected query timeout errors in /exp endpoint by @puzpuzpuz in #2866

New Contributors

• @jay-tau made their first contribution in #2792
• @vjuranek made their first contribution in #2821
• @zhmaeff made their first contribution in #2871
• @ShashankKumarSaxena made their first contribution in #2796
• @Ochibobo made their first contribution in #2907
• @Belair34 made their first contribution in #2740

Full Changelog: 6.6.1...6.7