spg-engine 7.11.18

Execution engine for SPG: glues spg-sql parsing to spg-storage. Foreign keys, joins, vectors, cold tier.
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
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118

//! v7.9.20 + v7.9.21 — runtime DEFAULT evaluation. mailrs G3 + G4.

use spg_engine::{Engine, QueryResult};
use spg_storage::Value;

fn fake_clock() -> i64 {
    // 2026-06-04 12:00:00 UTC in microseconds since epoch.
    1_780_536_000_000_000
}

fn engine_with_clock() -> Engine {
    Engine::new().with_clock(fake_clock)
}

#[test]
fn default_now_is_filled_at_insert_time() {
    let mut eng = engine_with_clock();
    eng.execute("CREATE TABLE t (id INT NOT NULL, created_at TIMESTAMP NOT NULL DEFAULT now())")
        .unwrap();
    eng.execute("INSERT INTO t (id) VALUES (1)").unwrap();
    let r = eng.execute("SELECT created_at FROM t").unwrap();
    let QueryResult::Rows { rows, .. } = r else {
        panic!()
    };
    assert_eq!(rows[0].values[0], Value::Timestamp(fake_clock()));
}

#[test]
fn default_current_timestamp_keyword_no_parens() {
    let mut eng = engine_with_clock();
    eng.execute(
        "CREATE TABLE t (id INT NOT NULL, ts TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP)",
    )
    .unwrap();
    eng.execute("INSERT INTO t (id) VALUES (1)").unwrap();
    let r = eng.execute("SELECT ts FROM t").unwrap();
    let QueryResult::Rows { rows, .. } = r else {
        panic!()
    };
    assert!(matches!(rows[0].values[0], Value::Timestamp(_)));
}

#[test]
fn default_current_date_yields_a_date() {
    let mut eng = engine_with_clock();
    eng.execute("CREATE TABLE t (id INT NOT NULL, report_date DATE NOT NULL DEFAULT CURRENT_DATE)")
        .unwrap();
    eng.execute("INSERT INTO t (id) VALUES (1)").unwrap();
    let r = eng.execute("SELECT report_date FROM t").unwrap();
    let QueryResult::Rows { rows, .. } = r else {
        panic!()
    };
    assert!(matches!(rows[0].values[0], Value::Date(_)));
}

#[test]
fn literal_default_still_works() {
    let mut eng = engine_with_clock();
    eng.execute("CREATE TABLE t (id INT NOT NULL, name TEXT DEFAULT 'unset' NOT NULL)")
        .unwrap();
    eng.execute("INSERT INTO t (id) VALUES (1)").unwrap();
    let r = eng.execute("SELECT name FROM t").unwrap();
    let QueryResult::Rows { rows, .. } = r else {
        panic!()
    };
    assert_eq!(rows[0].values[0], Value::Text("unset".into()));
}

#[test]
fn multiple_runtime_defaults_in_same_row() {
    // mailrs accounts pattern: created_at + updated_at both DEFAULT now().
    let mut eng = engine_with_clock();
    eng.execute(
        "CREATE TABLE accounts (\
            id INT NOT NULL,\
            created_at TIMESTAMP NOT NULL DEFAULT now(),\
            updated_at TIMESTAMP NOT NULL DEFAULT now()\
        )",
    )
    .unwrap();
    eng.execute("INSERT INTO accounts (id) VALUES (42)")
        .unwrap();
    let r = eng
        .execute("SELECT created_at, updated_at FROM accounts")
        .unwrap();
    let QueryResult::Rows { rows, .. } = r else {
        panic!()
    };
    assert_eq!(rows[0].values[0], Value::Timestamp(fake_clock()));
    assert_eq!(rows[0].values[1], Value::Timestamp(fake_clock()));
}

#[test]
fn runtime_default_survives_catalog_snapshot() {
    let mut eng = engine_with_clock();
    eng.execute("CREATE TABLE t (id INT NOT NULL, created_at TIMESTAMP NOT NULL DEFAULT now())")
        .unwrap();
    let bytes = eng.snapshot();
    let cat = spg_storage::Catalog::deserialize(&bytes).unwrap();
    let col = &cat.get("t").unwrap().schema().columns[1];
    assert!(col.runtime_default.is_some());
}

#[test]
fn explicit_value_overrides_runtime_default() {
    let mut eng = engine_with_clock();
    eng.execute("CREATE TABLE t (id INT NOT NULL, created_at TIMESTAMP NOT NULL DEFAULT now())")
        .unwrap();
    // Explicit value wins over the default.
    eng.execute("INSERT INTO t (id, created_at) VALUES (1, '2020-01-01 00:00:00')")
        .unwrap();
    let r = eng.execute("SELECT created_at FROM t").unwrap();
    let QueryResult::Rows { rows, .. } = r else {
        panic!()
    };
    // Not the clock's value.
    assert_ne!(rows[0].values[0], Value::Timestamp(fake_clock()));
}