Function test_mixed_table_queries

tests/decimal_optimization_test.rs:114–128

()

#[test]
fn test_mixed_table_queries() {
    let conn = setup_test_db();
    
    // JOIN between decimal and non-decimal tables - should be rewritten
    let sql = "SELECT u.name, p.price 
               FROM users u 
               JOIN products p ON u.id = p.id 
               WHERE p.price > 50";
    let result = rewrite_query(&conn, sql).unwrap();
    println!("Mixed table query rewritten to: {result}");
    assert!(result.contains("decimal_gt"));
    
    // But operations on non-decimal columns should not be wrapped
    assert!(!result.contains("decimal_from_text(u.id)"));
}

#[test]
fn test_subquery_optimization() {