vibesql-executor 0.2.0

Query execution engine for vibesql SQL database
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
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118

//! Unary operator edge case tests
//!
//! Tests for unary plus and minus operators on various types,
//! including NULL propagation and type validation.

use super::operator_test_utils::*;

#[test]
fn test_unary_plus_integer() {
    let db = vibesql_storage::Database::new();
    let expr = vibesql_ast::Expression::UnaryOp {
        op: vibesql_ast::UnaryOperator::Plus,
        expr: Box::new(vibesql_ast::Expression::Literal(vibesql_types::SqlValue::Integer(42))),
    };
    assert_expression_result(&db, expr, vibesql_types::SqlValue::Integer(42));
}

#[test]
fn test_unary_plus_float() {
    let db = vibesql_storage::Database::new();
    let expr = vibesql_ast::Expression::UnaryOp {
        op: vibesql_ast::UnaryOperator::Plus,
        expr: Box::new(vibesql_ast::Expression::Literal(vibesql_types::SqlValue::Float(3.5))),
    };
    assert_expression_result(&db, expr, vibesql_types::SqlValue::Float(3.5));
}

#[test]
fn test_unary_minus_integer() {
    let db = vibesql_storage::Database::new();
    let expr = vibesql_ast::Expression::UnaryOp {
        op: vibesql_ast::UnaryOperator::Minus,
        expr: Box::new(vibesql_ast::Expression::Literal(vibesql_types::SqlValue::Integer(42))),
    };
    assert_expression_result(&db, expr, vibesql_types::SqlValue::Integer(-42));
}

#[test]
fn test_unary_minus_negative() {
    let db = vibesql_storage::Database::new();
    let expr = vibesql_ast::Expression::UnaryOp {
        op: vibesql_ast::UnaryOperator::Minus,
        expr: Box::new(vibesql_ast::Expression::Literal(vibesql_types::SqlValue::Integer(-42))),
    };
    assert_expression_result(&db, expr, vibesql_types::SqlValue::Integer(42));
}

#[test]
fn test_unary_minus_numeric_string() {
    let db = vibesql_storage::Database::new();
    let expr = vibesql_ast::Expression::UnaryOp {
        op: vibesql_ast::UnaryOperator::Minus,
        expr: Box::new(vibesql_ast::Expression::Literal(vibesql_types::SqlValue::Numeric(123.45))),
    };
    assert_expression_result(&db, expr, vibesql_types::SqlValue::Numeric(-123.45));
}

#[test]
fn test_unary_minus_negative_numeric() {
    let db = vibesql_storage::Database::new();
    let expr = vibesql_ast::Expression::UnaryOp {
        op: vibesql_ast::UnaryOperator::Minus,
        expr: Box::new(vibesql_ast::Expression::Literal(vibesql_types::SqlValue::Numeric(-123.45))),
    };
    assert_expression_result(&db, expr, vibesql_types::SqlValue::Numeric(123.45));
}

#[test]
fn test_unary_plus_null() {
    let db = vibesql_storage::Database::new();
    let expr = vibesql_ast::Expression::UnaryOp {
        op: vibesql_ast::UnaryOperator::Plus,
        expr: Box::new(vibesql_ast::Expression::Literal(vibesql_types::SqlValue::Null)),
    };
    assert_expression_result(&db, expr, vibesql_types::SqlValue::Null);
}

#[test]
fn test_unary_minus_null() {
    let db = vibesql_storage::Database::new();
    let expr = vibesql_ast::Expression::UnaryOp {
        op: vibesql_ast::UnaryOperator::Minus,
        expr: Box::new(vibesql_ast::Expression::Literal(vibesql_types::SqlValue::Null)),
    };
    assert_expression_result(&db, expr, vibesql_types::SqlValue::Null);
}

#[test]
fn test_unary_plus_text() {
    // SQLite behavior: unary + on text returns text unchanged (identity operation)
    let db = vibesql_storage::Database::new();
    let expr = vibesql_ast::Expression::UnaryOp {
        op: vibesql_ast::UnaryOperator::Plus,
        expr: Box::new(vibesql_ast::Expression::Literal(vibesql_types::SqlValue::Varchar(
            arcstr::ArcStr::from("hello"),
        ))),
    };
    assert_expression_result(
        &db,
        expr,
        vibesql_types::SqlValue::Varchar(arcstr::ArcStr::from("hello")),
    );
}

/// SQLite behavior: unary minus on non-numeric strings converts to 0
/// -"hello" → -0 → 0 (string_to_number("hello") returns 0)
#[test]
fn test_unary_minus_string_converts_to_zero() {
    let db = vibesql_storage::Database::new();
    let expr = vibesql_ast::Expression::UnaryOp {
        op: vibesql_ast::UnaryOperator::Minus,
        expr: Box::new(vibesql_ast::Expression::Literal(vibesql_types::SqlValue::Varchar(
            arcstr::ArcStr::from("hello"),
        ))),
    };
    // SQLite converts non-numeric strings to 0, then negates: -0 = 0
    assert_expression_result(&db, expr, vibesql_types::SqlValue::Integer(0));
}