Sourced from com.arcadedb:arcadedb-network's releases.

26.4.2

ArcadeDB 26.4.2 Release Notes

Overview

ArcadeDB 26.4.2 is a major release with over 340 commits and 100+ resolved issues. The headline is a brand-new Raft-based High Availability stack built on Apache Ratis, alongside a deep wave of OpenCypher correctness and performance work, expanded wire-protocol security (BOLT + TLS), a new end-to-end Query Profiler, and a long list of SQL, HA, storage, and Studio improvements.

Highlights

Raft-based High Availability using Apache Ratis

ArcadeDB now ships a new HA mode backed by Apache Ratis, bringing a battle-tested Raft consensus implementation to the server. Leader election, log replication, and membership changes are all delegated to Ratis, giving stronger correctness guarantees for replicated writes and simpler operational semantics for clusters running on Kubernetes and bare metal #3730.

End-to-end Query Profiler

The query profiler has been promoted to a first-class feature across every query entrypoint (HTTP, Studio, embedded, drivers). In addition to planner and executor timings, it now also accounts for record deserialization and result serialization, giving a complete picture of where the time goes. Studio surfaces the new serialization cost directly in the results panel #3894.

OpenCypher: major correctness and optimization round

Dozens of OpenCypher issues have been closed in this release. Highlights:

• Filter pushdown for list predicates (any / all / none / single) in WHERE clauses, which dramatically reduces scanned rows on complex predicates - PR #3891, #3888
• Index usage for MATCH WHERE ID(n) = <expr> when the expression is dynamic (was falling back to full scan) - PR #3865
• Aggregation with CASE no longer returns multiple rows from an implicit GROUP BY - #3858
• CREATE CONSTRAINT ... IS TYPED is now supported - #3800
• CREATE INDEX statement is now supported - #3763
• Path Mode (WALK, TRAIL, ACYCLIC) support - #3710
• WITH * + extra AS alias no longer drops the extra items - #3761
• Cypher support removed from the Gremlin module in favor of the native engine - #3811
• Many subquery fixes:
  • EXISTS { MATCH ... } when relationship type embeds a Cypher keyword after underscore - #3952
  • CALL subquery with UNWIND no longer multiplies outer rows - #3944
  • CALL subquery reusing an outer variable name no longer drops rows - #3959
  • CALL + UNION ALL keeps all branches - #3958
  • COLLECT { ... } returns the list instead of null - #3957
  • COUNT { ... } pattern subqueries return the count, not the bound node - #3955, #3956
  • Inline relationship WHERE predicate is now applied - #3951
  • Existential pattern predicate in WHERE correctly filters by target node - #3938
  • Standalone ORDER BY ... LIMIT ... before MATCH preserves the selected row - #3950
• Expression and null handling fixes:
  • tail(null) returns null (not []) - #3920
  • CASE null WHEN null returns not_matched - #3922
  • List / string concatenation || with null returns null - #3921, #3926, #3927, #3928
  • Dynamic label matching with $() - #3923
  • Quantified path pattern ->+ matches 1+ relationships - #3924
  • Variable-length pattern *2..2 no longer includes distance-1 nodes - #3931
  • RETURN ALL raises a syntax error as expected - #3925
  • Fixes from the TCK run: 10 OpenCypher TCK failures from optimizer clause ordering resolved
  • Parameterized queries match correctly in property maps when an edge is present - #3765
  • Label expression predicate with null node returns null - #3935

... (truncated)

• 96a306b Set release version to 26.4.2
• ef892b4 fix: horizontal scrollbar
• 8bd7491 feat: allSimplePaths support exclusion list of edge types
• 6563346 Merge branch 'main' of https://github.com/ArcadeData/arcadedb
• 3997a8a fix: edge case with concurrency during index insert
• b7e103b #3967 refactor ha and load tests (#3968)
• d6bf401 Improve MCP server: init instructions and helpful database error (#3966)
• 830e38e perf: used custom maps in hot paths
• 0aa8995 perf: usage of custom collections/maps in hot paths
• 1d6d683 fix: infinite loop on LSMTree indexes when iterating DESC
• Additional commits viewable in compare view

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 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)