Release 0.156

    Query may incorrectly produce when no row qualifies for the aggregation if the optimize_mixed_distinct_aggregations session property or the optimizer.optimize-mixed-distinct-aggregations config option is enabled.

    • Fix query failure when using AT TIME ZONE in VALUES list.

    • Add support for ARRAY and that contain NULL in checksum() aggregation.

    • Add support for filtered aggregations. Example: SELECT sum(a) FILTER (WHERE b > 0) FROM ...

    • Change default task concurrency to 16.

    • Add support for legacy RCFile header version in new RCFile reader.
    • Support iso8601 data format for the hash row decoder.

    Note

    These are backwards incompatible changes with the previous SPI. If you have written a plugin, you will need to update your code before deploying this release.