Skip to content

stable-251023

Choose a tag to compare

@ronh-rs ronh-rs released this 23 Oct 19:54
· 179 commits to main since this release

Release Notes

Readyset is currently released as a docker container and Linux distro binary packages. For installation with docker, see the Install with Docker documentation. Available Linux distribution binary packages for x86_64/amd64 include deb package for Ubuntu 22.04, Debian 12 and later, and rpm packages for Amazon Linux 2023 and RedHat 9. See package installation instructions.

What's New

  • 54b5063: Use the intended collation for string-accumulating aggregation functions.
  • f6bb7ca: Add support for the PostgreSQL string concatenation function string_agg().
  • cc626a6: Ignore NULL values in accumulating aggregation functions such as group_concat().
  • 0d21ebc: Add base support for the PostgreSQL accumulating aggregation function array_agg().
  • 3bcc180: Support the DISTINCT keyword in accumulating aggregation operations.
  • a68bb75: Handle ORDER BY clauses in accumulating aggregation functions.
  • 75c8e97: Handle accumulation functions correctly in post-lookup aggregation operations.
  • 9e21dfd: Add support for Bucket(timestamptz, interval), a Readyset-specific SQL function that assigns timestamps to fixed-interval buckets. Intervals use the format [positive integer] [unit] (where unit = seconds, minutes, hours, days, months, or years). This function is primarily intended for use in GROUP BY and aggregate queries to enable time series–style grouping, for example:
    SELECT Bucket(ts, '5 seconds') AS s5, SUM(data) FROM t GROUP BY s5;
  • 3c90745: Add pre-snapshot verification checks to detect potential configuration issues earlier. The --verify flag can be used to run only the verification checks and then exit, while --verify-skip can be used to skip verification checks and continue normal startup.
  • 1eddd77: Ensure EXPLAIN LAST STATEMENT reports the cache name when the query target is Readyset, whenever possible.
  • 24f4d3e: Accept the ISO-8601 string timestamp separator in PostgreSQL (for both simple and extended query protocols).
  • b86c373: Set the correct upstream database version during the new connection handshake for both MySQL and PostgreSQL.
  • d2cf26a: Fix a potential deadlock occurring during index creation.
  • c2d76ef: Properly escape backslashes in strings that are elements within an array.