8.2.1

Winter is coming... And so are more features and improvements within 8.2.1.

This release follows a restive holiday weekend and the successful deployment of 8.2.0. Our prior release shipped our re-constructed PostgreSQL server implementation. After seeing the initial usage patterns, we've rolled out a series of stability fixes to smooth the overall journey. Those consuming PGWire, within tools like R Studio and PowerBI, will find a more seamless experience.

And, as usual, a series of fixes and performance improvements and general optimizations.

Breaking change 💥

• The dateadd(AIN) function will now error when provided with an invalid period or n (stride) value, if they are constants.
  • Use the errors to reconstruct the function syntax as appropriate.
• PowerBI integration now uses PostgreSQL type names in information_schema.columns().
  • Please update to these type names if you've applied an alternative.

Web Console 📈

Additions

• Support for ID token in Auth ui/#355
• News Image zoom, to better see all the cool new stuff :) ui/#350

Changes

• Highlight integer numbers that include _ (underscore) separator ui/#353
• Handle and display error received while scrolling the grid ui/#348
• Use new information_schema.questdb_columns() instead of information_schema.columns() ui/#359

New features 🐣

• New min(D) and max(D) window function.
  • We've also overhauled the window function docs, for better clarity and with more examples.

Performance improvements 🚀

• Reduced CPU idle load for improved overall efficiency.
• Improved length(varchar) function performance.

Bug fixes 🐛

• Fixed an issue when purging dropped tables that previously led to critical failures.
• Fixed issue where WAL tables would be suspended when a table update was followed by a rename.
• Fixed error reporting in the scenario where a 'drop table if exists' SQL command does not find the table.
• Fixed incorrect error reporting to PostgreSQL drivers:
  • Prepared statements that might fail at runtime will no longer contain duplicate error messages
  • SQL compilation errors will not be reported as NPE
• Modified INSERT AS SELECT will correctly return the number of rows inserted.

Pull requests

• perf(core): reduce CPU idle load by @ideoma in #5190
• perf(sql): performance improvement in length(varchar) function by @jerrinot in #5188
• fix(core): fix purging of dropped tables not to error out as critical failures by @ideoma in #5172
• fix(sql): breaking change 💥 - dateadd(AIN) will now error if provided invalid constant period or stride by @nwoolmer in #5166
• fix(pgwire): fix incorrect error reporting to PostgresSQL drivers by @bluestreak01 in #5189
• feat(sql): add support for the min(D) and max(D) window functions by @kafka1991 in #5173
• fix(sql): fix error returned that table does not exist on drop table if exists SQL by @ideoma in #5197
• fix(core): fix WAL table suspended when update to the table followed by table rename by @ideoma in #5200
• fix(sql): fix PowerBI integration, but breaking change 💥 - use PostgreSQL type names in information_schema.columns() by @jerrinot in #5206
• fix(pgwire): INSERT AS SELECT to return the number of rows inserted by @glasstiger in #5007

Full Changelog: 8.2.0...8.2.1