7.3.7

What's Changed

The hits keep comin'. Newly released QuestDB 7.3.7 adds supporting functions to pair with our recently released window functions. It also offers brings further improvements to SQL and ingestion performance - this has been a pattern of late!

Additional key features include:

• A 5x speed up of WAL Apply for small transactions
• New built-in functions for covariance, correlation, cumulative sum, and first value window
• Enhanced compatibility with Grafana

Thanks to @AjCH1 and @ksankeerth for their first contributions!

New features

• feat(core): 5x speed up of WAL Apply for small transaction and add SQL function to read WAL transactions metadata by @ideoma in #3992
• perf(sql): micro optimizations SqlKeywords implementation (short-circuit evaluation, inline variable) by @nitram509 in #3978
• feat(sql): information_schema.columns() function to provide list of columns across all tables in the database by @marregui in #3975
• feat(sql): add covariance and corr built-in functions by @charlespnh in #4012
• feat(sql): add cumulative sum and first value window funtions by @bziobrowski in #4001
• fix(core): fix failed SQL update not suspending WAL table potentially leading to a data loss by @ideoma in #4015
• perf(sql): execute complex sum aggregates on short column in parallel by @puzpuzpuz in #4024
• perf(sql): optimize order by designated timestamp and other columns with limit by @bziobrowski in #4025
• perf(sql): speed up select distinct symbol queries by @puzpuzpuz in #4030

Fixes and improvements

• fix(sql): fix symbol != value filter not applied by @bziobrowski in #4035
• fix(sql): fix edge case internal error in case-switch expression by @jerrinot in #4033
• fix(sql): fix column propagation for queries with set operations and distinct by @bziobrowski in #4028
• fix(core): include system tables into database snapshots by @puzpuzpuz in #4026
• fix(sql): improve compatibility with grafana by @bziobrowski in #4039
• fix(sql): occasionally failing queries when under rapid structural changes by @jerrinot in #4000
• fix(sql): fix parsing of single character window frame bounds by @bziobrowski in #4045

New Contributors

• @AjCH1 made their first contribution in #3384
• @ksankeerth made their first contribution in #4008

Full Changelog: 7.3.5...7.3.7