Release overview

This is a maintenance release driven by our community with new features. We improved SQL usability with external contributors and also fixed a memory leak for SQL execution.

Gotchas

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

What is new

SQL

• add support for sample standard deviation stddev_samp() aggregate function #2099 by @iridess
• add support for unit microseconds (U) in SAMPLE BY statements #1984 by @KevinChen16
• implement extract(part from timestamp) function #2042 by @bluestreak01, @bziobrowski and @marregui

HTTP

• support wrapping large numbers into strings to avoid overflow #2115 by @HeZean

What we fixed

SQL

• allow string casts to number by :: keyword #2109 by @HeZean
• fix potential stack overflow in PG Wire select and insert cache pooling #2103 @puzpuzpuz
• eliminate reduce counter race in page frame sequence used by parallel filters #2124 by @puzpuzpuz
• fix memory leak in cross-join cursor by #2126 @bluestreak01

Migration

• tolerate missing partition folders in 6.2.1 -> 6.3 migration #2114 by @ideoma

Contributor's Hall of Fame

We want to thank our new contributors:

• @iridess
• @KevinChen16