Function test_cte_optimization

tests/decimal_optimization_test.rs:172–191

()

#[test]
fn test_cte_optimization() {
    let conn = setup_test_db();
    
    // CTE with only non-decimal tables
    let sql = "WITH active_users AS (
                   SELECT * FROM users WHERE active = 1
               )
               SELECT * FROM active_users WHERE age > 30";
    let result = rewrite_query(&conn, sql).unwrap();
    // Should remain unchanged
    assert!(!result.contains("decimal_"));
    
    // CTE with decimal table
    let sql = "WITH expensive_products AS (
                   SELECT * FROM products WHERE price > 100
               )
               SELECT * FROM expensive_products";
    let result = rewrite_query(&conn, sql).unwrap();
    assert!(result.contains("decimal_gt"));
}

#[test]
fn test_union_optimization() {