Function test_multiple_ctes

tests/subquery_cte_test.rs:218–243

()

#[test]
fn test_multiple_ctes() {
    let conn = setup_test_db();
    
    let sql = "WITH 
               high_value_customers AS (
                   SELECT customer_id 
                   FROM orders 
                   GROUP BY customer_id 
                   HAVING SUM(total) > 5000
               ),
               customer_discounts AS (
                   SELECT c.id, c.discount_rate * 0.01 as discount_decimal
                   FROM customers c
               )
               SELECT 
                   c.name,
                   cd.discount_decimal
               FROM customers c
               JOIN high_value_customers hvc ON c.id = hvc.customer_id
               JOIN customer_discounts cd ON c.id = cd.id";
    let result = rewrite_query(&conn, sql).unwrap();
    
    println!("Multiple CTEs rewritten to: {result}");
    assert!(result.contains("decimal_mul"));
    assert!(result.contains("decimal_gt"));
}

#[test]
fn test_nested_ctes() {