questdb/questdb 6.5.4

on GitHub

Overview

This release includes new SQL features from our amazing Hacktoberfest contributors as well as performance and stability improvements.

What is new

SQL

string functions:

• add lower() and upper() string functions by @blackstar-baba in #2582
• add position() alias for string function strpos() by @DarthBenro008 in #2599
• implement starts_with string function by @akki1306 in #2608
• add lpad and rpad string functions by @eigengravy in #2631
• implement string function split_part() by @daniel-shuy in #2644

numeric functions:

• add math function ceiling with double and float arguments by @bsnxsourav in #2600
• add log10 math function to calculate base 10 logarithm of double argument by @blackstar-baba in #2579
• rename log() to ln() for natural logarithm function by @Ln11211 in #2605

others:

• support CREATE TABLE LIKE syntax by @akki1306 in #2580
• allow ALTER DROP of the last partition by @marregui in #2606
• support using row_number() over() and row_number() over(ORDER BY) by @blackstar-baba in #2656

Web Console

• active SQL highlights in the editor by @argshook in #2661

What we fixed

SQL

• fix OOM handling in vectorized group by implementation by @bziobrowski in #2562
• fix unexpected NPE thrown in query with analytical function and filter by @puzpuzpuz in #2598
• fix spurious errors with SQL queries when table columns are added extremely frequently in the background by @ideoma in #2602
• fix COPY of file with duplicate column names by @bziobrowski in #2591
• fix case-insensitivity for ILIKE by @Ln11211 in #2593
• change default location of import work directory to avoid extra file copying by @puzpuzpuz in #2592
• fix sampling aligned to calendar timezone and ending with semicolon or followed by ORDER BY/LIMIT by @jerrinot in #2572
• fix group by hour(ts) query optimization by @bziobrowski in #2622
• fix window function row_number() result start with zero if using PARTITION BY by @blackstar-baba in #2612
• fix #1916 bug of empty string and null string selection by @Twilight-Shuxin in #2056
• apply query timeout to insert statements and improve timeout reliability by @bziobrowski in #2587
• spurious duplicate column name errors in joins by @marregui in #2652
• force inlining for GROUP BY queries with few aggregates by @puzpuzpuz in #2621
• avoid unexpected errors when over() clause for analytic functions is missing @puzpuzpuz in #2657

CORE

• fix SIGSEGV on writing to table with intensive row cancel and rollback operations by @ideoma in #2596
• fix commit error when many partitions are added and merged in one transaction by @ideoma in #2627
• speeding up CSV lexer by 18-20% on amd64 and JDK17 by @bluestreak01 in #2576

PGWire

• fix incorrect protocol for asyncpg error handling by @bluestreak01 in #2559

ILP

• optimize ILP parser by @puzpuzpuz in #2635
• fix degradation of row-by-row commit when commit operation takes longer than commit lag by @ideoma in #2609
• fix variability in ILP performance by @bluestreak01 in #2654

Web Console

• fix grid active row disappearing at bottom of table @argshook in #2661

Docs

• bogus TTL values in server.conf by @ShubhamPalriwala in #2597

Contributor's Hall of Fame

We want to thank our new contributors:

• @ArjunSharda made their first contribution in #2569
• @TheZal made their first contribution in #2589
• @Ln11211 made their first contribution in #2593
• @ShubhamPalriwala made their first contribution in #2597
• @blackstar-baba made their first contribution in #2582
• @akki1306 made their first contribution in #2580
• @DarthBenro008 made their first contribution in #2599
• @bsnxsourav made their first contribution in #2600
• @sklarsa made their first contribution in #2628
• @Twilight-Shuxin made their first contribution in #2056
• @eigengravy made their first contribution in #2631

Full Changelog: 6.5.3...6.5.4