nodedb-sql 0.6.2

SQL parser, planner, and optimizer for NodeDB
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

// SPDX-License-Identifier: Apache-2.0

//! Sequence accessor registrations: `nextval`, `currval`, `setval`.
//!
//! These are `Scalar` and `Volatile` at once. `Volatile` keeps the constant
//! folder from freezing a call into a literal and keeps a plan holding one
//! out of the plan cache, so each execution allocates a fresh value.
//! `nodedb_sql::planner::catalog_expr_fold` routes each call to the
//! `SqlCatalog` sequence methods at plan time.

use nodedb_types::columnar::ColumnType;

use crate::functions::arg_types;
use crate::functions::registry::{FunctionCategory::Scalar, FunctionMeta};

use super::super::helpers::{m, no_trigger};

pub(super) fn sequence_fn_functions() -> Vec<FunctionMeta> {
    vec![
        m(
            "nextval",
            Scalar,
            1,
            1,
            no_trigger(),
            Some(ColumnType::Int64),
            arg_types::SEQUENCE_NAME_ARGS,
        )
        .volatile(),
        m(
            "currval",
            Scalar,
            1,
            1,
            no_trigger(),
            Some(ColumnType::Int64),
            arg_types::SEQUENCE_NAME_ARGS,
        )
        .volatile(),
        m(
            "setval",
            Scalar,
            2,
            2,
            no_trigger(),
            Some(ColumnType::Int64),
            arg_types::SETVAL_ARGS,
        )
        .volatile(),
    ]
}