Function test_simple_subquery_in_select

tests/subquery_cte_test.rs:115–125

()

#[test]
fn test_simple_subquery_in_select() {
    let conn = setup_test_db();
    
    let sql = "SELECT name, (SELECT SUM(total) FROM orders WHERE customer_id = c.id) as total_orders 
               FROM customers c";
    let result = rewrite_query(&conn, sql).unwrap();
    
    println!("Subquery in SELECT rewritten to: {result}");
    assert!(result.contains("decimal_from_text"));
    assert!(result.contains("SUM"));
}

#[test]
fn test_subquery_with_arithmetic() {