Release 2.3

Bug fixes:

• •

  Fixed incorrect ORDER BY LIMIT results on multi-column index scans

• •

  Fixed broken docs.rs

Bug fixes:

• •

  Added HTTP connection pooling to maximise throughput

• •

  Optimised START/LIMIT execution: correct semantics with WHERE/ORDER and early-stop iteration

• •

  Optimised memory usage by dropping mimalloc

Bug fixes:

• •

  Fixed START clause with WHERE conditions and improve optimisation safety

• •

  Fixed allowing null bytes in strings

• •

  Fixed Live Queries document issue

Improvements:

• •

  Add configurable user agent to HTTP requests

• •

  Support range scans on compound indexes (prefix + range)

• •

  Yield during Change feed garbage collection

• •

  Implemented slow logs for queries

• •

  Added range scans support on compound indexes (prefix + range)

Security advisories:

• •

  Unauthorized Data Exposure via LIVE Query Subscriptions

Bug fixes:

• •

  Ensure session variables are attached to DEFINE API execution context

• •

  The standard index should not fail if a value already exists

Bug fixes:

• •

  Implements DNS resolution on Context::check_allowed_net

Workflow improvements:

• •

  Added support for log files, json log format, and advanced log span filtering

• •

  Improved metrics consistency

• •

  Added support for Docker container timezone customisation

• •

  Ensured errors are caught when checking permissions for LQ

• •

  Ensured NS/DB is set; Ensure transaction is committed or cancelled

Security advisories:

• •

  Bypass of deny-net flags via DNS resolution

Bug fixes:

• •

  TIKV client update to 0.3.0-surreal.3

Workflow improvements:

• •

  Improved metrics consistency

• •

  Reject resolution of IP addresses resolving to denied IP address when doing HTTP request

Bug fixes:

• •

  Fixed memory usage and performance of Garbage Collection on old databases

Workflow improvements:

• •

  Improved import memory usage

• •

  Context cancellation check in prepare mock

• •

  Changed default RocksDB configuration options

• •

  Avoid using commit pool in wasm for skv in-memory

• •

  Set default WS buffer size to 0, reactive RocksDB mapped R/W

Bug fixes:

• •

  Fixed UPDATE permission to CREATE record

• •

  Ensured caches of dependent resources are refreshed on TABLE OVERWRITE

Aligned arbitrary and experimental capabilities

This release resolves an issue identified in v2.3.0 that can corrupt the database when an UPDATE statement
is stored within a function. If you experience this issue when migrating to v2.3.0 please kindly remove those
function definitions, upgrade to v2.3.1 and then add them back.

Bug fixes:

• •

  Fixed invalid revision on UPDATE statement

• •

  Restored GraphQL, accidentally made inaccessible in the previous release

• •

  Fixes invalid * value for SURREAL_CAPS_ALLOW_ARBITRARY_QUERY and SURREAL_CAPS_ALLOW_EXPERIMENTAL

NB: We identified an issue in this release that can corrupt the database when an UPDATE statement
is stored within a function. We released v2.3.1 to address this. If you defined functions with UPDATE
statements in v2.3.0 please kindly remove those function definitions, upgrade to v2.3.1 and then add them back.

Features:

• •

  Added support for filtering down graph selections with a range selection

• •

  Improved the parsing behaviour to accept any type of expression or start of idiom path

• •

  Added Finnish to the snowball filter

• •

  Implemented reverse scan for table and range iterator

• •

  Ensured documents are not over-fetched when LIMIT and START are used together

• •

  Added array functions for natural and/or lexical sorting

• •

  Added /data and /logs directories to the Docker container, and set up Docker volumes for those directories by default

• •

  Enabled the query planner on DELETE, UPDATE and UPSERT statements

• •

  [Implemented `TryFrom` for basic types](https://github.com/surrealdb/surrealdb/pull/5537)

• •

  Added booleans as literal types

• •

  Added support for ORDER BY DESC on indexes (RocksDB + TiKV)

• •

  Implemented kind regex

• •

  Improved ALL/ANYINSIDE behaviour with strings and arrays of strings

Bug fixes:

• •

  Fixed rand::time and other time-related issues

• •

  Fix the JSON response format

• •

  Made GraphQL avoid duplicate ID fields

• •

  Fixed sub-allocation in TrackAlloc

• •

  Fixed the default endpoint for exports and imports

• •

  Made several flow/timeout improvements

• •

  Fixed tokeniser failure with successive punctuation characters

• •

  Fixed overflow and panics in math functions

• •

  Fixed possible index out of bounds on compound indexes

• •

  Fixed arithmetic wrap panic in duration functions

• •

  Fixed indexing on filtered count results

• •

  Fixed concurrent indexing on quoted table names

• •

  Fixed select with start and limit for arrays

• •

  Enforced a limit to string::replace with regular expressions

• •

  Ensured slicing an array does not iterate over its items

Deprecations:

The following Rust SDK APIs are now deprecated. In addition, some Capabilities methods were renamed and the previous names marked as deprecated.

• •

  IntoQuery::into_query

• •

  IntoEndpoint::into_endpoint

• •

  IntoFn::into_fn

• •

  IntoExportDestination::into_export_destination

• •

  QueryResult::query_result

• •

  QueryResult::stats

• •

  QueryStream::query_stream

• •

  IntoResource::into_resource

• •

  CreateResource::into_resource

• •

  proto::ResponseAction

• •

  remote::WsNotification

Workflow improvements:

• •

  Made the default Rust version explicit

• •

  Allowed publishing multiple nightly crates per day

• •

  Added Trivy scanner runs on new Docker images

• •

  Added more language tests

• •

  Refactored dependencies to use workspace dependencies