6.5
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 intodb
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
andcritical
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
PGWire
- fix spurious error when executing "create table" SQL from Rust @bluestreak01 #2385
Full Changelog: 6.4.3...6.5