Function mixed_plain_and_rollup

nodedb/tests/sql_grouping_sets.rs:288–331

()

/// ROLLUP adds (country) and () set variants.
#[tokio::test(flavor = "multi_thread", worker_threads = 4)]
async fn mixed_plain_and_rollup() {
    let server = TestServer::start().await;
    create_orders(&server).await;

    let rows = server
        .query_rows(
            "SELECT region, country, SUM(sales) AS total \
             FROM orders \
             GROUP BY region, ROLLUP (country)",
        )
        .await
        .unwrap();

    // ROLLUP(country) with plain region produces:
    // Set 1: (region, country) — 4 combos: AMER/US, AMER/CA, EMEA/DE, EMEA/FR
    // Set 2: (region) — 2 rows: AMER, EMEA (country=NULL)
    // Total = 6
    assert_eq!(
        rows.len(),
        6,
        "expected 6 rows for mixed plain+rollup, got {}: {:?}",
        rows.len(),
        rows
    );

    // region is NEVER NULL (it's a plain key, always present).
    for row in &rows {
        let region = row.first().map(|s| s.as_str()).unwrap_or("");
        assert!(
            !region.is_empty(),
            "region must never be NULL in mixed plain+rollup, but got: {row:?}"
        );
    }

    // ROLLUP suffix: rows with country=NULL represent regional subtotals.
    let regional = rows
        .iter()
        .filter(|r| r.get(1).map(|s| s.is_empty()).unwrap_or(false))
        .count();
    assert_eq!(
        regional, 2,
        "expected 2 regional subtotal rows (AMER, EMEA)"
    );
}

/// Empty grouping set `()` must produce exactly one grand-total row.
#[tokio::test(flavor = "multi_thread", worker_threads = 4)]