nodedb 0.3.0

Local-first, real-time, edge-to-cloud hybrid database for multi-modal workloads
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34

// SPDX-License-Identifier: BUSL-1.1

//! Shared helpers for the `sql_index_naming` test binary.

#![allow(dead_code)] // Not every sub-file uses every helper.

use super::common::pgwire_harness::TestServer;

/// Return all rows of EXPLAIN <sql> concatenated, lowercased.
///
/// Used to assert that the chosen physical plan references an index lookup
/// rather than a full scan when a WHERE predicate lands on an indexed field.
pub async fn explain_lower(server: &TestServer, sql: &str) -> String {
    let rows = server
        .query_text(&format!("EXPLAIN {sql}"))
        .await
        .expect("EXPLAIN must succeed");
    rows.join("\n").to_lowercase()
}

/// Return all rows of EXPLAIN <sql> concatenated, preserving case.
///
/// The pgwire EXPLAIN handler emits the `PhysicalPlan` via `{:?}` debug
/// format, so structural fields like `filters: [..]`, `projection: [..]`,
/// `limit: N`, etc. appear verbatim. Plan-shape assertions use this
/// form; `explain_lower` is only for case-insensitive plan-variant
/// name checks.
pub async fn explain_raw(server: &TestServer, sql: &str) -> String {
    let rows = server
        .query_text(&format!("EXPLAIN {sql}"))
        .await
        .expect("EXPLAIN must succeed");
    rows.join("\n")
}