Function test_complex_decimal_queries

tests/decimal_integration_test.rs:162–189

()

#[tokio::test]
async fn test_complex_decimal_queries() {
    let ctx = setup_test_db().await;
    
    // Insert test data
    ctx.execute(
        "INSERT INTO accounts (id, name, balance, credit_limit) VALUES
         (1, 'Account1', '1000.00', '5000.00'),
         (2, 'Account2', '2000.00', '10000.00')"
    ).await.unwrap();
    
    ctx.execute(
        "INSERT INTO transactions (account_id, amount, fee) VALUES
         (1, '100.00', '2.50'),
         (1, '200.00', '5.00'),
         (2, '150.00', '3.75')"
    ).await.unwrap();
    
    // Complex join with calculations
    let result = ctx.query(
        "SELECT a.name, a.balance + SUM(t.amount) - SUM(t.fee) as new_balance
         FROM accounts a
         JOIN transactions t ON a.id = t.account_id
         GROUP BY a.id, a.name, a.balance"
    ).await.unwrap();
    
    // The query should execute without errors
    assert!(!result.rows.is_empty());
}

#[tokio::test]
async fn test_update_with_decimal_operations() {