Function test_subquery_with_arithmetic

tests/subquery_cte_test.rs:128–138

()

#[test]
fn test_subquery_with_arithmetic() {
    let conn = setup_test_db();
    
    let sql = "SELECT name, 
               (SELECT SUM(total + tax) FROM orders WHERE customer_id = c.id) as total_with_tax 
               FROM customers c";
    let result = rewrite_query(&conn, sql).unwrap();
    
    println!("Subquery with arithmetic rewritten to: {result}");
    assert!(result.contains("decimal_add"));
}

#[test]
fn test_derived_table_subquery() {