Function recursive_cte_generates_sequence

nodedb/tests/sql_recursive_cte.rs:18–48

()

/// must produce exactly 5 rows with values 1..5.
#[tokio::test(flavor = "multi_thread", worker_threads = 4)]
async fn recursive_cte_generates_sequence() {
    let server = TestServer::start().await;

    let rows = server
        .query_text(
            "WITH RECURSIVE c(n) AS (\
                SELECT 1 \
                UNION ALL \
                SELECT n + 1 FROM c WHERE n < 5\
             ) \
             SELECT n FROM c",
        )
        .await;

    let values = rows.expect("recursive CTE counter should succeed");
    assert_eq!(
        values.len(),
        5,
        "recursive CTE should produce 5 rows (1..5): got {values:?}"
    );
    let mut nums: Vec<i64> = values
        .iter()
        .map(|v| v.trim().parse().expect("expected i64 row value"))
        .collect();
    nums.sort();
    assert_eq!(
        nums,
        vec![1, 2, 3, 4, 5],
        "rows should be 1..5: got {nums:?}"
    );
}

// ── Test 2: UNION ALL preserves duplicates ────────────────────────────────────