Function copy_csv_header_false

nodedb/tests/sql_copy_from.rs:161–183

()

#[tokio::test]
async fn copy_csv_header_false() {
    let srv = TestServer::start().await;

    // Use a schemaless collection so positional column names (col_0, col_1)
    // are accepted without conflict with a declared schema.
    srv.exec("CREATE COLLECTION copy_noheader_test")
        .await
        .expect("CREATE COLLECTION");

    // Three rows, no header — columns become col_0, col_1 (positional names).
    // Distinct first-column values ensure no key collision.
    let csv = "alice,9.5\nbob,8.1\ncarol,7.7\n";
    let f = write_temp(csv, ".csv");
    let path = f.path().to_string_lossy().to_string();

    srv.exec(&format!(
        "COPY copy_noheader_test FROM '{path}' WITH (FORMAT csv, HEADER false)"
    ))
    .await
    .expect("COPY CSV HEADER false");

    assert_eq!(count_rows(&srv, "copy_noheader_test").await, 3);
}

// ── test 7: path with .. rejected ────────────────────────────────────────────