Function test_subquery_optimization

tests/decimal_optimization_test.rs:131–143

()

#[test]
fn test_subquery_optimization() {
    let conn = setup_test_db();
    
    // Subquery with only non-decimal tables
    let sql = "SELECT * FROM users WHERE id IN (SELECT parent_id FROM categories)";
    let result = rewrite_query(&conn, sql).unwrap();
    assert_eq!(result, "SELECT * FROM users WHERE id IN (SELECT parent_id FROM categories)");
    
    // Subquery with decimal table
    let sql = "SELECT * FROM users WHERE id IN (SELECT id FROM products WHERE price > 100)";
    let result = rewrite_query(&conn, sql).unwrap();
    assert!(result.contains("decimal_gt"));
}

#[test]
fn test_update_delete_optimization() {