Overview

We ship a new user interface for CSV imports in the Web Console. This stability release collates bug fixes for issues raised by our community. We decided to cut this release ahead of the feature-packed 7.2.

What is new

UI

• new file import User Interface in Web Console by @insmac in https://github.com/questdb/questdb/pull/3346 and https://github.com/questdb/ui/pull/130

CORE

• simplified COPY CANCEL API by @bluestreak01 in https://github.com/questdb/questdb/pull/3298

SQL

• add nullif(long,long) SQL function by @javier in https://github.com/questdb/questdb/pull/3188
• enable rank() analytical SQL function by @puzpuzpuz in https://github.com/questdb/questdb/pull/2929
• add QuestDB to string returned by version() function by @davidcooke2 in https://github.com/questdb/questdb/pull/3239
• allow implicit cast from str to long256 by @marregui in https://github.com/questdb/questdb/pull/3209

HTTP

• add imported table metadata to json response by @bziobrowski in https://github.com/questdb/questdb/pull/3249
• introduce configuration for health check pessimism by @puzpuzpuz in https://github.com/questdb/questdb/pull/3292

What we fixed

CORE

• fix rollback failure by @ideoma in https://github.com/questdb/questdb/pull/3236
• fix index miss values or contain duplicates in certain commit patterns by @ideoma in https://github.com/questdb/questdb/pull/3266
• fix symbol index containing duplicates references by @ideoma in https://github.com/questdb/questdb/pull/3272
• copy metadata associated with wal tables on backup by @marregui in https://github.com/questdb/questdb/pull/3183
• consistent segment rollover in WalWriter by @amunra in https://github.com/questdb/questdb/pull/3327
• improve database stability after power loss by @bluestreak01 in https://github.com/questdb/questdb/pull/3304
• fix spurious SQL errors under concurrent SQL execution by @glasstiger in https://github.com/questdb/questdb/pull/3344
• disable chown by default in docker entrypoint by @mariusgheorghies in https://github.com/questdb/questdb/pull/3190

SQL

• fix display of interval scans in EXPLAIN's output by @bziobrowski in https://github.com/questdb/questdb/pull/3203
• fix bad rewrite of limit -N by @bziobrowski in https://github.com/questdb/questdb/pull/3261
• fix column type handling in table_partitions() function by @bziobrowski in https://github.com/questdb/questdb/pull/3251
• fix sample by over subquery with explicit timestamp by @bziobrowski in https://github.com/questdb/questdb/pull/3186
• fix crash in hash outer join with filter factory by @bziobrowski in https://github.com/questdb/questdb/pull/3303
• unhandled ArrayIndexOutOfBoundsException in ASOF and LT JOIN on empty table by @puzpuzpuz in https://github.com/questdb/questdb/pull/3302
• fix COPY performance for pre-created tables with non-default symbol capacity by @puzpuzpuz in https://github.com/questdb/questdb/pull/3305
• fix UPDATE sql timeout issue for WAL tables by @bluestreak01 in https://github.com/questdb/questdb/pull/3311
• NullPointerException on join with function filter by @puzpuzpuz in https://github.com/questdb/questdb/pull/3333
• UnsupportedOperationException on join with constant non-boolean filter expression by @puzpuzpuz in https://github.com/questdb/questdb/pull/3334
• timeout of CREATE TABLE AS SELECT leaves leaked entry in table registry by @puzpuzpuz in https://github.com/questdb/questdb/pull/3338

HTTP

• fix(http): format query parameter ignored by /imp endpoint by @puzpuzpuz in https://github.com/questdb/questdb/pull/3325

PGRWire

• fix(pgwire): revert reported pg server version back to 11.3 by @jerrinot in https://github.com/questdb/questdb/pull/3263
• fix(pgwire): fix Rust sqlx crate by @jerrinot in https://github.com/questdb/questdb/pull/3237

New Contributors

• @grosa1 made their first contribution in https://github.com/questdb/questdb/pull/3189
• @dragonlee8 made their first contribution in https://github.com/questdb/questdb/pull/3329
• @davidcooke2 made their first contribution in https://github.com/questdb/questdb/pull/3239

Full Changelog: https://github.com/questdb/questdb/compare/7.1.1...7.1.2