Function test_exists_subquery

tests/subquery_cte_test.rs:306–322

()

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

#[test]
fn test_in_subquery() {