Overview

This release introduces fixes for bugs found in the WAL storage mechanism (introduced in 7.0.1) as a result of thousands of hours of fuzz testing. We also fixed all of the issues reported on GitHub and by users in our public Slack channel. It also includes an improved UI for the Web Console.

What is new

CORE

• optimise WAL lag application in case data in order by @ideoma in https://github.com/questdb/questdb/pull/3151
• switch more often when applying WAL to tables to progress in fair manner by @ideoma in https://github.com/questdb/questdb/pull/3053

SQL

• add optional interval specifier (stride) for timestamp_floor function by @eugenels in https://github.com/questdb/questdb/pull/3017
• implement jit for uuid type equality by @eugenels in https://github.com/questdb/questdb/pull/3032
• add SHOW PARTITIONS FROM table; as well as SELECT * FROM table_partitions('table'); by @marregui in https://github.com/questdb/questdb/pull/3060

UI

• grid improvements by @bluestreak01 in https://github.com/questdb/questdb/pull/3068

PGWire

• add query cancelling by @bziobrowski in https://github.com/questdb/questdb/pull/3130

What we fixed

CORE

• remove unnecessary critical error about unsolicited table lock by @ideoma in https://github.com/questdb/questdb/pull/3066
• fix table truncate error by @ideoma in https://github.com/questdb/questdb/pull/3065
• fix DB crashes while writing to multiple tables by @ideoma in https://github.com/questdb/questdb/pull/3072
• close all but N latest partitions when query execution finishes by @puzpuzpuz in https://github.com/questdb/questdb/pull/3073
• fix WAL apply lag calculation by @ideoma in https://github.com/questdb/questdb/pull/3095
• fix transient read error of string column when partition is re-written during O3 commit by @ideoma in https://github.com/questdb/questdb/pull/3092
• fix potential segfault when applying WAL on table with var sized columns by @puzpuzpuz in https://github.com/questdb/questdb/pull/3134
• fix UTF-8 handling issues in logging by @amunra in https://github.com/questdb/questdb/pull/3056
• fix wal apply error by @ideoma in https://github.com/questdb/questdb/pull/3147
• fix no partition error after truncate and rollback by @ideoma in https://github.com/questdb/questdb/pull/3149
• release extra O3 memory after WAL apply by @puzpuzpuz in https://github.com/questdb/questdb/pull/3143
• fix error logging for long queries by @bziobrowski in https://github.com/questdb/questdb/pull/3139
• fix non-partitioned table truncate error by @ideoma in https://github.com/questdb/questdb/pull/3160
• fix unhandled NullPointerException in nested group by by @puzpuzpuz in https://github.com/questdb/questdb/pull/3157

SQL

• fix backslash escape mechanism in LIKE and ILIKE operator by @SiyaoIsHiding in https://github.com/questdb/questdb/pull/3006
• support pg_attribute and pg_database pg pseudo-tables with no schema prefix by @puzpuzpuz in https://github.com/questdb/questdb/pull/3036
• allow selecting aliased column followed by wildcard by @puzpuzpuz in https://github.com/questdb/questdb/pull/3034
• SIGSEGV caused by unmapped memory access by @eugenels in https://github.com/questdb/questdb/pull/3071
• fix NPE in group by indexed symbol by @bziobrowski in https://github.com/questdb/questdb/pull/3069
• fix order by removal in subquery with explicit timestamp by @bziobrowski in https://github.com/questdb/questdb/pull/3077
• fix index out of bounds errors in GROUP BY when worker pool is configured for HTTP or PGWire by @puzpuzpuz in https://github.com/questdb/questdb/pull/3061
• fix order by with index scans by @bziobrowski in https://github.com/questdb/questdb/pull/3074
• improve group by handling in optimiser by @bziobrowski in https://github.com/questdb/questdb/pull/3049
• fix order by aliased column not included in select list by @bziobrowski in https://github.com/questdb/questdb/pull/3079
• fix incorrect results from limit queries by @bluestreak01 in https://github.com/questdb/questdb/pull/3083
• ASOF and LT JOINS no longer convert SYMBOL keys to STRING by @jerrinot in https://github.com/questdb/questdb/pull/3087
• allow using more data types in PARTITION BY of LATEST ON queries by @jerrinot in https://github.com/questdb/questdb/pull/3137
• fix NPE in order by by @bziobrowski in https://github.com/questdb/questdb/pull/3094
• fix infinite loop in count_distinct on UUID column by @puzpuzpuz in https://github.com/questdb/questdb/pull/3153

PGWire

• send empty query response when sql text contains no query by @jerrinot in https://github.com/questdb/questdb/pull/3055
• fix cursor fetch for asyncpg by @bziobrowski in https://github.com/questdb/questdb/pull/3067

ILP

• fix no periodic commits for WAL tables in ILP when table constantly written by @ideoma in https://github.com/questdb/questdb/pull/3063

HTTP

• geo types should not fall-through to the UUID adapter by @winne42 in https://github.com/questdb/questdb/pull/3146

New Contributors

• @SiyaoIsHiding made their first contribution in https://github.com/questdb/questdb/pull/3006
• @winne42 made their first contribution in https://github.com/questdb/questdb/pull/3146

Full Changelog: https://github.com/questdb/questdb/compare/7.0.1...7.1