qail-pg 0.27.0

Fastest async PostgreSQL driver - AST to wire protocol, optional io_uring on Linux
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45

//! 3D Array Isolation Test
//! Tests 3D array BEFORE any NULL byte operations

use qail_pg::driver::PgDriver;

#[tokio::main]
async fn main() -> Result<(), Box<dyn std::error::Error>> {
    println!("🔬 3D Array Isolation Test");
    println!("{}", "━".repeat(40));

    let mut driver = PgDriver::connect("localhost", 5432, "orion", "postgres").await?;

    // Test 3D array FIRST (clean connection)
    println!("  1. 3D array (clean connection)...");
    let result = driver
        .execute_raw("SELECT ARRAY[[[1,2],[3,4]],[[5,6],[7,8]]]::INT[][][]")
        .await;
    match result {
        Ok(_) => println!("    ✓ 3D array: Works!"),
        Err(e) => println!("    ❌ 3D array: {}", e),
    }

    // Test 2D array for comparison
    println!("  2. 2D array...");
    let result = driver
        .execute_raw("SELECT ARRAY[[1,2,3],[4,5,6]]::INT[][]")
        .await;
    match result {
        Ok(_) => println!("    ✓ 2D array: Works"),
        Err(e) => println!("    ❌ 2D array: {}", e),
    }

    // Test 4D array (extreme case)
    println!("  3. 4D array (extreme)...");
    let result = driver.execute_raw("SELECT ARRAY[[[[1,2],[3,4]],[[5,6],[7,8]]],[[[9,10],[11,12]],[[13,14],[15,16]]]]::INT[][][][]").await;
    match result {
        Ok(_) => println!("    ✓ 4D array: Works"),
        Err(e) => println!("    ❌ 4D array: {}", e),
    }

    println!();
    println!("3D Array Test Complete.");

    Ok(())
}