spg-engine 7.37.23

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

//! v7.37.20 (20.7) — PL/pgSQL DECLARE with type inference from
//! the default expression (no explicit type token).

use spg_engine::Engine;

fn ddl(e: &mut Engine, sql: &str) {
    e.execute(sql)
        .unwrap_or_else(|err| panic!("{sql}: {err:?}"));
}

#[test]
fn declare_infer_int_from_default() {
    let mut e = Engine::new();
    ddl(
        &mut e,
        "DO $$ DECLARE x := 42; BEGIN ASSERT x = 42; END $$;",
    );
}

#[test]
fn declare_infer_text_from_default() {
    let mut e = Engine::new();
    ddl(
        &mut e,
        "DO $$ DECLARE msg := 'hello'; \
         BEGIN ASSERT msg = 'hello'; END $$;",
    );
}

#[test]
fn declare_infer_from_computed_expression() {
    let mut e = Engine::new();
    ddl(
        &mut e,
        "DO $$ DECLARE n := 10 + 5; \
         BEGIN ASSERT n = 15; END $$;",
    );
}

#[test]
fn declare_explicit_type_still_works() {
    let mut e = Engine::new();
    ddl(
        &mut e,
        "DO $$ DECLARE x INT := 100; \
         BEGIN ASSERT x = 100; END $$;",
    );
}