Fixed:
id
as a field name in DQL queriesBig Peer 1.47.0 enhances system reliability with critical fixes for CDC session persistence and connection stability, while introducing powerful new DQL capabilities including virtual collections, scalar functions, and dynamic field references.
Added:
SYSTEM:COLLECTIONS
and SYSTEM:ALL_COLLECTIONS
virtual collections for listing accessible collectionsUSE IDS
clause now accepts expressions that can be statically evaluatedFixed:
SET a.b = 1, a.c = 2
)Ditto Server 1.45.2 expands query flexibility with configurable DQL_STRICT_MODE
, delivers powerful new DQL features such as DISTINCT
selection and advanced scalar functions, and improves performance and reliability across replication, storage and query execution.
Added:
DQL_STRICT_MODE
can now be toggled directly from the DQL editorDISTINCT
selection support for deduplicating query resultsARRAY
of values to the IN
operator./store/write
HTTP API now use the more compact ObjectID
format (previously UUIDv4
).DELETE
statements and automatic tombstone eviction are now generally available on Big Peer"local"
, evaluating in the executing peer’s local timezonev5/store/execute
HTTP API endpoint, which operates with DQL_STRICT_MODE=false
semanticsDeprecated:
INSERT
statements is no longer supportedFixed:
DQL_STRICT_MODE=false
is now the default for CDC pipelines, Big‑Peer‑to‑Big‑Peer subscriptions and Data Bridge filters, reducing the need for manual configuration.WITH PERMISSION
clauses could short‑circuit and omit valid resultsIS NULL
or IS NOT MISSING
, preventing documents from being skippedDitto Server 1.42.3 introduces several new features, including CDC Data Bridges, automatic tombstone eviction and numerous DQL capabilities.
Added:
DELETE
s. This can be enabled on request by contacting Ditto SupportEXPLAIN
to show query plansCAST
function to explicitly cast between typesUSE IDS
for direct document retrieval by IDSIMILAR TO
filter expressionDATE
processing functionsPN_COUNTER
support (APPLY
clause in UPDATE
statement)UNSET
clause in UPDATE
statementsMERGE
now acts as an alias for UPDATE
in the ON ID CONFLICT
clause of an INSERT
statementINSERT
now accepts either DOCUMENTS
or VALUES
as the keyword introducing the list of values to insertFixed:
Ditto Server 1.41.0 delivers major performance enhancements for heavy workloads, introduces powerful new DQL features, and includes numerous optimizations and fixes.
Added:
LIMIT
, OFFSET
and ORDER BY
for mutating DQL statementsLIKE
DQL operatorobject_keys
and object_values
scalar DQL functionsIS NOT MISSING
predicates on MAP
fieldsFixed:
Ditto Server 1.40 introduces an overhaul of the underlying data structures of Ditto Server’s store, resulting in substantial improvement to performance and reliability, while unlocking new capabilities for upcoming features.
In addition, 1.40 contains a number new improvements and fixes.
Added:
Fixed:
Added:
Fixed:
Added:
Fixed:
Added:
Added:
Fixed:
Added:
Added:
Fixed:
Fixed:
Added:
Fixed:
Added:
Fixed:
Fixed:
Fixed:
Added:
Fixed:
Added:
Added:
Fixed:
Added:
Fixed:
Fixed:
Added:
Fixed:
Added:
Added:
Added:
Fixed:
Added:
Fixed:
Added:
Added:
Fixed:
NOT
on non-Boolean panics on Ditto Server (#10762)Fixed:
Fixed:
Fixed:
Fixed:
Deprecated:
Fixed:
Fixed:
Added:
Added:
Added:
Fixed:
Added:
Added:
Fixed:
Fixed:
Fixed:
Added:
Fixed:
Added:
Fixed:
Fixed:
Added:
Fixed:
Added:
Fixed:
Fixed:
Added:
Fixed:
Fixed:
Fixed:
Fixed:
Added:
Added:
Fixed: