Function test_in_subquery

tests/subquery_cte_test.rs:325–339

()

#[test]
fn test_in_subquery() {
    let conn = setup_test_db();
    
    let sql = "SELECT name 
               FROM customers 
               WHERE id IN (
                   SELECT customer_id 
                   FROM orders 
                   WHERE total > 500
               )";
    let result = rewrite_query(&conn, sql).unwrap();
    
    println!("IN subquery rewritten to: {result}");
    assert!(result.contains("decimal_gt"));
}

#[test]
fn test_expression_type_resolver_with_cte() {