Bump org.questdb:questdb from 7.3.9 to 8.3.1 in /modules/questdb

[dependabot]

Bumps org.questdb:questdb from 7.3.9 to 8.3.1.

Release notes

Sourced from org.questdb:questdb's releases.

8.3.1 is a stability release, and moves Materialized Views into GA. Thanks to all the early-adopters who have helped us with crucial feedback, to make sure they are efficient and robust. Give them a try!

8.3.1 also brings the first SQL Hints, which will give you more control over your query execution plans. For now, only one hint is supported - USE_ASOF_BINARY_SEARCH - which allows you to swap between two algorithms for handling filtered ASOF JOIN queries. Next on the list - controlling when the database chooses to use an INDEX scan.

For any questions or feedback, please join us on Slack or on Discourse.

See also our prettier release notes page.

Changelist

• fix(sql): add reset query timeout timer before checkpoint create by @​kafka1991 in questdb/questdb#5604
• fix(sql): fix internal error with some ASOF JOINs by @​jerrinot in questdb/questdb#5606
• fix(pgwire): compatibility with the nodejs 'postgres' driver by @​jerrinot in questdb/questdb#5615
• fix(core): prevent total symbol data loss on db hard reset by @​ideoma in questdb/questdb#5598
• feat(sql): skip unchanged sample by intervals in materialized view incremental refresh by @​puzpuzpuz in questdb/questdb#5613
• feat(sql): alter materialized view symbol capacity by @​puzpuzpuz in questdb/questdb#5622
• fix(sql): missing DST gap correction in case of certain sample by intervals by @​puzpuzpuz in questdb/questdb#5626
• perf(sql): support for Oracle-style SQL hints by @​jerrinot in questdb/questdb#5620

Full Changelog: questdb/questdb@8.3.0...8.3.1

8.3.0 moves Materialized Views into an advanced beta. Thanks to all of you have tried the beta and helped us iron out the remaining creases!

This release also brings significant ingestion performance improvements, particularly for small transactions and for batched PG Wire inserts. Not to mention a variety of bug fixes and safety enhancements to improve overall user experience.

But let's not forget about querying data! Check out how your ASOF JOIN queries are doing! We have released dramatic performance improvements for ASOF JOINs that include interval scans and/or post-join filters. Benching against larger datasets has shown 100-1000x speedups for some queries.

For any questions or feedback, please join us on Slack or on Discourse!

See also our prettier release notes page!

Breaking changes 💥

• Materialized Views will now be enabled by default. If you do not wish to use them, you can disable them by setting cairo.mat.view.enabled=false.

• Designated timestamp columns can no longer hold values beyond the Year 9999. We found that these values were generally produced by mistaken arithmetic. This prevents undroppable partition issues, and also reduces the chances of a configured TTL dropping your data.

• Some IPv4 built-in functions were removed. You may need to introduce explicit casts in SQL queries that relied on implicit conversions between ipv4 and other database types. This removes some ambiguity that was causing issues with queries unrelated to ipv4.

• Converting char to numeric values now aligns with PostgreSQL behaviour, whether implicitly or explicitly casted.

• SAMPLE BY will now correctly handle a variety of DST-related timestamp grouping issues. SAMPLE BY queries that use DST shifts are more likely to be executeed in parallel, too. These changes mean your result set might look different to before - but should be a consistent, rational output.

• FLOAT and DOUBLE types, when output to JSON or web console, will now have different precision. Previously, this was limited artificially. Now, it will print as many digits as it can. If you rely on the old output for any integration testing, you may need to upgrade your tests!

Highlights

• Materialized Views are now in an advanced BETA.

... (truncated)

Commits

• bb857e6 [maven-release-plugin] prepare release 8.3.1
• 8ba7cce chore(ui): upgrade web console to 0.7.10 (#5631)
• 47306da chore(sql): ensure materialized view symbol columns inherit symbol capacity f...
• d470b04 perf(sql): support for Oracle-style SQL hints (#5620)
• 7debdb1 chore(core): refactoring to allow csv import owner param (#5464)
• 3f3c879 fix(sql): missing DST gap correction in case of certain sample by intervals (...
• b134bc7 feat(sql): alter materialized view symbol capacity (#5622)
• a42c263 chore(sql): update last refresh timestamp on mat view invalidation (#5601)
• 1026081 chore(build): update zlib dep to 1.3.1 to make clang17 (default complier afte...
• fe21d78 feat(sql): skip unchanged sample by intervals in materialized view incrementa...
• Additional commits viewable in compare view

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

---

Dependabot commands and options

You can trigger Dependabot actions by commenting on this PR:

• @dependabot rebase will rebase this PR
• @dependabot recreate will recreate this PR, overwriting any edits that have been made to it
• @dependabot merge will merge this PR after your CI passes on it
• @dependabot squash and merge will squash and merge this PR after your CI passes on it
• @dependabot cancel merge will cancel a previously requested merge and block automerging
• @dependabot reopen will reopen this PR if it is closed
• @dependabot close will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually
• @dependabot show <dependency name> ignore conditions will show all of the ignore conditions of the specified dependency
• @dependabot ignore this major version will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)
• @dependabot ignore this minor version will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)
• @dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)

[dependabot]

Superseded by #10298.