Function test_debug_with_clause_issue

graphlite/tests/match_with_tests.rs:1852–1918

()

#[test]
fn test_debug_with_clause_issue() {
    let fixture = TestFixture::empty().expect("Failed to create test fixture");

    // Create test graph
    fixture
        .query(&format!(
            "CREATE SCHEMA IF NOT EXISTS /{}",
            fixture.schema_name()
        ))
        .unwrap();
    fixture
        .query(&format!(
            "CREATE GRAPH /{}/debug_with",
            fixture.schema_name()
        ))
        .unwrap();
    fixture
        .query(&format!(
            "SESSION SET GRAPH /{}/debug_with",
            fixture.schema_name()
        ))
        .unwrap();

    // Insert a user
    fixture.assert_query_succeeds("INSERT (user1:User {id: 1, name: 'Alice', score: 100})");

    // Test 1: Simple MATCH - verify node properties exist
    let result = fixture
        .query("MATCH (u:User) RETURN u.id as id, u.name as name, u.score as score")
        .unwrap();
    assert_eq!(
        result.rows[0].values.get("id").unwrap(),
        &Value::Number(1.0)
    );
    assert_eq!(
        result.rows[0].values.get("name").unwrap(),
        &Value::String("Alice".to_string())
    );
    assert_eq!(
        result.rows[0].values.get("score").unwrap(),
        &Value::Number(100.0)
    );

    // Test 2: MATCH with WITH but no INSERT - does WITH preserve node properties?
    let result = fixture.query(
        "MATCH (u:User {name: 'Alice'})
         WITH u, u.name as user_name, u.score as user_score
         RETURN u.id as user_id, user_name, user_score",
    );

    match result {
        Ok(query_result) => {
            if query_result.rows.is_empty() {
                // Let's try a simpler WITH clause
                let simple_result =
                    fixture.query("MATCH (u:User {name: 'Alice'}) WITH u RETURN u.id as user_id");
                match simple_result {
                    Ok(simple_query_result) => if simple_query_result.rows.is_empty() {},