questdb/questdb 6.5

on GitHub

Release overview

This release brings a new algorithm for the SQL COPY statement [Reference], which is specifically designed to enable fast and easy CSV Import for large and unsorted data files. This feature comes in handy when there's a need to migrate a large amount of data from other databases to QuestDB [Guide: CSV import]. In addition, there are several improvements and fixes for the Influx line protocol, Core, and SQL engine.

Gotchas

No gotchas when you are upgrading from the start or 6.3, as it is just a software update.
If you're upgrading from 6.2.1 or earlier, please refer to the gotchas of 6.3

What is new

CORE

• deterministically deposit hs_err_pid crash logs into db directory with Docker package by @bluestreak01 in #2346
• use all available cores by default @puzpuzpuz #2392

SQL

• high-performance implementation of the COPY statement for unordered CSV files by @eugenels, @bziobrowski in #2155
• implement the function substring to extract some characters from a string by @hezean in #2251
• add write mode parameter for CREATE TABLE SQL by @ideoma in #2335
• improve PostgreSQL compatibility as a base for extending integrations later by @bluestreak01 #2210

What we fixed

CORE

• fix swallowing of all error and critical log messages by @ideoma in #2345
• fix docker entry point exiting prematurely on chown errors by @mariusgheorghies in #2354
• fix potential crash on adding column index by @ideoma in #2362

SQL

• incorrect result for negative LIMIT query with indexed symbol filter by @puzpuzpuz in #2336
• make aggregate check case-insensitive by @bziobrowski in #2331
• fix ORDER BY priority in case of duplicate column names by @jerrinot in #2339
• incorrect result in some aggregation functions by @eugenels in #2342
• fix incorrect timezone arithmetic in INSERT SQL by @bluestreak01 in #2366
• fix keyed group by crashing on int column with high cardinality @bziobrowski #2353
• fix error from queries that involve time interval & JIT search @bluestreak01 #2393
• fix boolean numeric representation @Zahlii #2386
• inconsistency in worker count configuration for asynchronous filters @eugenels #2399

ILP

• change default Sender port by @jerrinot in #2324

PGWire

• fix spurious error when executing "create table" SQL from Rust @bluestreak01 #2385

Full Changelog: 6.4.3...6.5