Function test_parameter_limit

tests/protocol_edge_cases_test.rs:387–438

()

#[tokio::test]
async fn test_parameter_limit() {
    let server = setup_test_server_with_init(|db| {
        Box::pin(async move {
            // Create table with many columns
            let mut cols = Vec::new();
            for i in 1..=100 {
                cols.push(format!("col{i} INTEGER"));
            }
            
            db.execute(&format!(
                "CREATE TABLE many_params (id INTEGER PRIMARY KEY, {})",
                cols.join(", ")
            )).await?;
            
            Ok(())
        })
    }).await;
    
    let client = &server.client;
    
    // Test with many parameters (PostgreSQL supports up to 65535 parameters)
    // We'll test with 100 parameters
    let mut params: Vec<i32> = Vec::new();
    for i in 1..=101 {
        params.push(i);
    }
    
    let mut placeholders = Vec::new();
    let mut param_refs: Vec<&(dyn tokio_postgres::types::ToSql + Sync)> = Vec::new();
    
    for (i, param) in params.iter().enumerate().take(101) {
        placeholders.push(format!("${}", i + 1));
        param_refs.push(param);
    }
    
    let query = format!(
        "INSERT INTO many_params VALUES ({})", 
        placeholders.join(", ")
    );
    
    match client.execute(&query, &param_refs).await {
        Ok(n) => {
            assert_eq!(n, 1);
            println!("Successfully inserted with 101 parameters");
        }
        Err(e) => {
            println!("Failed with many parameters: {e}");
        }
    }
    
    server.abort();
}