Function test_with_and_next_composition

graphlite/tests/pattern_tests.rs:811–1062

()

            Remove #[ignore] to test WITH patterns (Pattern 1 should work). \
            NEXT patterns (Pattern 2 & 3) may fail if NEXT not yet implemented."]
fn test_with_and_next_composition() {
    let fixture = TestFixture::with_fraud_data().expect("Failed to create test fixture");

    log::debug!("\n=== Testing WITH and NEXT Clause Composition ===\n");

    // Test 1: WITH clause chaining (intra-query transformation)
    // This tests MATCH -> WITH -> MATCH -> RETURN pattern
    log::debug!("Test 1: WITH clause chaining (intra-query)");
    let with_chain_query = "
        MATCH (a:Account)-[t:Transaction]->(m:Merchant)
        WITH a, m, count(t) as transaction_count, sum(t.amount) as total_spent
        WHERE transaction_count > 5
        MATCH (m)<-[:Transaction]-(other:Account)
        WHERE other <> a
        RETURN a.account_number as account_id,
               m.name as merchant_name,
               transaction_count,
               total_spent,
               count(DISTINCT other) as fellow_customers
        ORDER BY total_spent DESC
        LIMIT 10
    ";

    let with_result = fixture.query(with_chain_query);
    match &with_result {
        Ok(r) => {
            log::debug!("✅ WITH chaining works: {} rows", r.rows.len());
            assert!(r.rows.len() <= 10, "LIMIT 10 should be respected");

            // Verify expected columns
            if let Some(first_row) = r.rows.first() {
                assert!(
                    first_row.values.contains_key("account_id"),
                    "Should have account_id"
                );
                assert!(
                    first_row.values.contains_key("merchant_name"),
                    "Should have merchant_name"
                );
                assert!(
                    first_row.values.contains_key("transaction_count"),
                    "Should have transaction_count"
                );
                assert!(
                    first_row.values.contains_key("total_spent"),
                    "Should have total_spent"
                );
                assert!(
                    first_row.values.contains_key("fellow_customers"),
                    "Should have fellow_customers"
                );

                log::debug!("  Sample row: account={:?}, merchant={:?}, tx_count={:?}, total={:?}, fellow={:?}",
                    first_row.values.get("account_id"),
                    first_row.values.get("merchant_name"),
                    first_row.values.get("transaction_count"),
                    first_row.values.get("total_spent"),
                    first_row.values.get("fellow_customers")