release: v0.86.0 required reviews

[materialize-bot]

No PRs in v0.86.0 require review.

The following commits in this release were not associated with any PR and therefore require review:

• [x] 1847cf0bf LICENSE: update change date (@materialize-bot)
• [x] 38a4b30f9 LICENSE: update change date (@materialize-bot)
• [x] fff1ed3e9 LICENSE: update change date (@materialize-bot)
• [x] e34042753 LICENSE: update change date (@materialize-bot)
• [x] 210a79c43 LICENSE: update change date (@materialize-bot)
• [x] 22e95be1d LICENSE: update change date (@materialize-bot)
• [x] f97145e3c LICENSE: update change date (@materialize-bot)
• [x] 24b15995d release: bump to version v0.86.0 (@jkosh44)

[materialize-bot]

All PRs and unassociated commits:

• [ ] #24442 Improve representation in top-k (@vmarcos)
• [ ] #22868 persist-txn: make "lazy" the default in CI (@danhhz)
• [ ] #23686 Error on invalid characters . and .. in name.rs (@matthewarthur)
• [ ] #24714 ci: Fix typo in queue for cloud canary test (@def-)
• [ ] #24715 ci: Remove detection for old error (@def-)
• [ ] #24716 testdrive: Reset log filter to info at the end of test (@def-)
• [ ] #24713 postgres consistency: also ignore "cannot cast type bigint to boolean" (@nrainer-materialize)
• [ ] #24717 scalability framework: fix test operations (@nrainer-materialize)
• [ ] #24725 tests: Adapt tests to auto routing of introspection queries (@def-)
• [ ] #24654 catalog: Optimize catalog store migrations (@jkosh44)
• [ ] #24726 release: bump to version v0.86.0-dev (@ParkMyCar)
• [ ] #24729 persist: fix bug where large blobs would clear out the in-mem blob cache (@danhhz)
• [ ] #24730 persist-txn: remove persistcli txns subcommand (@danhhz)
• [ ] #24632 scalability framework: separate build for connection workload (@nrainer-materialize)
• [ ] #24648 scalability framework: add DDL operations (@nrainer-materialize)
• [ ] #24739 Bump v0.84 patch to 4 (@arusahni)
• [ ] #24737 postgres inconsistency: add ignore for empty time string (@nrainer-materialize)
• [ ] #24728 Correct PointStamp step_back (@frankmcsherry)
• [ ] #24697 sql: fully prevent item name references in INSERT (@mjibson)
• [ ] #24748 doc/user: fix ingestion status query for snapshot committed (@benesch)
• [ ] #24747 doc/user: add warning about using Aurora reader endpoints (@benesch)
• [ ] #24750 canary-load test: Support downing without environment variables (@def-)
• [ ] #24749 ci: Parallelize feature-benchmark (@def-)
• [ ] #24738 adapter: improve routing hints (@mjibson)
• [ ] #24743 sql: functions to build maps (@sploiselle)
• [ ] #24673 deps: upgrade to rust-rdkafka with non-blocking drop (@benesch)
• [ ] #24774 adapter: refactor notices (@sploiselle)
• [ ] #24354 sql: error when referencing ungrouped column that also exists in outer scope (@benesch)
• [ ] #24506 ci: enable enable_eager_delta_joins (@nrainer-materialize)
• [ ] #24782 ci: set enable_worker_core_affinity (@nrainer-materialize)
• [ ] #24788 docs: Fix railroad diagram generator link (@def-)
• [ ] #24790 canary-environment: Fix simple_table (@def-)
• [ ] #24786 ci: parallelize checks-upgrade-matrix (@nrainer-materialize)
• [ ] #24710 adapter: restore optimize lir and fix read holds (@mjibson)
• [ ] #24781 cleanup: remove obsolete TODOs (@nrainer-materialize)
• [ ] #24708 persist-txn: remove code for persist_txn_tables=off (@danhhz)
• [ ] #24795 sql: Fix casting negative intervals to time (@jkosh44)
• [ ] #24740 rocksdb: Update dependency (@ParkMyCar)
• [ ] #24789 Map unnest (@sploiselle)
• [ ] #24753 webhooks: Support BODY FORMAT JSON ARRAY (@ParkMyCar)
• [ ] #24803 storage: fix rustfmt in various mz_storage::source modules (@guswynn)
• [ ] #24811 cargo test: Disable test_coord_startup_blocking (@def-)
• [ ] #24634 platform-checks: Add migration scenarios, ci: Switch remaining jobs to ARM (@def-)
• [ ] #24807 tests: Remove single dot as identifier (@def-)
• [ ] #24784 storage: remove kafka producer limits in sinks (@petrosagg)
• [ ] #24814 tests: sqlsmith: add ignores (@nrainer-materialize)
• [ ] #24817 compute-types: perform lowering within a Context (@teskje)
• [ ] #24785 canary-load: Fix overriding mz (@def-)
• [ ] #24819 ci: Retry builds on aarch64 (@def-)
• [ ] #24821 tests: product limits: reduce case-when count (@nrainer-materialize)
• [ ] #24805 sql: fix regression in ALTER CLUSTER ... SET (SIZE ...) (@benesch)
• [ ] #20708 [design] Fast-path reads from Persist-backed collections (@bkirwi)
• [ ] #24823 tests: simplify and align parallelism handling (@nrainer-materialize)
• [ ] #24827 Delete outdated comment (@umanwizard)
• [ ] #24751 dyncfg: split dynamic configuration into a new mz_dyncfg crate (@danhhz)
• [ ] #24810 adapter: Introducing peek context enum (@moulimukherjee)
• [ ] #24704 adapter: Fix timestamp selection of constant materialized views (@jkosh44)
• [ ] #24722 Notice when creating an index that is identical to an already existing one (@aalexandrov)
• [ ] #24828 adapter: Prevent EXPLAIN from being linearized (@jkosh44)
• [ ] #24838 environmentd: plumb dyn config to envd test runner (@mjibson)
• [ ] #24839 misc: correctly set cluster in scalability test (@mjibson)
• [ ] #24840 adapter: Make also the new EXPLAIN pipeline not linearize (@ggevay)
• [ ] #24841 tests: simplify and align parallelism handling (2) (@nrainer-materialize)
• [ ] #24649 scalability framework: verbose output (@nrainer-materialize)
• [ ] #24836 sql: further protect against stack overflow in NameResolver (@benesch)
• [ ] #24835 fivetran-destination: Use the provided Docker image (@ParkMyCar)
• [ ] #24853 tests: fix SLT (@nrainer-materialize)
• [ ] #24856 adapter: Fix comment on RequireLinearization (@jkosh44)
• [ ] #24865 Revert "storage: remove kafka producer limits in sinks" (@def-)
• [ ] #24565 Switch MySQL Source Operators to using a Partitioned GTID Timestamp type (@rjobanp)
• [ ] #24866 test: Fix test_leader_promotion test (@jkosh44)
• [ ] #24867 persist: move parquet decoding from tokio threads to timely ones (@danhhz)
• [ ] #20491 tests: recovery after k8s node failure (@nrainer-materialize)
• [ ] #24487 compute-client: aggressively downgrade read holds for sink dataflows (@teskje)
• [ ] #24846 adapter: remove explain_statement (@aalexandrov)
• [ ] #24871 storage: handle librdkafka queue saturation in sinks (@petrosagg)
• [ ] #24875 tests: platform checks: testdrive timeout from env var (@nrainer-materialize)
• [ ] #24744 adapter: Implement Strong Session Serializable (@jkosh44)
• [ ] #24876 tests: node recovery: improve output (@nrainer-materialize)
• [ ] #24880 buildkite-costs: Update some instance costs (@def-)
• [ ] #24834 Apply a branch-specific NPM tag to release builds that are not latest (@arusahni)
• [ ] #24878 ci: buildkite insights: print URL to build by default (@nrainer-materialize)
• [ ] #24857 tests: add explain timestamp statements to materialized_views.py (@nrainer-materialize)
• [ ] #24885 sql: record all coord message timings (@mjibson)
• [ ] #24859 doc/user: polish v0.85 release notes (@morsapaes)
• [ ] #24861 persist: support one minor version of forward compatibility (@danhhz)
• [ ] #24891 adapter: Add Strong Session Serializable tests (@jkosh44)
• [ ] #24143 doc/user: improve SQL client documentation (@morsapaes)
• [ ] #24890 coord: Update warn! tracing of slow coordinator messages (@ParkMyCar)
• [ ] #24898 dbt-materialize: remove workaround for custom types (@morsapaes)
• [ ] #24897 catalog: Cleanup durable catalog tests (@jkosh44)
• [ ] #24850 misc: remove vestigial linked clusters code (@sploiselle)
• [ ] #24883 buildkite: write downloaded data to ignored temp dir (@nrainer-materialize)
• [ ] #24887 explain: rework FastPath handling (@aalexandrov)
• [ ] #24908 Revert "deps: upgrade to rust-rdkafka with non-blocking drop" (@petrosagg)
• [ ] #24911 storage: add LD flag to disable asserts in install_dependency_read_holds (@sploiselle)
• [ ] 1847cf0bf LICENSE: update change date (@materialize-bot)
• [ ] 38a4b30f9 LICENSE: update change date (@materialize-bot)
• [ ] fff1ed3e9 LICENSE: update change date (@materialize-bot)
• [ ] e34042753 LICENSE: update change date (@materialize-bot)
• [ ] 210a79c43 LICENSE: update change date (@materialize-bot)
• [ ] 22e95be1d LICENSE: update change date (@materialize-bot)
• [ ] f97145e3c LICENSE: update change date (@materialize-bot)
• [ ] 24b15995d release: bump to version v0.86.0 (@jkosh44)

[jkosh44]

All unreviewed commits/PRs that are not mine LGTM.

[arusahni]

All unreviewed commits lgtm