Function test_correlated_subquery

tests/subquery_cte_test.rs:290–303

()

#[test]
fn test_correlated_subquery() {
    let conn = setup_test_db();
    
    let sql = "SELECT c.name, c.credit_limit,
               (SELECT MAX(o.total) 
                FROM orders o 
                WHERE o.customer_id = c.id AND o.total < c.credit_limit) as max_order
               FROM customers c";
    let result = rewrite_query(&conn, sql).unwrap();
    
    println!("Correlated subquery rewritten to: {result}");
    assert!(result.contains("decimal_lt"));
    assert!(result.contains("MAX"));
}

#[test]
fn test_exists_subquery() {