Function test_nested_ctes

tests/subquery_cte_test.rs:246–270

()

#[test]
fn test_nested_ctes() {
    let conn = setup_test_db();
    
    let sql = "WITH RECURSIVE 
               order_hierarchy AS (
                   SELECT id, total, 1 as level
                   FROM orders 
                   WHERE customer_id = 1
                   
                   UNION ALL
                   
                   SELECT o.id, o.total + oh.total, oh.level + 1
                   FROM orders o
                   JOIN order_hierarchy oh ON o.customer_id = 1
                   WHERE oh.level < 5
               )
               SELECT level, total 
               FROM order_hierarchy";
    let result = rewrite_query(&conn, sql).unwrap();
    
    println!("Recursive CTE rewritten to: {result}");
    
    // Recursive CTEs should still have decimal operations rewritten
    assert!(result.contains("decimal_add"));
}

#[test]
fn test_subquery_in_where_clause() {