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

//! String concatenation edge case tests
//!
//! Tests for string concatenation including empty strings,
//! NULL handling, and complex multi-part concatenations.

use super::operator_test_utils::*;

#[test]
fn test_string_concat_basic() {
    let db = vibesql_storage::Database::new();
    let expr = vibesql_ast::Expression::BinaryOp {
        left: Box::new(vibesql_ast::Expression::Literal(vibesql_types::SqlValue::Varchar(
            arcstr::ArcStr::from("Hello"),
        ))),
        op: vibesql_ast::BinaryOperator::Concat,
        right: Box::new(vibesql_ast::Expression::Literal(vibesql_types::SqlValue::Varchar(
            arcstr::ArcStr::from(" World"),
        ))),
    };
    assert_expression_result(
        &db,
        expr,
        vibesql_types::SqlValue::Varchar(arcstr::ArcStr::from("Hello World")),
    );
}

#[test]
fn test_string_concat_empty() {
    let db = vibesql_storage::Database::new();
    let expr = vibesql_ast::Expression::BinaryOp {
        left: Box::new(vibesql_ast::Expression::Literal(vibesql_types::SqlValue::Varchar(
            arcstr::ArcStr::from("Hello"),
        ))),
        op: vibesql_ast::BinaryOperator::Concat,
        right: Box::new(vibesql_ast::Expression::Literal(vibesql_types::SqlValue::Varchar(
            arcstr::ArcStr::from(""),
        ))),
    };
    assert_expression_result(
        &db,
        expr,
        vibesql_types::SqlValue::Varchar(arcstr::ArcStr::from("Hello")),
    );
}

#[test]
fn test_string_concat_null() {
    let db = vibesql_storage::Database::new();
    let expr = vibesql_ast::Expression::BinaryOp {
        left: Box::new(vibesql_ast::Expression::Literal(vibesql_types::SqlValue::Varchar(
            arcstr::ArcStr::from("Hello"),
        ))),
        op: vibesql_ast::BinaryOperator::Concat,
        right: Box::new(vibesql_ast::Expression::Literal(vibesql_types::SqlValue::Null)),
    };
    assert_expression_result(&db, expr, vibesql_types::SqlValue::Null);
}

#[test]
fn test_string_concat_multiple() {
    let db = vibesql_storage::Database::new();

    // "Hello" || " " || "Beautiful" || " " || "World"
    let expr = vibesql_ast::Expression::BinaryOp {
        left: Box::new(vibesql_ast::Expression::BinaryOp {
            left: Box::new(vibesql_ast::Expression::BinaryOp {
                left: Box::new(vibesql_ast::Expression::BinaryOp {
                    left: Box::new(vibesql_ast::Expression::Literal(
                        vibesql_types::SqlValue::Varchar(arcstr::ArcStr::from("Hello")),
                    )),
                    op: vibesql_ast::BinaryOperator::Concat,
                    right: Box::new(vibesql_ast::Expression::Literal(
                        vibesql_types::SqlValue::Varchar(arcstr::ArcStr::from(" ")),
                    )),
                }),
                op: vibesql_ast::BinaryOperator::Concat,
                right: Box::new(vibesql_ast::Expression::Literal(
                    vibesql_types::SqlValue::Varchar(arcstr::ArcStr::from("Beautiful")),
                )),
            }),
            op: vibesql_ast::BinaryOperator::Concat,
            right: Box::new(vibesql_ast::Expression::Literal(vibesql_types::SqlValue::Varchar(
                arcstr::ArcStr::from(" "),
            ))),
        }),
        op: vibesql_ast::BinaryOperator::Concat,
        right: Box::new(vibesql_ast::Expression::Literal(vibesql_types::SqlValue::Varchar(
            arcstr::ArcStr::from("World"),
        ))),
    };

    assert_expression_result(
        &db,
        expr,
        vibesql_types::SqlValue::Varchar(arcstr::ArcStr::from("Hello Beautiful World")),
    );
}