Function statement_and_row_triggers_coexist

nodedb/tests/trigger_execution.rs:330–355

()

#[test]
fn statement_and_row_triggers_coexist() {
    let reg = TriggerRegistry::new();
    // Row-level AFTER trigger.
    reg.register(make_trigger_full(
        "audit_row",
        "orders",
        TriggerTiming::After,
        true,
        false,
        false,
        TriggerExecutionMode::Async,
        TriggerGranularity::Row,
        TriggerSecurity::Invoker,
    ));
    // Statement-level AFTER trigger.
    reg.register(make_statement_trigger(
        "refresh_mv",
        "orders",
        DmlEvent::Insert,
        TriggerExecutionMode::Async,
    ));

    let matched = reg.get_matching(1, "orders", DmlEvent::Insert);
    assert_eq!(matched.len(), 2);
    // Both returned — caller filters by granularity.
}

// ---------------------------------------------------------------------------
// SECURITY DEFINER trigger storage