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
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103

// SPDX-License-Identifier: BUSL-1.1

//! CREATE INDEX naming, SHOW INDEXES, and parse-time shape tests.
//!
//! The "silent no-op" regression mode (DDL parses, audit records
//! ownership, but the secondary index is never wired into the
//! collection config) is guarded here at the registration surface.
//! Deeper behavioral checks (planner, backfill, partial) live in
//! sibling files.

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

#[tokio::test(flavor = "multi_thread", worker_threads = 4)]
async fn create_index_named() {
    let server = TestServer::start().await;

    server.exec("CREATE COLLECTION idx_named").await.unwrap();
    server
        .exec("INSERT INTO idx_named { id: 'a', role: 'admin' }")
        .await
        .unwrap();

    // Named index — standard SQL form.
    server
        .exec("CREATE INDEX my_idx ON idx_named(role)")
        .await
        .unwrap();
}

#[tokio::test(flavor = "multi_thread", worker_threads = 4)]
async fn create_index_unnamed_auto_name() {
    let server = TestServer::start().await;

    server.exec("CREATE COLLECTION idx_unnamed").await.unwrap();
    server
        .exec("INSERT INTO idx_unnamed { id: 'a', email: 'a@b.com' }")
        .await
        .unwrap();

    // No name — should auto-generate name and succeed.
    server
        .exec("CREATE INDEX ON idx_unnamed(email)")
        .await
        .unwrap();
}

#[tokio::test(flavor = "multi_thread", worker_threads = 4)]
async fn create_index_fields_keyword() {
    let server = TestServer::start().await;

    server.exec("CREATE COLLECTION idx_fields").await.unwrap();
    server
        .exec("INSERT INTO idx_fields { id: 'a', tag: 'rust' }")
        .await
        .unwrap();

    // FIELDS keyword form — should succeed.
    server
        .exec("CREATE INDEX ON idx_fields FIELDS tag")
        .await
        .unwrap();
}

#[tokio::test(flavor = "multi_thread", worker_threads = 4)]
async fn create_unique_index_unnamed() {
    let server = TestServer::start().await;

    server.exec("CREATE COLLECTION idx_unique").await.unwrap();
    server
        .exec("INSERT INTO idx_unique { id: 'a', code: 'ABC' }")
        .await
        .unwrap();

    // Unnamed UNIQUE index.
    server
        .exec("CREATE UNIQUE INDEX ON idx_unique(code)")
        .await
        .unwrap();
}

#[tokio::test(flavor = "multi_thread", worker_threads = 4)]
async fn show_indexes_lists_created_index() {
    let server = TestServer::start().await;

    server.exec("CREATE COLLECTION idx_show").await.unwrap();
    server
        .exec("CREATE INDEX idx_show_role ON idx_show(role)")
        .await
        .unwrap();

    // Positive lock-in: SHOW INDEXES must list a freshly created index. This
    // is the user-visible confirmation that creation succeeded; without it,
    // operators have no feedback channel. (First-column read of `query_text`
    // returns the index name.)
    let names = server
        .query_text("SHOW INDEXES")
        .await
        .expect("SHOW INDEXES must succeed");
    assert!(
        names.iter().any(|n| n == "idx_show_role"),
        "SHOW INDEXES must list created index, got: {names:?}"
    );
}