Function reject_dml_in_function_body

nodedb/tests/function_security_e2e.rs:56–66

()

/// DML in function body is rejected at CREATE time.
#[tokio::test(flavor = "multi_thread", worker_threads = 4)]
async fn reject_dml_in_function_body() {
    let server = TestServer::start().await;

    server
        .expect_error(
            "CREATE FUNCTION bad_func(x INT) RETURNS INT AS \
             BEGIN INSERT INTO t (id) VALUES (x); RETURN x; END",
            "side-effecting",
        )
        .await;
}

/// Procedural UDF with IF/ELSE compiles successfully.
#[tokio::test(flavor = "multi_thread", worker_threads = 4)]