Function test_union_optimization

tests/decimal_optimization_test.rs:194–210

()

#[test]
fn test_union_optimization() {
    let conn = setup_test_db();
    
    // UNION of non-decimal tables
    let sql = "SELECT name FROM users 
               UNION 
               SELECT name FROM categories";
    let result = rewrite_query(&conn, sql).unwrap();
    assert!(!result.contains("decimal_"));
    
    // UNION involving decimal table
    let sql = "SELECT name FROM users 
               UNION 
               SELECT name FROM products WHERE price > 50";
    let result = rewrite_query(&conn, sql).unwrap();
    assert!(result.contains("decimal_gt"));
}