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
49
50
51
52

//! v7.37.20 (20.15) — PL/pgSQL FOUND special variable set after
//! SELECT INTO returns.

use spg_engine::Engine;

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

#[test]
fn found_true_after_select_into_matches() {
    let mut e = Engine::new();
    ddl(&mut e, "CREATE TABLE t (id INT)");
    ddl(&mut e, "INSERT INTO t VALUES (42)");
    ddl(
        &mut e,
        "DO $$ DECLARE x INT; found BOOL := FALSE; \
         BEGIN SELECT id INTO x FROM t WHERE id = 42; \
         ASSERT found = TRUE; END $$;",
    );
}

#[test]
fn found_false_after_select_into_misses() {
    let mut e = Engine::new();
    ddl(&mut e, "CREATE TABLE t (id INT)");
    ddl(&mut e, "INSERT INTO t VALUES (1)");
    ddl(
        &mut e,
        "DO $$ DECLARE x INT; found BOOL := TRUE; \
         BEGIN SELECT id INTO x FROM t WHERE id = 999; \
         ASSERT found = FALSE; END $$;",
    );
}

#[test]
fn found_switches_across_multiple_select_into() {
    let mut e = Engine::new();
    ddl(&mut e, "CREATE TABLE t (id INT)");
    ddl(&mut e, "INSERT INTO t VALUES (10)");
    ddl(
        &mut e,
        "DO $$ DECLARE x INT; found BOOL := FALSE; \
         BEGIN \
             SELECT id INTO x FROM t WHERE id = 10; \
             ASSERT found = TRUE; \
             SELECT id INTO x FROM t WHERE id = 999; \
             ASSERT found = FALSE; \
         END $$;",
    );
}