Function with_options

nodedb-sql/src/ddl_ast/parse/schedule.rs:227–242

()

    #[test]
    fn with_options() {
        let sql = "CREATE SCHEDULE agg CRON '*/5 * * * *' \
                   WITH (ALLOW_OVERLAP = false, MISSED = CATCH_UP) \
                   AS BEGIN INSERT INTO stats SELECT 1; END";
        if let NodedbStatement::Automation(AutomationStmt::CreateSchedule {
            allow_overlap,
            missed_policy,
            ..
        }) = create(sql)
        {
            assert!(!allow_overlap);
            assert_eq!(missed_policy, "CATCH_UP");
        } else {
            panic!("expected CreateSchedule");
        }
    }
}