Function test_insert_select_with_decimal

tests/decimal_integration_test.rs:215–236

()

#[tokio::test]
async fn test_insert_select_with_decimal() {
    let ctx = setup_test_db().await;
    
    // Create source data
    ctx.execute(
        "INSERT INTO accounts (id, name, balance, credit_limit) VALUES
         (1, 'Source', '1000.00', '5000.00')"
    ).await.unwrap();
    
    // Insert with calculations
    let result = ctx.execute(
        "INSERT INTO accounts (name, balance, credit_limit)
         SELECT name || '_copy', balance * 0.5, credit_limit * 0.5
         FROM accounts WHERE id = 1"
    ).await.unwrap();
    
    assert_eq!(result.rows_affected, 1);
    
    // Verify the insert
    let result = ctx.query("SELECT COUNT(*) FROM accounts").await.unwrap();
    assert_eq!(result.rows.len(), 1);
}

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