veloq-query 0.2.2

DuckDB-backed query helpers shared by VeloQ profile backends.
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

/// SQL window-count expression for list queries that carry
/// `total_matched` on each returned row.
pub fn total_matched_expr() -> &'static str {
    "COUNT(*) OVER () AS total_matched"
}

/// SQL window-count expression forced to DuckDB BIGINT.
pub fn total_matched_bigint_expr() -> &'static str {
    "CAST(COUNT(*) OVER () AS BIGINT) AS total_matched"
}

#[cfg(test)]
mod tests {
    use super::*;

    #[test]
    fn total_matched_expr_keeps_wire_alias() {
        assert_eq!(total_matched_expr(), "COUNT(*) OVER () AS total_matched");
    }

    #[test]
    fn total_matched_bigint_expr_keeps_wire_alias_and_cast() {
        assert_eq!(
            total_matched_bigint_expr(),
            "CAST(COUNT(*) OVER () AS BIGINT) AS total_matched"
        );
    }
}